hermes

Connect Hermes 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:
  1. Choose where it runs

    On your computer through your own Hermes, or hosted in the cloud. The rest of setup adapts to your choice:

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

  3. Connect Google AppSheet

    One sign-in. The agent acts through your account, scoped to the operations you picked.

  4. 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 Hermes first calls in.

    1. Run this in your terminal

    $hermes mcp add noclick --url https://mcp.noclick.app/s/<your-link>

    2. Answer no when asked if the server requires authentication — the link itself is the key

    <your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools Hermes 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 Hermes

Hermes is an open agent built on Nous Research’s Hermes models. NoClick runs it hosted and connects your apps to it as tools, so it can do real work across your systems. Wire an integration into the agent and Hermes can use that app’s operations directly while it reasons through a task. It is a strong pick when you want an open-model agent with genuine tool access.
Built on open Hermes models
Capable general reasoning
Flexible, open-model foundation
Hosted with apps wired in as tools

Good to know

Frequently asked questions

Keep exploring

More ways to connect

Make it yours

Open your Hermes agent in one click.

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