opencode

Connect OpenCode to Google AppSheet

Give an AI agent your Appsheet app as a tool and it can read and change the data behind that app on its own. It looks up rows by key or with a selector, adds and edits records, deletes stale ones, and fires off your custom actions, calling each as a tool while it works through a task. Wire it into a hosted coding agent in NoClick and it handles the data side of the job instead of only telling you what to change.

Loading preview…
Opens a workflow with 7 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 AppSheet

7 tools
Add Rows

Insert one or more new rows into a table.

Edit Rows

Update existing rows; each row must include the key column(s) plus changed columns.

Delete Rows

Delete existing rows; each row must include the key column value(s).

Find Rows by Key

Read specific rows by key; provide key values in Rows.

Find All Rows

Return every row in the table (empty Rows, no Selector).

Find with Selector

Read rows matching an AppSheet Selector expression (FILTER/SELECT/ORDERBY/TOP).

Invoke Custom Action

Run a data-change action predefined in the app against the supplied rows.

What you can build

When new rows are added to a table, enrich each one with an AI step and edit the row back with the result.
On any data change in a tracking table, find the affected record by key and post a summary to your team.
Every morning on a schedule, find all overdue rows with a selector and invoke a custom action to send reminders.
When a form is submitted in another tool, add a row to your Appsheet table so the app stays in sync with the outside world.
When rows are deleted, find the related records and clean them up so your app data stays consistent.
On a schedule, scan a table for records matching a selector and edit their status field in bulk.

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

Frequently asked questions

Build a custom OpenCode agentGoogle AppSheet integration

Open your OpenCode agent in one click

NoClick runs OpenCode for you with Google AppSheet wired in as tools. Connect your account and run.