Connect OpenCode to Google AppSheet

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.

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.

Frequently asked questions