Skip to content
  • Google BigQuery logoGoogle BigQuery logo
  • Google Sheets logoGoogle Sheets logo

Google BigQuery + Google Sheets

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.

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.

  1. When this happens...
    Google BigQueryGoogle BigQuery
    Query Job Completed (With Row Data)

    Triggers when a query job has completed processing successfully.

    TriggerPolling
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Multiple Spreadsheet Rows

    Create one or more new rows in a specific spreadsheet (with line item support).

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

Supported triggers and actions

    • ProjectRequired

    • Dataset

    • Table

    Trigger
    Polling
    Try It
    • Project IDRequired

    • Job IDRequired

    • LocationRequired

    Trigger
    Polling
    Try It
    • ProjectRequired

    • DatasetRequired

    • TableRequired

    Action
    Write
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • Where ColumnRequired

    • Where ValueRequired

    Action
    Write
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • Sort By ColumnRequired

    • Unique ColumnRequired

    Trigger
    Polling
    Try It
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • Unique ColumnRequired

    • IS Operator

    Trigger
    Polling
    Try It
    • ProjectRequired

    • DatasetRequired

    • TableRequired

    Action
    Write
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • RowsRequired

    • Skip Invalid Rows

    • Ignore Unknown Values

    Action
    Write
google-bigquery logo
google-bigquery logo

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Related categories

google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Related categories