Skip to content

Google BigQuery + Zapier Tables

Google BigQuery + Zapier Tables

Google BigQuery + Zapier Tables integrations

Create rows in Google BigQuery from new or updated records in Zapier Tables

Whenever you have new or updated records in your Zapier Tables, this workflow creates a corresponding row in Google BigQuery, keeping your data analysis current and comprehensive. It's a perfect solution for those managing vast amounts of data, ensuring everything is organized and up-to-date with minimal effort. Always stay abreast of your latest records without the need to manually transfer the data.

When this happens...
New or Updated RecordTriggers when a record is added or updated on a table.
TriggerInstant
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 email

Start free with Google

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

More things you can do with Zapier Tables and Google BigQuery

Discover other triggers and actions you can use with Zapier Tables and Google BigQuery

- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Trigger
Instant
Try It
- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Trigger
Instant
Try It
- Table ID
  Required
- Field
  Required
- Summary Formula
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Trigger
Instant
Try It
- Table ID
  Required
- Calculate Field
  Required
- Aggregate Function
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Action
Write
- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Action
Write

- Table ID
  Required
- Name
- Description
Action
Write
- Table ID
  Required
- Record ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Action
Write

- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Action
Search
- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
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

- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Trigger
Instant
Try It
- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Trigger
Instant
Try It
- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Trigger
Instant
Try It
- Table ID
  Required
- Record ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Action
Write
- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Action
Write
- Table ID
  Required
- Record ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Action
Write
- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
Action
Write
- Table Name
  Required
Action
Search
- Table ID
  Required
- Zap_id
- Zap_step_id
- Zap_path_run_id
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 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 Zapier Tables

Zapier Tables is a no-code database built for automation.

Learn moreLearn moreHelpHelp

Related categories

Zapier products

Related Zap Templates

Related Zap Templates

Create records in Zapier Tables from new rows in Google BigQuery

Create new rows in Google BigQuery from new records in Zapier Tables