Airtable + Google BigQuery

Create rows in Google BigQuery for new or updated records from Airtable

Simplify the management of your data by bringing together Airtable and Google BigQuery with this workflow. Upon an addition or modification in an Airtable record, a corresponding row is instantly created in Google BigQuery. This seamless automation ensures no data goes unnoticed, thereby helping you stay on top of the key developments in your datasets with lesser manual intervention.

When this happens...
New or Updated Record
Triggers when a record is created or updated.
TriggerScheduled
automatically do this!
Create Rows
Creates 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

Start free with email

Start free with Google

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

Supported triggers and actions

- BaseRequired
- TableRequired
- Limit to View
- Include attachment content
Trigger
Scheduled
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Help Text
- Primary lookup fieldRequired
- Secondary lookup field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Field to search
- Search value
- Search type
- Search formula (advanced)
- Limit to view
- Include attachment content
- Max records
Action
Search

- BaseRequired
- TableRequired
- Field to search
- Search value
- Search type
- Search formula (advanced)
- Limit to view
- Include attachment content
- Max records
Action
Search or write
- ProjectRequired
- Dataset
- Table
Trigger
Scheduled
Try It

- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
- LimitRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write

- Help Text
- BaseRequired
- TableRequired
- Last modified time columnRequired
- Limit to view
- Include file contents?
Trigger
Scheduled
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search or write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Scheduled
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Scheduled
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
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more