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

    Find and update an existing record, or create a new one.

    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

    • 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