Refound your company for the AI era at ZapConnect 2026. Save your spot →

Airtable + Google BigQuery

Airtable + Google BigQuery integrations

Create rows in Google BigQuery for new or updated Airtable records

Keep your data up-to-date with this convenient workflow that connects Airtable and Google BigQuery. Whenever a new or updated record appears in Airtable, a corresponding row will be created in Google BigQuery. This seamless integration ensures your databases stay synchronized without any manual effort, allowing you to focus on more important tasks.

When this happens...
New or Updated RecordTriggers when a record is created or updated.
TriggerPolling
automatically do this!
Create RowCreates a new row of data in a table. 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 Airtable and Google BigQuery

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

- Base
  Required
- Table
  Required
- Limit to View
- Include attachment content
- Include empty fields
Trigger
Polling
Try It
- Base
  Required
- Table
  Required
- Record
  Required
- Comment
  Required
Action
Write
- CacheCopy
- Base
  Required
- Table
  Required
Action
Write
- RequirementsNotice
- HyperDB table ID
  Required
- ClearValueNotice
Action
Write
- Base
  Required
- Table Name
  Required
- Table Description
- Primary Field Name
- Primary Field Type
Action
Write

- RequirementsNotice
- HyperDB table ID
  Required
- Primary keys
  Required
- ConfirmationNotice
- Delete confirmation
  Required
Action
Write
- Base
  Required
- Table
  Required
- Number of Records
  Required
Action
Write

- Base
  Required
- Table
  Required
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search
- Base
  Required
- Search Keyword
  Required
- Search In
Action
Search
- Search Keyword
  Required
Action
Search
- Base
  Required
- Table
  Required
Action
Search
- RequirementsNotice
- HyperDB table ID
  Required
- Primary keys
- Maximum records to return
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
- Api_docs_info
- 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

- Help Text
- Base
  Required
- Table
  Required
- Last modified time column
  Required
- Limit to view
- Include file contents?
- Include empty fields
Trigger
Polling
Try It
- Base
  Required
- Table
  Required
Action
Write
- Name
  Required
- Workspace ID
  Required
- Number of Tables
  Required
Action
Write
- Base
  Required
- Table
  Required
- Helptext
- Primary lookup field
  Required
- Secondary lookup field
- Append attachments
Action
Write
- Base
  Required
- Table
  Required
- Record
  Required
Action
Write
- Base
  Required
- Table
  Required
- Record
  Required
- Append attachments
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Base
  Required
- Table
  Required
- Record ID
  Required
Action
Search
- Base
  Required
- Table ID
  Required
Action
Search
- Base ID
  Required
Action
Search
- Base
  Required
Action
Search
- Base
  Required
- Table
  Required
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
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

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

Related categories

Databases

Similar apps

Quickbase

App Builder

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

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

Related Zap Templates

Create Google BigQuery rows from new Airtable records

Create or update Airtable records every time new rows are added in Google BigQuery

Update rows in Google BigQuery and correspondingly update records in Airtable