Google BigQuery + Notion

Google BigQuery + Notion integrations

Update Google BigQuery rows each time Notion database items are updated

Streamline your data updates with this efficient workflow. When a change occurs in your Notion database, it propels a corresponding update, creating new rows in your Google BigQuery. This seamless connection ensures your BigQuery analytics reflect the most current data, enabling prompt decisions and actions. Stay up-to-date, saving time and enhancing productivity with this simple yet powerful integration.

When this happens...
TriggerPolling
automatically do this!
Create RowsCreates new rows of data in a table (accepts line items). Note: Does not create a job.
ActionWrite

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 Notion and Google BigQuery

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

- 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
- 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

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

Databases

Google

Premium

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

Create rows in Google BigQuery for new database items in Notion