Do more with Google BigQuery integrations
Zapier lets you connect Google BigQuery with thousands of the most popular apps, so you can automate your work and have more time for what matters most—no code required.
- Free forever for core features
- 14 day trial for premium features & apps


Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
ProjectRequired
Dataset
Table
Only trigger for query jobs that reference the selected table. Leave blank for all query job results.
Try ItProject IDRequired
Job IDRequired
LocationRequired
Try ItProjectRequired
DatasetRequired
TableRequired
Project IDRequired
DatasetRequired
TableRequired
Where ColumnRequired
The column to match against the value in the WHERE clause. The where clause will be
WHERE column = value
Where ValueRequired
The value to match against the column in the WHERE clause. The where clause will be
WHERE column = value
Project IDRequired
DatasetRequired
TableRequired
Sort By ColumnRequired
Only columns that are type
integer
,bytes
,int64
,float
,timestamp
,date
,datetime
,numeric
,bignumeric
are returned. The column will be sorted in descending order. The latest row will be returned.Unique ColumnRequired
The unique column is used to determine if a row is new. For example if the unique column is
id
and the latest row has an id of 1, then the next time the trigger runs, if the latest row has an id of 2, then the trigger will return the row with an id of 2.
Try ItProject IDRequired
DatasetRequired
TableRequired
Unique ColumnRequired
The column to match against the value in the WHERE clause. The where clause will be
WHERE column = value
ValueRequired
The value to match against the column in the WHERE clause. The where clause will be
WHERE column = value
Try ItProjectRequired
DatasetRequired
TableRequired
Project IDRequired
DatasetRequired
TableRequired
RowsRequired
Rows must be an array of objects. Example [{'id': '1', 'name': 'Test'}, {'id': '2', 'name': 'Test2'}]
Skip Invalid Rows
Insert all valid rows of a request, even if invalid rows exist. The default value is false, which causes the entire request to fail if any invalid rows exist.
Ignore Unknown Values
Get started for free
You can't add more hours to the day. Zapier is the next best thing.