STEP 1
Connect Airtable and Google BigQuery
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow [3]. No coding or API skills required.
Airtable and Google BigQuery Integration
Keep Airtable and Google BigQuery in sync by integrating their events and actions. When database events happen in Airtable, update the Google BigQuery automatically - without any line of code in visual workflow builder.
3-day trialCancel anytimeUp to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Airtable and Google BigQuery
Detailed info you need to know about Airtable and Google BigQuery integrations in WEXTL. Explore which modules apps support and how you connect them.
Google BigQuery
Query and manage Google BigQuery datasets, tables, jobs, and routines — run SQL and stream rows. [6]
How to connect Airtable to Google BigQuery
Set up your Airtable and Google BigQuery integration in 3 simple steps [2] — no coding required. Up to 10 minutes setup.
STEP 2
Build a workflow
Paste selected Airtable and Google BigQuery nodes onto the canvas [4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between Airtable and Google BigQuery. Use filters or leverage a JS custom code step in between — everything is on the canvas.
How does the integration between Airtable and Google BigQuery work in WEXTL?
WEXTL exposes actions and triggers for Airtable and Google BigQuery that help you connect apps and automate repetitive tasks [1]. A trigger is an event that happens, an action — a step that performs when the event has occurred.
Airtable triggersGoogle BigQuery actions
Airtable modules
- Add Base CollaboratorAdds base collaborator.
- Add Interface CollaboratorAdds interface collaborator.
- Add Workspace CollaboratorAdds workspace collaborator.
- Audit Log EventsAudits log events.
- Change EventsChanges the events.
- Create BaseCreates a new base.
- Create CommentCreates a new comment.
- Create Descendant EnterpriseCreates descendant enterprise.
- Create Ediscovery ExportCreates EDiscovery Export.
- Create FieldCreates a new field.
- Create Multiple RecordsCreates multiple records.
- Create RecordCreates a new record.
- Create TableCreates a new table.
- Create WorkspaceCreates a new workspace.
- Delete Base InviteDeletes base invite.
- Delete Block InstallationDeletes block installation.
- Delete CommentDeletes an existing comment.
- Delete Enterprise UserDeletes enterprise user.
- Delete Hyperdb RecordsDeletes hyperDB Records.
- Delete Interface CollaboratorDeletes interface collaborator.
- Delete Interface InviteDeletes interface invite.
- Delete Multiple RecordsDeletes multiple records.
- Delete RecordDeletes an existing record.
- Delete ShareDeletes an existing share.
- Delete ViewDeletes an existing view.
- Delete WorkspaceDeletes an existing workspace.
- Delete Workspace CollaboratorDeletes workspace collaborator.
- Delete Workspace InviteDeletes workspace invite.
- Get Base CollaboratorsReturns a single base collaborators.
- Get Base SchemaRetrieves base schema.
- Get Ediscovery ExportRetrieves EDiscovery Export.
- Get EnterpriseReturns a single enterprise.
- Get Enterprise UserRetrieves enterprise user.
- Get Hyperdb RecordsRetrieves hyperDB Records.
- Get InterfaceReturns a single interface.
- Get RecordReturns a single record.
- Get User GroupRetrieves user group.
- Get Workspace CollaboratorsRetrieves workspace collaborators.
- Grant Admin AccessGrants admin access.
- List BasesRetrieves a list of bases.
- List Block InstallationsLists block installations.
- List CommentsRetrieves a list of comments.
- List Ediscovery ExportsLists EDiscovery Exports.
- List Records (POST)Lists records (POST).
- List Records in TableLists records in table.
- List SharesRetrieves a list of shares.
- List ViewsRetrieves a list of views.
- Logout Enterprise UserLogouts enterprise user.
- Make an Api CallMakes API call.
- Manage Block InstallationManages block installation.
Google BigQuery modules
- Cancel JobCancels a running job.
- Create DatasetCreates a new dataset.
- Create JobCreates a query, load, copy, or extract job.
- Create RoutineCreates a new routine.
- Create Row Access PolicyCreates a row access policy.
- Create TableCreates a new table.
- Delete DatasetDeletes a dataset.
- Delete JobDeletes the metadata of a completed job.
- Delete ModelDeletes a model.
- Delete RoutineDeletes a routine.
- Delete Row Access Policies in BatchDeletes several row access policies.
- Delete Row Access PolicyDeletes a row access policy.
- Delete TableDeletes a table.
- Edit DatasetUpdates selected fields on a dataset.
- Edit ModelUpdates selected fields on a model.
- Edit TableUpdates selected fields on a table.
- Execute QueryRuns a SQL query.
- Get DatasetReturns a single dataset.
- Get JobReturns a single job.
- Get ModelReturns a single model.
- Get Query ResultsReturns results for a query job.
- Get RoutineReturns a single routine.
- Get Routine IAM PolicyReturns the IAM policy for a routine.
- Get Row Access PolicyReturns a single row access policy.
- Get Row Access Policy IAM PolicyReturns the IAM policy for a row access policy.
- Get Service AccountReturns the project's BigQuery service account.
- Get TableReturns a single table.
- Get Table IAM PolicyReturns the IAM policy for a table.
- Insert RowsInserts rows into a table.
- List DatasetsRetrieves datasets in a project.
- List JobsRetrieves jobs in a project.
- List ModelsRetrieves models in a dataset.
- List ProjectsRetrieves projects the user can access.
- List RoutinesRetrieves routines in a dataset.
- List Row Access PoliciesRetrieves row access policies on a table.
- List Table DataRetrieves rows from a table.
- List TablesRetrieves tables in a dataset.
- Make an API CallPerforms an arbitrary authorized API call.
- Set Routine IAM PolicySets the IAM policy for a routine.
- Set Table IAM PolicySets the IAM policy for a table.
- Test Routine IAM PermissionsTests IAM permissions on a routine.
- Test Row Access Policy IAM PermissionsTests IAM permissions on a row access policy.
- Test Table IAM PermissionsTests IAM permissions on a table.
- Undelete DatasetRestores a recently deleted dataset.
- Update DatasetReplaces an existing dataset.
- Update RoutineReplaces an existing routine.
- Update Row Access PolicyReplaces a row access policy.
- Update TableReplaces an existing table.
- Watch JobsTriggers when a new BigQuery job is created.
Explore alternative integrations
There are other apps [9] supported by WEXTL that can be paired with Airtable and Google BigQuery integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Airtable and Google BigQuery.
Connect your Airtable and Google BigQuery accounts once, pick a trigger in one app and an action in the other, then map the fields so data flows automatically between them. [3]
Example: when Airtable's "Watch Event" fires, WEXTL can "Cancel Job" in Google BigQuery. Airtable has 2 triggers (including Watch Event and Watch Records); Google BigQuery has 48 actions (including Cancel Job, Create Dataset, and Create Job). Add filters and transforms between steps when you need them. [1]
Yes — the integration works in both directions. Use each app's triggers to start a workflow and the other app's actions to update it. [2]
No. Airtable-to-Google BigQuery automations are built visually on the canvas. You can optionally add custom JavaScript with Functions when you need advanced logic. [4]
Yes. Trigger-based automations start the moment Airtable (or Google BigQuery) fires a new event — webhook-backed apps run within seconds, and polling-only apps re-check on a schedule you control. [7]
A first automation typically takes 5–10 minutes: connect each app's credential once, drop a trigger + action onto the canvas, map the fields, and turn the workflow on.
You can build your Airtable + Google BigQuery automation on a 3-day trial with every feature unlocked. Cancel anytime. For your protection, a small deposit is charged to your card when your trial starts. It counts toward your first payment and is non-refundable. [8]
References
List of sources used to gather information about the Airtable and Google BigQuery integration.
- Airtable and Google BigQuery integration source code, module specs and credentials implementation.
- Our Airtable and Google BigQuery integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Airtable and Google BigQuery — used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- Airtable integration information
- Google BigQuery integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library