Query, analyze, and stream data into Google BigQuery — the fully managed, serverless data warehouse
Google BigQuery currently provides 4 triggers that can start a workflow and 10 actions a workflow can run. Use those building blocks to turn activity in one tool into an owned next step in the shared workspace.
New Row
Triggers when a new row is added to a BigQuery table. Polls every 5 minutes by comparing the latest value in a sort column against the previous check.
Updated Row
Triggers when an existing row is updated in a BigQuery table. Requires an `updated_at` TIMESTAMP column that is set whenever a row changes.
Query Job Completed (With Row Data)
Triggers when a BigQuery query job finishes successfully. Each flow run receives the job metadata and the result rows from that query.
New Job Completed
Triggers when any BigQuery job (query, load, copy, or extract) finishes. Returns the job metadata including status, type, and timing.
Run a Query
Execute a SQL query on BigQuery and return the results as flat rows
Create Row
Creates a single new row in a BigQuery table. Column fields are loaded from the table schema.
Create Rows
Creates new rows of data in a BigQuery table (accepts an array of row objects). Rows are available to query within seconds.
Delete Rows
Deletes one or more rows from a BigQuery table using a SQL WHERE condition.
Update Row(s)
Updates one or more existing rows in a BigQuery table using SQL SET and WHERE expressions.
Find One Row
Find a single row by specifying a WHERE clause and an optional ORDER BY. Returns the first matching row, or empty if none found.
Find or Create Record
Searches for a row matching a WHERE clause. If found, returns it. If not found, inserts the provided row data and returns that.
Get Rows for Job Completed
Retrieves the result rows from a completed BigQuery query job by Job ID. Use this after a "Query Job Completed" trigger to fetch the full result set.
Import Data
Imports a batch of rows into a BigQuery table. Accepts a JSON array or newline-delimited JSON (NDJSON). Large datasets are automatically split into chunks.
Custom API Call
Make a custom API call to a specific endpoint
These recipes are generated from the triggers, actions, and categories currently available for this piece. Use them as starting points, then choose the exact fields, conditions, and records your workflow should update.
Start from a supported Google BigQuery event, then create or update the appropriate CRM, project, or custom record with the source context preserved.
Starts with
New Row
Finishes with
Create or update a Coherence record
Use a change in Coherence to run a supported Google BigQuery action, so the next step follows the record instead of relying on someone to copy it.
Starts with
A Coherence record or workflow changes
Finishes with
Run a Query
Combine Google BigQuery with another integration and Coherence records to turn activity in one tool into an owned next step in the shared workspace.
Starts with
New Row
Finishes with
Run a Query, then preserve the outcome in Coherence
The exact authentication fields depend on Google BigQuery. The workflow structure stays straightforward:
Authorize the Google BigQuery account and permissions the workflow needs.
Select one of the current triggers or actions listed above and map its fields.
Run a small test, inspect the result in both systems, and only then enable the workflow.
Explore apps that share a category with Google BigQuery or provide a complementary trigger or action.
Google BigQuery currently provides 4 triggers that can start a workflow and 10 actions a workflow can run. Use those building blocks to turn activity in one tool into an owned next step in the shared workspace.
Google BigQuery currently lists 4 triggers and 10 actions in the integration catalog. The supported list is refreshed from the pieces available in Coherence, so review the capability names on this page before building a workflow.
Yes. A workflow can combine supported Google BigQuery triggers or actions with Coherence records and other available integrations. The exact flow depends on the authentication, permissions, triggers, and actions exposed by each connected app.
The listed triggers and actions are designed for visual workflows. If the pre-built integration does not expose a capability you need, HTTP and webhook steps can cover APIs that your team is authorized to use.
Start automating in minutes. No credit card required.
