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

Google BigQuery + Google Sheets

Update Google Sheets with new rows when Google BigQuery rows are updated

Stay up-to-date with any modifications in your BigQuery data by integrating it with your Google Sheets. This efficient workflow will create a new row in Google Sheets each time your BigQuery data is updated, ensuring that you're always aware of the latest changes. Benefit from real-time updates without the need to check BigQuery repeatedly, bringing your data management to a whole new level.

Stay up-to-date with any modifications in your BigQuery data by integrating it with your Google Sheets. This efficient workflow will create a new row in Google Sheets each time your BigQuery data is updated, ensuring that you're always aware of the latest changes. Benefit from real-time updates without the need to check BigQuery repeatedly, bringing your data management to a whole new level.

  1. When this happens...
    Google BigQueryGoogle BigQuery
    Updated Row

    Triggers when an existing row is updated in a table in BigQuery.

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

    Create a new row in a specific spreadsheet.

    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

Triggers & Actions