Skip to content

Google BigQuery + Notion

Google BigQuery + Notion

Google BigQuery + Notion integrations

Create database items in Notion from new rows in Google BigQuery

With this workflow, as soon as new data is added to your Google BigQuery, it creates a corresponding entry in your Notion database. This seamless integration is brilliant for maintaining real-time data updates between your BigQuery and Notion. This way, managing and tracking all your data records becomes easier and more streamlined.

When this happens...
New RowTriggers when a new row is added to a table. We know when a new row is added whenthe table is sorted by a column and the latest row is different from the previous latest row.
TriggerPolling
automatically do this!
Create Data Source ItemCreates an item in a data source.
ActionWrite

Start free with email

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google BigQuery and Notion

Discover other triggers and actions you can use with Google BigQuery and Notion

- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write

- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

- Database
- Data Source
- Page
Trigger
Instant
Try It
- Data Source
  Required
Trigger
Instant
Try It
- Page
  Required
Trigger
Instant
Try It
- Page
  Required
- Block Type
  Required
- Content
- Programming Language
- Checked
- Icon (Emoji)
Action
Write
- Page
  Required
- Comment
  Required
Action
Write
- Parent_page
  Required
- Title
- Content
- Icon
- Cover
Action
Write
- Item ID
  Required
Action
Write
- Data Source
- Item
  Required
- Content
- Content Format
Action
Write
- File_upload_note
- Data Source
  Required
- Item
  Required
- File Property
  Required
- File
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
Retrieve a Page
This action retrieves a specific page from Notion using its ID. The page id can be a normal page or a database item.
Action
Write
- Page
  Required
Action
Search
- Block ID
  Required
Action
Search
- Page ID
  Required
Action
Search
- Title
  Required
- Exact_match
  Required
Action
Search
- Data Source
- Advanced Query (JSON)
Action
Search
- Data Source
- Template Mode
Action
Search or write

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write
- Data Source
  Required
Trigger
Instant
Try It
- Data Source
  Required
Trigger
Instant
Try It
- Data Source
- Page
  Required
- Properties to Watch
Trigger
Instant
Try It
- Data Source
- Item
  Required
Action
Write
- Data Source
- Template Mode
Action
Write
- Page
  Required
- Content
  Required
- Content Format
Action
Write
- Database
  Required
- Title
- Move To
- Display Inline
- Icon (Emoji)
- Move to Trash
- Lock Database
Action
Write
- Data Source
  Required
- Title
- Icon Emoji
- Property Updates (JSON)
Action
Write
- File_upload_note
- Page (or Block) ID
  Required
- File
  Required
Action
Write
Retrieve Database
This action retrieves a database in Notion using the ID of the database.
Action
Write
- BlockId
  Required
Action
Search
- Data Source
Action
Search
- Block ID
  Required
- Page Size
- Start Cursor
Action
Search
- Page or Database Item ID
  Required
Action
Search
- Page
  Required
- Property
  Required
Action
Search
- User
  Required
Action
Search

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn moreLearn moreHelpHelp

Related categories

About Notion

A new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.

Learn moreLearn moreHelpHelp

Related categories

Task Management

Related Zap Templates

Related Zap Templates

Create rows in Google BigQuery for new database items in Notion