Can NoClick add and update rows in an Appsheet app automatically?

Yes. The Appsheet node adds rows, edits existing rows, and deletes rows through the Appsheet API. Connect any trigger, so a schedule, an inbound message, or an event in another tool can write straight into the table behind your app.

How do I connect Appsheet to NoClick?

You authenticate with an Appsheet application access key and your app ID, both found in the app's Integrations settings. Enable the API for the app, paste the key into the node, and it can start reading and writing that app's tables. No OAuth flow is needed.

Can a workflow react when data in my app changes?

Yes. The node has triggers for rows added, rows updated, rows deleted, and any data change, so a workflow can start the moment your app's data moves. There is also an on-schedule trigger for time-based runs that check the table on an interval.

Can it run the custom actions I built in Appsheet?

Yes. The Invoke Custom Action operation calls actions you have defined inside your app, so a workflow can trigger the same behavior a user would by tapping a button. That lets automations reuse logic you already built rather than rebuilding it in the node.

How do I find specific records instead of the whole table?

Use Find Rows by Key to fetch a record by its key value, Find with Selector to pull rows matching an Appsheet expression, or Find All Rows to read the entire table. You can feed the results into later steps to enrich, summarize, or act on exactly the records you want.

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 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.

What happens next

Set up in minutes

The open button drops you into a guided setup. It asks exactly this, nothing else:

Choose where it runs
On your computer through your own OpenCode, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in Google AppSheet
A preset of real Google AppSheet operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Connect Google AppSheet
One sign-in. The agent acts through your account, scoped to the operations you picked.
Add your personal MCP link
The last step mints a private MCP URL for this agent and walks you through exactly this, with your real link filled in. The page flips to Connected the moment your OpenCode first calls in.
1. Run this in your terminal
$opencode mcp add
2. Choose Remote and paste your server URL
https://mcp.noclick.app/s/<your-link>
3. Choose No when asked about OAuth authentication — the link itself is the key
<your-link> is your personal server URL — setup mints it for you.

Exact capabilities

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.

Starting points

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.

Meet the runner

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

Good to know