Google BigQuery + Google Sheets
Update Google Sheets rows when new jobs finish in Google BigQuery
Data management means staying on top of your metrics, but that also takes extra time and attention. Save both with this integration, which automatically updates a row in a specified Google Sheets spreadsheet when a query job completes in Google BigQuery. Stay responsive without needing to micromanage your data.
Data management means staying on top of your metrics, but that also takes extra time and attention. Save both with this integration, which automatically updates a row in a specified Google Sheets spreadsheet when a query job completes in Google BigQuery. Stay responsive without needing to micromanage your data.
- When this happens...Query Job Completed (With Row Data)
Triggers when a query job has completed processing successfully.
- automatically do this!Update Spreadsheet Row
Update a row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
ProjectRequired
Dataset
Table
Try ItProject IDRequired
Job IDRequired
LocationRequired
Try ItProjectRequired
DatasetRequired
TableRequired
Project IDRequired
DatasetRequired
TableRequired
Where ColumnRequired
Where ValueRequired
Project IDRequired
DatasetRequired
TableRequired
Sort By ColumnRequired
Unique ColumnRequired
Try ItProject IDRequired
DatasetRequired
TableRequired
Unique ColumnRequired
IS Operator
Try ItProjectRequired
DatasetRequired
TableRequired
Project IDRequired
DatasetRequired
TableRequired
RowsRequired
Skip Invalid Rows
Ignore Unknown Values
