Skip to main content

Make Waves ’26 Step into AI’s glass box. Prague, 19–20 Oct.

Register now (opens in a new tab)
BigQuery
Airtable

Connect BigQuery and Airtable

Explore ready-made BigQuery and Airtable templates and start automating in minutes.

Get started free

Create a custom workflow

Integrate BigQuery with Airtable and automate the work that moves between them — no code required.

Create a custom workflow

Every automation starts with a trigger and an action. Select one from each app to generate a workflow tailored to your needs.

BigQuery
Trigger: Watch Query Jobs Completed
Airtable
Action: Select an action
1. Select a trigger

  • Triggers when a query job has completed processing successfully or unsuccessfully.

  • Triggers when a new row is inserted in a table.

  • Triggers when a new table is created in a dataset.

2. Select an action

  • Deletes multiple records.

  • Creates a new base.

  • Creates a new comment.

  • Creates a new field in an existing table.

  • Creates a new record in Airtable.

  • Creates a record with mapped fields.

  • Creates a new table.

  • Deletes an existing comment. This action cannot be undone.

  • Deletes a record by its ID.

  • Retrieves a single record by its ID.

  • Returns the base schema.

  • Performs an arbitrary authorized API call.

  • Updates an existing comment.

  • Updates the name and/or description of a field.

  • Updates a record by its ID.

  • Updates a record with mapped fields.

  • Updates the name, description, and/or date dependency settings of a table.

  • Uploads an attachment into an attachment field. Only allows files up to 5 MB.

  • Creates new or updates an existing record.

Select a trigger and an action

Create workflow (opens in a new tab)

Triggers and actions

Explore what you can automate between BigQuery and Airtable.

Bulk create records (advanced)
Сreates multiple records.
Search
Bulk delete records (advanced)
Deletes multiple records.
Action
Bulk update records (advanced)
Updates multiple existing records.
Search
Bulk upsert records (advanced)
Upserts multiple records.
Search
Create a base
Creates a new base.
Action
Create a comment
Creates a new comment.
Action
Create a Dataset
Creates a new dataset.
Action
Create a field
Creates a new field in an existing table.
Action
Create a record
Creates a new record in Airtable.
Action
Load more

Popular BigQuery and Airtable workflows

Connect BigQuery and Airtable with Make. Automate manual tasks, sync real-time data, and build more efficient workflows.

App Families

Export BigQuery Tables to Airtable

This template helps you export a BigQuery table to Airtable. The scenario can be set up to run at regular intervals (every hour, day, week or a specific date). For the proper work of this scenario you can use our example table.

Export BigQuery Tables to Airtable
Use template
App Families

Add new Airtable records to Google BigQuery

Streamline your data management process by automatically transferring records from Airtable to Google BigQuery. With this template, every time a new record is added in Airtable, Make will create a corresponding row in Google BigQuery, ensuring your data is always up-to-date and easily accessible for analysis. This integration helps you maintain a seamless workflow between your project management and data analytics tools, enhancing your team's productivity and decision-making capabilities.

Add new Airtable records to Google BigQuery
Use template

Support

FAQs

Everything you need to know about Make. Can't find the answer you're looking for? Please chat to our team.

Start by registering for Make. As a new Make user, you’ll automatically be assigned a free account. Once your account is set up, you can start creating your first scenarios. We recommend starting with our step-by-step video tutorial.

A scenario represents a workflow or a project of your own creation, and it is made up of a series of modules that automate apps and services. Creating a scenario allows you to transfer and transform data between apps and services via these modules to automate anything and improve the way you work.

Modules are the main building blocks of automation in Make. Modules represent actions that Make performs with an app, like creating, updating, or deleting data.

Mapping links the modules in your scenario. When you map an item, you connect the data retrieved by one module to another module to perform the desired action. For example, you can map email addresses and subject lines to create a spreadsheet using this data.