STEP 1
Connect Baserow 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.
Baserow and Google BigQuery Integration
Keep Baserow and Google BigQuery in sync by integrating their events and actions. When database events happen in Baserow, 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 Baserow and Google BigQuery
Detailed info you need to know about Baserow and Google BigQuery integrations in WEXTL. Explore which modules apps support and how you connect them.
Baserow
Open-source database — manage workspaces, tables, fields, rows, and views through the Baserow REST API. [5]
Google BigQuery
Query and manage Google BigQuery datasets, tables, jobs, and routines — run SQL and stream rows. [6]
How to connect Baserow to Google BigQuery
Set up your Baserow and Google BigQuery integration in 3 simple steps [2] — no coding required. Up to 10 minutes setup.
STEP 2
Build a workflow
Paste selected Baserow 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 Baserow and Google BigQuery. Use filters or leverage a JS custom code step in between — everything is on the canvas.
How does the integration between Baserow and Google BigQuery work in WEXTL?
WEXTL exposes actions and triggers for Baserow 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.
Google BigQuery triggersBaserow actions
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.
Baserow modules
- Batch Create Database Table RowsCreates new rows in the table if the user has access to the related table's workspace.
- Batch Delete Database Table RowsDeletes existing rows in the table if the user has access to the table's workspace.
- Batch Update Database Table RowsUpdates existing rows in the table if the user has access to the related table's workspace.
- Calendar Ical FeedReturns ICal feed for a specific Calendar view identified by ical_slug value.
- Change Primary FieldChanges the primary field of a table to the one provided in the body payload.
- Check Database TokenThis endpoint check be used to check if the provided personal API token is valid.
- Create Database Data Sync TableCreates a new data sync table with the given data sync type.
- Create Database Field Workflow ActionCreates a new database workflow action.
- Create Database TableCreates synchronously a new table for the database related to the provided database_id parameter.
- Create Database Table AsyncCreates a job that creates a new table for the database related to the provided database_id parameter.
- Create Database Table FieldCreates a new field for the table related to the provided table_id parameter.
- Create Database Table RowCreates a new row in the table if the user has access to the related table's workspace.
- Create Database Table ViewCreates a new view for the table related to the provided table_id parameter.
- Create Database Table View DecorationCreates a new decoration for the view related to the provided view_id parameter.
- Create Database Table View FilterCreates a new filter for the view related to the provided view_id parameter.
- Create Database Table View Filter GroupCreates a new filter group for the view related to the provided view_id parameter.
- Create Database TokenCreates a new database token for a given workspace and for the authorized user.
- Create Initial WorkspaceCreates an initial workspace.
- Create Row CommentCreates a comment on the specified row.
- Create SubjectCreates a new team subject.
- Create WorkspaceCreates a new workspace where only the authorized user has access to.
- Database Table Public View Link Row Field LookupIf the view is publicly shared or if an authenticated user has access to the related workspace, then this endpoint can be used to fetch the data of a specific link row field.
- Delete Database Field Workflow ActionDeletes the workflow action related by the given id.
- Delete Database TableDeletes the existing table if the authorized user has access to the related database's workspace.
- Delete Database Table FieldDeletes the existing field if the authorized user has access to the related database's workspace.
- Delete Database Table RowDeletes an existing row in the table if the user has access to the table's workspace.
- Delete Database Table ViewDeletes the existing view.
- Delete Database Table View DecorationDeletes the existing decoration if the authorized user has access to the related database's workspace.
- Delete Database Table View FilterDeletes the existing filter if the authorized user has access to the related database's workspace.
- Delete Database Table View Filter GroupDeletes the existing filter group with the given view_filter_group_id.
- Delete Database TokenDeletes the existing database token if it is owned by the authorized user.
- Delete Row CommentDelete a row comment.
- Delete SubjectDeletes a subject if the authorized user is in the team's workspace.
- Delete TeamDeletes a team if the authorized user is in the team's workspace.
- Delete WorkspaceDeletes an existing workspace if the authorized user belongs to the workspace.
- Delete Workspace UserDeletes a workspace user if the authorized user has admin rights to the related workspace.
- Dispatch Database Field Workflow ActionsRuns every workflow action of a button field, in order, for the given row, and returns one result per action.
- Duplicate Application AsyncDuplicate an application if the authorized user is in the application's workspace.
- Duplicate Database Table AsyncStart a job to duplicate the table with the provided table_id parameter.
- Duplicate Database Table ViewDuplicates an existing view if the user has access to it.
- Duplicate Table FieldDuplicates the table with the provided table_id parameter.
- Export TableCreates and starts a new export job for a table given some exporter options.
- Export Workspace Applications AsyncExport workspace or set of applications application if the authorized user is in the application's workspace.
- Filter Database Table Grid View RowsLists only the rows and fields that match the request.
- Generate Formula With AiThis endpoint generates a Baserow formula for the table based on the human readable input.
- Generate Table Ai Field ValueEndpoint that's used by the AI field to start an sync task that will update the cell value.
- Get Adjacent Database Table RowFetches the adjacent row to a given row_id in the table with the given table_id.
- Get Database Field Unique Row ValuesReturns a list of all the unique row values for an existing field, sorted in order of frequency.
- Get Database TableReturns the requested table if the authorized user has access to the related database's workspace.
- Get Database Table FieldReturns the existing field if the authorized user has access to the related database's workspace.
Explore alternative integrations
There are other apps [9] supported by WEXTL that can be paired with Baserow 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 Baserow and Google BigQuery.
Connect your Baserow 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 Google BigQuery's "Watch Jobs" fires, WEXTL can "Batch Create Database Table Rows" in Baserow. Baserow has 150 actions (including Batch Create Database Table Rows, Batch Delete Database Table Rows, and Batch Update Database Table Rows); 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. Baserow-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 Baserow (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 Baserow + 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 Baserow and Google BigQuery integration.
- Baserow and Google BigQuery integration source code, module specs and credentials implementation.
- Our Baserow and Google BigQuery integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Baserow 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.
- Baserow integration information
- Google BigQuery integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library