Loading

Airtable + Google BigQuery

Run a query in Google BigQuery for every new record in Airtable

This workflow kicks into action the moment a new record appears in Airtable, leading to a direct query run in Google BigQuery. By seamlessly connecting your record-keeping and data analysis, this convenient automation saves you time and ensures any new data is promptly analyzed in BigQuery. Streamline your data management process and instantly glean insights from fresh Airtable entries.

This workflow kicks into action the moment a new record appears in Airtable, leading to a direct query run in Google BigQuery. By seamlessly connecting your record-keeping and data analysis, this convenient automation saves you time and ensures any new data is promptly analyzed in BigQuery. Streamline your data management process and instantly glean insights from fresh Airtable entries.

  1. When this happens...
    AirtableAirtable
    New Record

    Triggers when a new record is created. Optionally: triggers when any record (new or existing) is first added to a selected view.

    TriggerScheduled
  2. automatically do this!
    Google BigQueryGoogle BigQuery
    Run a Query

    Runs a SQL query against a table in BigQuery.

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

Supported triggers and actions

What does this mean?
    • BaseRequired

    • TableRequired

    • Limit to View

    • Include file contents?

    Trigger
    Scheduled
    Try It
    • BaseRequired

    • TableRequired

    Action
    Write
    • BaseRequired

    • TableRequired

    • Lookup FieldRequired

    • Secondary Lookup Field

    Action
    Write
    • Api Docs Info

    • HTTP MethodRequired

    • URLRequired

    • Query String Parameters

    • Headers

    • Additional Request Headers

    • Body

    Action
    Write
    • BaseRequired

    • TableRequired

    • Help Text

    • Which timestamp field should this Zap use to check for updates?Required

    • Limit to View

    • Include file contents?

    Trigger
    Scheduled
    Try It
    • Cache Copy

    • BaseRequired

    • TableRequired

    Action
    Write
    • BaseRequired

    • TableRequired

    • RecordRequired

    Action
    Write
    • BaseRequired

    • TableRequired

    • Search by Field

    • Search Value

    • Search for Exact Match?

    • Search Formula

    • Limit to View

    • Include file contents?

    Action
    Search
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 moreHelp

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.

Related categories