Google BigQuery

Google BigQuery Integrations

Activepieces lets you connect Google BigQuery with the most popular apps, so you can automate your work and have more time for what matters most - no code required.

Start free

Google BigQuery Triggers

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.

Scheduled

Try it

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.

Scheduled

Try it

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.

Scheduled

Try it

New Job Completed

Triggers when any BigQuery job (query, load, copy, or extract) finishes. Returns the job metadata including status, type, and timing.

Scheduled

Try it

Google BigQuery Actions

Run a Query

Execute a SQL query on BigQuery and return the results as flat rows

Try it

Create Rows

Creates new rows of data in a BigQuery table (accepts an array of row objects). Rows are available to query within seconds.

Try it

Update Row(s)

Updates one or more existing rows in a BigQuery table using SQL SET and WHERE expressions.

Try it

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.

Try it

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.