Refound your company for the AI era at ZapConnect 2026. Save your spot →
Google BigQuery + Google Sheets integrations
Add new rows to Google Sheets spreadsheets when Google BigQuery jobs complete
Good data analysis requires good organization, but tedious spreadsheet management takes valuable time and energy. Skip a step with this integration, which automatically adds a new row to a Google Sheet spreadsheet whenever a query job has completed processing successfully in Google BigQuery. Automate the row wrangling so that you can stay focused on the numbers.
- When this happens...Query Job Completed (With Row Data)Triggers when a query job has completed processing successfully.
- automatically do this!Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Google BigQuery and Google Sheets
Discover other triggers and actions you can use with Google BigQuery and Google Sheets
- ProjectRequired
- Dataset
- Table
Try ItTriggerPolling- Project IDRequired
- Job IDRequired
- LocationRequired
Try ItTriggerPolling- ProjectRequired
- DatasetRequired
- TableRequired
ActionWrite- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
ActionWrite
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Try ItTriggerPolling- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Try ItTriggerPolling- ProjectRequired
- DatasetRequired
- TableRequired
ActionWrite- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
ActionWrite
BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Create Google BigQuery rows from new or updated Google Sheets spreadsheet rows
- Make new data rows in Google BigQuery from new spreadsheet rows in Google Sheets
- Update Google Sheets rows when new jobs finish in Google BigQuery
- Create multiple spreadsheet rows in Google Sheets for every new row in Google BigQuery
- Update Google Sheets with new rows when Google BigQuery rows are updated






