Skip to content
Google BigQuery logo

Google BigQuery integration

Query, analyze, and stream data into Google BigQuery — the fully managed, serverless data warehouse. Use Google BigQuery from Zoft voice agents, chat agents, workflows and AI employees.

Get early accessTalk to sales
  1. Starts withNew Row
  2. ZoftAgent or workflow decides what happens next
  3. Then in Google BigQueryCreate Row
  4. AndCreate Rows
Illustrative flow built from Google BigQuery’s real triggers and actions.

Zoft + Google BigQuery

What Zoft can do with Google BigQuery.

  • 01Voice agentsA phone agent can use Google BigQuery actions such as Create Row and Create Rows during the call, then hand off to a person when it should.
  • 02Chat agentsThe same agent on web chat, WhatsApp or SMS can look up and update Google BigQuery while it talks to the customer.
  • 03WorkflowsStart a workflow when “New Row” happens in Google BigQuery, or use Google BigQuery as any step on the canvas.
  • 04AI employeesAn AI employee can find and use Google BigQuery actions on its own, and ask for your approval before it sends or changes anything important.

Actions 10

Things Zoft can do in Google BigQuery.

  • Run a QueryExecute a SQL query on BigQuery and return the results as flat rows
  • Create RowCreates a single new row in a BigQuery table. Column fields are loaded from the table schema.
  • Create RowsCreates new rows of data in a BigQuery table (accepts an array of row objects). Rows are available to query within seconds.
  • Delete RowsDeletes one or more rows from a BigQuery table using a SQL WHERE condition.
  • Import DataImports a batch of rows into a BigQuery table. Accepts a JSON array or newline-delimited JSON (NDJSON). Large datasets are automatically split into chunks.
  • Update Row(s)Updates one or more existing rows in a BigQuery table using SQL SET and WHERE expressions.
  • Find One RowFind a single row by specifying a WHERE clause and an optional ORDER BY. Returns the first matching row, or empty if none found.
  • Custom API CallMake a custom API call to a specific endpoint
  • Get Rows for Job CompletedRetrieves 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.
  • Find or Create RecordSearches for a row matching a WHERE clause. If found, returns it. If not found, inserts the provided row data and returns that.

Triggers 4

Events in Google BigQuery that can start a workflow.

  • New RowTriggers 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 RowTriggers when an existing row is updated in a BigQuery table. Requires an `updated_at` TIMESTAMP column that is set whenever a row changes.
  • New Job CompletedTriggers when any BigQuery job (query, load, copy, or extract) finishes. Returns the job metadata including status, type, and timing.
  • 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.

Setup

Connect Google BigQuery in three steps.

  1. 01ConnectChoose Google BigQuery in Connections and approve access in the Google BigQuery sign-in window. Zoft never sees your password.
  2. 02Put it to workAdd Google BigQuery as a workflow step, or let a voice agent, chat agent or AI employee use it as a tool.
  3. 03Review every runAdd approvals where you want a person in the loop. Every run leaves a record you can check.

More analytics and bi integrations.

See all in Analytics and BI

FAQ

Google BigQuery on Zoft, answered.

What can Zoft do with Google BigQuery?

Zoft supports 10 actions and 4 triggers for Google BigQuery. You can use them as workflow steps, and voice agents, chat agents and AI employees can call them as tools.

How do I connect Google BigQuery to Zoft?

Choose Google BigQuery in Connections and approve access in the Google BigQuery sign-in window. Zoft never sees your password.

Can a voice agent or chat agent use Google BigQuery?

Yes. Once Google BigQuery is connected, a voice agent or chat agent can use its actions during a conversation. Permissions control which actions each agent can use.

Can an AI employee work in Google BigQuery without supervision?

Only as far as you allow. AI employees ask for approval before sensitive steps, and every run leaves a record you can review.

Put Google BigQuery to work in your operation.

Get early accessTalk to sales