Can the agent read a plan from a sheet and provision BigQuery from it?

Yes. Allowlist Read Multiple Sheet Ranges on Sheets and Create Dataset, Create Table, and Create Routine on BigQuery, and it can turn a spreadsheet plan into real resources in one run. It only ever uses the operations you expose.

Will it overwrite data already in my spreadsheet?

Only if you allow the write operations. Give it Append Rows to Sheet for a log while leaving Write to Multiple Sheet Ranges and Clear Sheet Range off the allowlist, and it can add without overwriting. Nothing outside the allowlist is available to it.

Where do the Sheets and BigQuery credentials live?

Both are credentials you connect in NoClick, and they resolve server-side at call time. The agent runs operations through them, but they never appear in the model's context, so it acts through your accounts without holding their secrets.

What makes OpenCode different here?

OpenCode is open and model-agnostic, so you have flexibility over the underlying model. NoClick handles running it and connecting your apps as tools.

How do I give OpenCode tools?

Connect an integration node to the agent's tools handle and choose the operations to allow. Each becomes a tool the agent can call.

Do I manage any infrastructure?

No. NoClick runs the OpenCode harness in a hosted sandbox and resolves credentials for the apps you connect.

Can it combine several apps?

Yes. Add as many integrations as you need and the agent can use them together in one run.

Connect OpenCode to Google BigQuery and Google Sheets

Hand OpenCode both BigQuery and Google Sheets and a spreadsheet becomes a control panel for your warehouse. It reads a provisioning plan from a sheet, creates the datasets, tables, and routines in BigQuery, then writes the results back so you can see what landed. Sheets is where people plan and track, and BigQuery is where the resources actually live. The agent moves between the two so a row in a sheet turns into a real table, and cleanups get logged as they happen.

Loading preview…

Opens a workflow with 57 tools ready to use.

Tools OpenCode gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

Google BigQuery

38 tools

Run Query

Run a SQL query and return results inline (synchronous, bounded by timeout).

Get Query Results

Page through the results of a (possibly async) query job.

Insert Job

Start a query / load / extract / copy job (async).

Get Job

Fetch a job's status and statistics (poll until DONE).

List Jobs

List jobs in a project (filter by state, time range).

Cancel Job

Request cancellation of a running job.

Delete Job

Delete a job's metadata.

List Datasets

List datasets in the project.

Get Dataset

Fetch dataset metadata.

Create Dataset

Create a new dataset.

Update Dataset

Full replace of dataset metadata (PUT).

Patch Dataset

Partial update of dataset metadata (PATCH).

Delete Dataset

Delete a dataset.

List Tables

List tables/views in a dataset.

Get Table

Fetch table metadata/schema.

Create Table

Create a table or view with a schema.

Patch Table

Partial update of a table (add columns, set expiration, etc.).

Update Table

Full replace of table metadata (PUT).

Delete Table

Delete a table or view.

Stream Insert Rows

Streaming insert of JSON rows into a table (real-time append).

List Table Data

Read rows from a table directly (paginated, no SQL).

List Routines

List stored procedures / UDFs / TVFs in a dataset.

Get Routine

Fetch a routine definition.

Create Routine

Create a stored procedure / UDF / TVF.

List Models

List BigQuery ML models in a dataset.

Get Model

Fetch BQML model metadata.

Delete Model

Delete a BQML model.

Get Service Account

Return the BigQuery service account for the project (KMS/transfer grants).

List Projects

List projects the caller can access (for project picker UIs).

Undelete Dataset

Restore a dataset within its time-travel window (datasets.undelete).

Update Routine

Replace a routine's full definition (routines.update, PUT).

Delete Routine

Delete a routine (routines.delete).

Patch Model

Update mutable BQML model metadata (models.patch).

Get Table IAM Policy

Get the IAM policy for a table (tables.getIamPolicy).

Set Table IAM Policy

Set the IAM policy for a table (tables.setIamPolicy).

Test Table IAM Permissions

Test the caller's permissions on a table (tables.testIamPermissions).

List Row Access Policies

List row access policies on a table (rowAccessPolicies.list).

Get Row Access Policy

Get a single row access policy (rowAccessPolicies.get).

Google Sheets

19 tools

Read Sheet Data

Configuration for reading data from a Google Sheet

Write Sheet Data

Configuration for writing data to a Google Sheet

Append Rows to Sheet

Configuration for appending rows to a Google Sheet

Clear Sheet Range

Configuration for clearing values from a range

Create New Spreadsheet

Configuration for creating a new spreadsheet

Fetch Spreadsheet Metadata

Configuration for getting spreadsheet metadata

Read Multiple Sheet Ranges

Configuration for reading multiple ranges at once

Write to Multiple Sheet Ranges

Configuration for writing to multiple ranges at once

Add Spreadsheet Sheet

Configuration for adding a new sheet/tab

Delete Spreadsheet Sheet

Configuration for deleting a sheet/tab

Copy Sheet to Spreadsheet

Configuration for copying a sheet to another spreadsheet

Rename Spreadsheet Sheet

Configuration for renaming a sheet/tab

Duplicate Sheet in Spreadsheet

Configuration for duplicating a sheet within the same spreadsheet

Find and Replace in Spreadsheet

Configuration for find and replace in a spreadsheet

Insert Sheet Rows

Configuration for inserting rows

Delete Sheet Rows

Configuration for deleting rows

Clear Multiple Sheet Ranges

Configuration for clearing multiple ranges at once

Insert Sheet Columns

Configuration for inserting columns

Delete Sheet Columns

Configuration for deleting columns

What you can build

Read a provisioning plan from a spreadsheet, then create the datasets, tables, and routines it lists in BigQuery.

After clearing out stale BigQuery tables and models, append a row to a cleanup log sheet for each one removed.

Create a new spreadsheet and write a status range into it tracking which BigQuery jobs were cancelled or deleted.

Read a set of table definitions from a sheet range, create each table in BigQuery, then clear the processed rows.

About OpenCode

OpenCode is an open, model-agnostic command-line coding agent. In NoClick it runs hosted and gains your apps as tools, so it can act on real systems rather than just edit files. Wire an integration into the agent and OpenCode can use that app’s operations directly while it works. It is a flexible choice when you want an open agent with broad model support and real tool access.

Open and model-agnostic

Flexible across many underlying models

Good general-purpose tool use

Lightweight to point at a focused task