Google BigQuery + Google Sheets

Create Google BigQuery rows from new or updated Google Sheets spreadsheet rows

Need to organize data and analyze it? This integration can help. It generates a row of data in a Google BigQuery table each time a new row gets added to a Google Sheets spreadsheet. Organizing and analyzing is a breeze with this integration.

Need to organize data and analyze it? This integration can help. It generates a row of data in a Google BigQuery table each time a new row gets added to a Google Sheets spreadsheet. Organizing and analyzing is a breeze with this integration.

  1. When this happens...
    Google SheetsGoogle Sheets
    New or Updated Spreadsheet Row

    Triggered when a new row is added or modified in a spreadsheet.

    TriggerInstant
  2. automatically do this!
    Google BigQueryGoogle BigQuery
    Create Row

    Creates a new row of data in a table. Note: Does not create a job.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Scheduled
    Try It
    • Drive

    Trigger
    Scheduled
    Try It
    • No Team Drive

    • SpreadsheetRequired

    • WorksheetRequired

    • Trigger Column

    Trigger
    Instant
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    • Column NameRequired

    • Index

    Action
    Write
    • No Team Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Instant
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    • Trigger Column

    Trigger
    Scheduled
    Try It
    • Drive

    • SpreadsheetRequired

    Trigger
    Scheduled
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    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.
Learn more

Related categories

  • Databases
  • Google
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.
Learn more

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets