# How to connect Google Sheets to Hermes Agent

> Set up Google Sheets for Hermes Agent with Agent200, then check which tools are available to your agent.

- Page: https://www.agent200.com/connectors/google-sheets/framework/hermes-agent/
- Connector: [Google Sheets](https://www.agent200.com/connectors/google-sheets.md)
- Framework: Hermes Agent
- Updated: 2026-11-18

## Instructions for AI agents

Goal: connect Google Sheets to Hermes Agent with Agent200, through its MCP server.
Guide: https://www.agent200.com/connectors/google-sheets/framework/hermes-agent/

1. The user needs an Agent200 API key. If they have none, send them to https://agent200.com/platform/apikeys/ to choose "Create an API key". They paste it into Hermes Agent's settings themselves: never ask for it in chat and never write it into files you share.
2. Make sure Google Sheets is enabled for their project in the Agent200 dashboard (Connectors), with the tools the task needs.
3. Add Agent200's MCP server to Hermes Agent: URL https://api.agent200.com/mcp/, transport streamable HTTP, header "Authorization: Bearer <the user's Agent200 API key>". Follow the setup steps on the guide page for Hermes Agent's exact menus or commands.
4. The first Google Sheets request returns an authorization link if the user has not connected Google Sheets yet: show it to them and continue once they have approved access on Google Sheets's own page.
5. Check it works with this request: "Ask Hermes Agent to list the Agent200 tools available for Google Sheets, including which are read-only."
   What should come back:
   - A list of the Google Sheets tools enabled for this Agent200 project, with their names and descriptions. If no tools appear, check that the connector is available to the project and its tools are enabled.
6. If a tool is missing or a call is refused, check the project's Connectors settings in the dashboard and the access the user granted in Google Sheets, then retry.

## Overview

This guide connects Google Sheets to Hermes Agent through Agent200's MCP server. When you finish, Hermes Agent can search, read and act in Google Sheets with the tools Agent200 provides, whenever a request needs them.

You add one MCP server to Hermes Agent with your Agent200 API key. Your Google Sheets account is connected through managed OAuth: you approve access once on Google Sheets's own page, and Agent200 keeps the connection working.

- **Connector:** [Google Sheets](https://www.agent200.com/connectors/google-sheets/)
- **Works with:** Hermes Agent · Agent app, through MCP
- **Authentication:** Managed OAuth, per end user
- **You need:** [An Agent200 API key](https://agent200.com/platform/apikeys/)
- **Tools:** [7 tools](https://www.agent200.com/connectors/google-sheets/framework/hermes-agent/#tools)
- **MCP server:** `https://api.agent200.com/mcp/`

## Before you start

- **An Agent200 API key.** Create one on the [API keys page](https://agent200.com/platform/apikeys/) of the dashboard.
- **Google Sheets enabled for your project.** In the dashboard's Connectors settings, with the endpoints and scopes your agent needs.
- **An end user with a Google Sheets account.** They approve access once, on Google Sheets's own page.
- **Hermes Agent, with custom MCP servers allowed.** Hermes Agent is open source and self-hosted: anyone running it can add MCP servers in its config file.

## Connect Google Sheets to Hermes Agent

### Step 1: Create your Agent200 API key

Open the API keys page in the Agent200 dashboard and choose Create an API key. You add it to Hermes Agent in the next step, as "Authorization: Bearer <your key>". One key covers Google Sheets and every other connector enabled for your project. Keep it out of chats and source control.

Create an API key: https://agent200.com/platform/apikeys/

### Step 2: Store your key in ~/.hermes/.env

Keep the key out of `config.yaml`: Hermes reads it from `~/.hermes/.env`.

File `~/.hermes/.env`:

```bash
AGENT200_API_KEY=your-agent200-api-key
```

### Step 3: Add the server to ~/.hermes/config.yaml

Add an entry under `mcp_servers` with the URL and the Authorization header. Do not set `transport: sse`: Agent200 serves streamable HTTP.

File `~/.hermes/config.yaml`:

```text
mcp_servers:
  agent200:
    url: "https://api.agent200.com/mcp/"
    headers:
      Authorization: "Bearer ${AGENT200_API_KEY}"
```

### Step 4: Reload and test

In a running session, run `/reload-mcp`, or restart Hermes. Then check what the server returned from a terminal.

File `Terminal`:

```bash
# In a running Hermes session: /reload-mcp
hermes mcp test agent200
hermes mcp list
```

### Step 5: Connect your Google Sheets account

The first time you ask Hermes Agent for something in Google Sheets, Agent200 returns an authorization link. Open it and approve access on Google Sheets's own page. Agent200 stores the connection and keeps it working; your password never reaches Hermes Agent or Agent200.

## Test your connection

Ask: "Ask Hermes Agent to list the Agent200 tools available for Google Sheets, including which are read-only."

What should come back:

- A list of the Google Sheets tools enabled for this Agent200 project, with their names and descriptions. If no tools appear, check that the connector is available to the project and its tools are enabled.

If no tools appear, check your Agent200 project access for Google Sheets and make sure its tools are enabled. Tool availability depends on your project setup.

## Google Sheets tools Hermes Agent can call

- **Create a spreadsheet** (`google_sheets_create_spreadsheet`, write): Create a new spreadsheet.
- **Get spreadsheet details** (`google_sheets_get_spreadsheet`, read): Get a spreadsheet's title and its sheets.
- **Read values** (`google_sheets_get_values`, read): Read the values in a range of cells.
- **Update values** (`google_sheets_update_values`, write): Write values into a range of cells.
- **Append rows** (`google_sheets_append_values`, write): Add rows after the last row of a table.
- **Clear values** (`google_sheets_clear_values`, write): Clear the values in a range of cells.
- **Add a sheet** (`google_sheets_add_sheet`, write): Add a new sheet to a spreadsheet.

## How it works

1. **You ask Hermes Agent.** In your own words, for something in Google Sheets.
2. **Hermes Agent picks a tool.** It sees the Google Sheets tools on the Agent200 MCP server and calls the one the request needs.
3. **Agent200 runs the call.** With your own Google Sheets connection, within the tools and scopes your project allows.
4. **Hermes Agent answers.** It gets the result back from the MCP server and uses it in its reply or its next step.

**Each user's own connection.** Connections belong to individual end users. A request for one user never reaches another user's Google Sheets account.

**Permissions at every level.** Your project settings decide what the agent may request, the end user decides what they authorize, and Google Sheets enforces what its API grants.

## Troubleshooting

### The connection fails and names a missing variable

Add `AGENT200_API_KEY` to `~/.hermes/.env` and run `/reload-mcp`.

### The server answers 401 or 403

Check the key in `~/.hermes/.env` and that the header reads exactly `Bearer ${AGENT200_API_KEY}`.

### The initialize request fails with 400 or 405

That points to an SSE setting. Remove any `transport: sse` line from the entry and check the URL is exactly the Agent200 MCP server address.

### The Google Sheets tools do not appear

Run `hermes mcp test agent200`, check the entry is not disabled and no tools filter hides them, then `/reload-mcp`. Hermes names them `mcp_agent200_...`.

### Hermes Agent shows a Google Sheets authorization link

You have not connected Google Sheets yet, or the connection needs to be approved again. Open the link, approve access on Google Sheets's own page, then ask Hermes Agent again.

### A tool call is refused or returns less than expected

Agent200 runs only what your project allows. Check that Google Sheets and the tools you need are enabled in the dashboard's Connectors settings, and that you granted Google Sheets the access the task needs.

### The API key was pasted into a chat or committed

Create a new key on the [API keys page](https://agent200.com/platform/apikeys/), replace it in Hermes Agent's MCP settings, and stop using the old one. Paste the key only into Hermes Agent's settings, never into a chat.

## Use Google Sheets with another framework

- [Google Sheets + Claude](https://www.agent200.com/connectors/google-sheets/framework/claude.md)
- [Google Sheets + ChatGPT](https://www.agent200.com/connectors/google-sheets/framework/chatgpt.md)
- [Google Sheets + Claude Code](https://www.agent200.com/connectors/google-sheets/framework/claude-code.md)
- [Google Sheets + Muse](https://www.agent200.com/connectors/google-sheets/framework/muse.md)
- [Google Sheets + Grok Bot](https://www.agent200.com/connectors/google-sheets/framework/grok-bot.md)
- [Google Sheets + OpenAI Dots](https://www.agent200.com/connectors/google-sheets/framework/openai-dots.md)
- [Google Sheets + Claude Duet](https://www.agent200.com/connectors/google-sheets/framework/claude-duet.md)
- [Google Sheets + OpenClaw](https://www.agent200.com/connectors/google-sheets/framework/openclaw.md)

---

Agent200: https://www.agent200.com/ · API keys: https://agent200.com/platform/apikeys/ · Docs: https://docs.igpt.ai/
