Google BigQuery + Notion

Create rows in Google BigQuery for new database items in Notion

Stay organized and productive with this workflow that links Notion to Google BigQuery. When a new item is added to your Notion database, this automation swiftly creates corresponding rows in Google BigQuery. Efficiently manage your data, reduce manual task repetition and streamline your database operations for improved productivity.

When this happens...
TriggerPolling
automatically do this!
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

- Database
- Data Source
- Page
Trigger
Instant
Try It
- Data SourceRequired
Trigger
Instant
Try It
- PageRequired
Trigger
Instant
Try It
- PageRequired
- Block TypeRequired
- Content
- Programming Language
- Checked
- Icon (Emoji)
Action
Write
- PageRequired
- CommentRequired
Action
Write

- Parent PageRequired
- Title
- Content
- Icon
- Cover
Action
Write
- Item IDRequired
Action
Write

- Data Source
- ItemRequired
- Content
- Content Format
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- 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
- PageRequired
Action
Search
- Block IDRequired
Action
Search
- Page IDRequired
Action
Search
- TitleRequired
- Exact MatchRequired
Action
Search
- Data Source
- Advanced Query (JSON)
Action
Search
- Data Source
- Template Mode
Action
Search or write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Polling
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write

- Data SourceRequired
Trigger
Instant
Try It
- Data SourceRequired
Trigger
Instant
Try It
- Data Source
- PageRequired
- Properties to Watch
Trigger
Instant
Try It
- Data Source
- ItemRequired
Action
Write
- Data Source
- Template Mode
Action
Write
- PageRequired
- ContentRequired
- Content Format
Action
Write
- DatabaseRequired
- Title
- Move To
- Display Inline
- Icon (Emoji)
- Move to Trash
- Lock Database
Action
Write
- Data SourceRequired
- Title
- Icon Emoji
- Property Updates (JSON)
Action
Write
Retrieve Database
This action retrieves a database in Notion using the ID of the database.
Action
Write
- Block IdRequired
Action
Search
- Data Source
Action
Search
- Block IDRequired
- Page Size
- Start Cursor
Action
Search
- Page or Database Item IDRequired
Action
Search
- PageRequired
- PropertyRequired
Action
Search
- UserRequired
Action
Search
- ProjectRequired
- Dataset
- Table
Trigger
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
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 more

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.

Related categories

Task Management

Related Zap Templates

Update Google BigQuery rows instantly when Notion database items are updated

Google BigQuery + Notion

Create rows in Google BigQuery for new database items in Notion

New Comment

Updated Content in Data Source Item

Updated Content in Page

Add Block to Page

Add Comment

Create Page

Restore Data Source Item

Update Data Source Item

API Request (Beta)

Retrieve a Page

Get Page Comments

Get Block

Get Page and Children

Find Page (By Title)

Query Data Source (Advanced)

Find or Create Database Item

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

New Data Source Item

Updated Properties in Data Source Item

Updated Properties on a Page

Archive Data Source Item

Create Data Source Item

Add Content to Page

Update Database

Update Data Source Schema

Retrieve Database

Retrieve Block Children

Find Data Source Items

Get Block Children

Get Page or Data Source Item by ID

Get Page Property

Get User Details

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

About Google BigQuery

Related categories

About Notion

Related categories

Related Zap Templates

Related Zap Templates