Airtable + Google BigQuery

Create or update Airtable records every time new rows are added in Google BigQuery

With this workflow, whenever new data is added to a row in your Google BigQuery, it gets instantly reflected in your Airtable as a record update or a newly created record. This easy-to-use automation seamlessly connects Google BigQuery and Airtable, keeping your datasets aligned and up-to-date. The resulting unified and real-time data view can improve your decision-making processes considerably.

With this workflow, whenever new data is added to a row in your Google BigQuery, it gets instantly reflected in your Airtable as a record update or a newly created record. This easy-to-use automation seamlessly connects Google BigQuery and Airtable, keeping your datasets aligned and up-to-date. The resulting unified and real-time data view can improve your decision-making processes considerably.

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

    Triggers when a new row is added to a table. We know when a new row is added whenthe table is sorted by a column and the latest row is different from the previous latest row.

    TriggerScheduled
  2. automatically do this!
    AirtableAirtable
    Create or Update Record

    Updates an existing record if one exists, otherwise creates a new record.

    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?
    • ProjectRequired

    • Dataset

    • Table

    Trigger
    Scheduled
    Try It
    • Project IDRequired

    • Job IDRequired

    • LocationRequired

    Trigger
    Scheduled
    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
    Scheduled
    Try It
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • Unique ColumnRequired

    • IS Operator

    Trigger
    Scheduled
    Try It
    • ProjectRequired

    • DatasetRequired

    • TableRequired

    Action
    Write
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • RowsRequired

    • Skip Invalid Rows

    • Ignore Unknown Values

    Action
    Write
airtable logo
airtable logo

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.
Learn more

Related categories

  • Databases

Similar apps

Quickbase integrationsQuickbase integrations

Quickbase

Databases
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
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