# How to connect Gigasheet to Hermes Agent (paste one key, 150 tools)

> Connect Gigasheet to Hermes with ClawLink: paste your Gigasheet key once and 150 tools work from chat. No MCP server to run, nothing stored on your machine.

Web version: https://claw-link.dev/hermes/gigasheet

Most guides for giving Hermes Agent Gigasheet access start with registering your own OAuth app or pasting API keys into env files, then leave the token refresh and tool wiring to you. ClawLink gives Hermes a more practical Gigasheet setup: pair once in the browser and your always-on Hermes agent can act on Gigasheet for you, reading and doing real work on your behalf with no auth, token refresh, or tool wiring to build yourself.

**Start here — paste this into Hermes to set up ClawLink:**

> Set up ClawLink for Hermes and tell me when it's ready.
> 1. Install the plugin: `hermes plugins install ClawLink-HQ/hermes-plugin --enable`
> 2. Start pairing with `hermes clawlink begin`. It prints an approval link, so show me the link and stop, don't wait.
> 3. I'll approve it in my browser, then reply "approved".
> 4. When I say approved, finish setup: `hermes clawlink finish`
> 5. Then run `hermes clawlink test` and tell me whether ClawLink is ready.

## Setup

It takes three steps to connect Hermes to Gigasheet.

1. **Install ClawLink** — add the plugin to Hermes Agent once.
2. **Connect Gigasheet** — one-click OAuth in the ClawLink dashboard.
3. **Use it from chat** — ask Hermes Agent in plain English.

**Alternative for any agent (no plugin needed):** if the Hermes Agent plugin route isn't available or doesn't work, any AI agent with shell access can use the ClawLink CLI instead:

```bash
npx -y @useclawlink/cli login          # sign in via browser — no API key to paste
npx -y @useclawlink/cli connect gigasheet  # connect Gigasheet (browser OAuth)
npx -y @useclawlink/cli actions gigasheet  # list available actions
npx -y @useclawlink/cli run gigasheet <action> --input '<json>'  # execute (add --confirm for writes)
```

### Install by command

The prompt above walks Hermes through this. By hand, it is four commands and a browser approval:

```bash
hermes plugins install ClawLink-HQ/hermes-plugin --enable
hermes clawlink begin    # prints an approval link — open it and approve
hermes clawlink finish   # after approving in the browser
hermes clawlink test
```

Then connect Gigasheet in the [ClawLink dashboard](https://claw-link.dev/dashboard) — paste your Gigasheet API key once.

Verify the connection by asking Hermes:

> Use Gigasheet to append dataset and walk me through the result in plain English.

### Using a different agent?

The Hermes plugin is one client of ClawLink's MCP server. Claude Code, Cursor, Codex, or any agent that can run a shell command pairs with the same ClawLink account through the CLI:

```bash
npx -y @useclawlink/cli login
```

`login` opens the same browser approval and stores a credential locally. Once Gigasheet is connected in the dashboard, that agent calls the same 150 Gigasheet tools over MCP. Full setup for MCP clients and shell agents: [connect apps to any AI agent](https://claw-link.dev/learn/connect-apps-to-any-ai-agent).

## Gigasheet MCP for Hermes

Looking for a Gigasheet MCP server for Hermes Agent? ClawLink connects Gigasheet to Hermes Agent and exposes 150 Gigasheet tools your agent can call over [MCP](https://claw-link.dev/learn/what-is-an-mcp-server), with [hosted auth](https://claw-link.dev/learn/oauth-for-ai-agents) and nothing to run or maintain yourself. Using OpenClaw instead? The [OpenClaw Gigasheet integration](https://claw-link.dev/openclaw/gigasheet) works the same way.

## What the Hermes Agent Gigasheet integration can do

150 Gigasheet tools are ready for Hermes Agent once the account is connected. The 30 below are the ones people reach for most; your agent can call all 150.

### 30 of 150 Gigasheet tools for Hermes

| Tool | What it does |
|---|---|
| **Append dataset** `gigasheet_append_dataset` | Appends rows to an existing Gigasheet dataset using column letters as keys |
| **Append dataset from sheet** `gigasheet_append_dataset_from_sheet` | Append data from a source sheet to a target sheet by matching column names |
| **Apply user defined http enrichment** `gigasheet_apply_user_defined_http_enrichment` | Apply generic HTTP enrichment to a Gigasheet dataset |
| **Calculate enrich expected credits** `gigasheet_calculate_enrich_expected_credits` | Calculate expected credits for a user-defined HTTP enrichment operation |
| **Cancel enrich user defined http task** `gigasheet_cancel_enrich_user_defined_http_task` | Cancel a running enrichment task |
| **Count dataset deduplicate rows** `gigasheet_count_dataset_deduplicate_rows` | Count how many duplicates will be removed and how many rows remain when deduplicating |
| **Count dataset groups** `gigasheet_count_dataset_groups` | Count the number of groups matching certain criteria in a Gigasheet dataset |
| **Count dataset rows** `gigasheet_count_dataset_rows` | Counts rows in a Gigasheet dataset matching specified filter criteria |
| **Count datasets activity count** `gigasheet_count_datasets_activity_count` | Get total activity count on a given Gigasheet dataset |
| **Create AI chat** `gigasheet_create_ai_chat` | AI analysis assistant for Gigasheet datasets |
| **Create dataset formula preview** `gigasheet_create_dataset_formula_preview` | Calculate a formula preview on a Gigasheet dataset and return sample results with involved column values |
| **Create file aggregation** `gigasheet_create_file_aggregation` | Retrieve ungrouped aggregated values for a Gigasheet file |
| **Filter file rows** `gigasheet_filter_file_rows` | Retrieve rows from a Gigasheet file matching specified filter criteria |
| **Generate dataset description** `gigasheet_generate_dataset_description` | Generates an AI-powered description for a Gigasheet dataset |
| **Get AI handle logs** `gigasheet_get_ai_handle_logs` | Retrieve AI chat history for a sheet |
| **Get cell comments** `gigasheet_get_cell_comments` | Get comments for a specific cell in a Gigasheet dataset |
| **Get client state current version** `gigasheet_get_client_state_current_version` | Retrieves the current client-state version and timestamp for a specified sheet |
| **Get connector connection params** `gigasheet_get_connector_connection_params` | Get connection parameters for a specific connector |
| **Get connectors connection params connectorname** `gigasheet_get_connectors_connection_params_connectorname` | Retrieve connection parameters for a specific connector type |
| **Get connectors connections** `gigasheet_get_connectors_connections` | List connector connections |
| **Get connectors sources** `gigasheet_get_connectors_sources` | Retrieve information about connected data sources for the user |
| **Get connectors sources params connectorname** `gigasheet_get_connectors_sources_params_connectorname` | Get parameters required for a specific connector source type |
| **Get dataset column comments** `gigasheet_get_dataset_column_comments` | Get comments for a specific column in a dataset sheet |
| **Get dataset handle** `gigasheet_get_dataset_handle` | Retrieves comprehensive metadata for a specific dataset in Gigasheet |
| **Get dataset handle columns** `gigasheet_get_dataset_handle_columns` | List all column metadata (IDs, names, types) for a dataset |
| **Get dataset handle download export** `gigasheet_get_dataset_handle_download_export` | Retrieve the download URL for an exported dataset |
| **Get dataset handle liveshare shareid** `gigasheet_get_dataset_handle_liveshare_shareid` | Retrieve CSV data from a Gigasheet liveshare |
| **Get dataset handle note** `gigasheet_get_dataset_handle_note` | Retrieve a dataset's note by handle |
| **Get dataset handle organization permissions** `gigasheet_get_dataset_handle_organization_permissions` | Retrieve organization file permissions for a dataset |
| **Get dataset handle version** `gigasheet_get_dataset_handle_version` | Retrieves metadata about a dataset at a specific version |

## Example prompts

**Append Dataset**

> Use Gigasheet to append dataset and walk me through the result in plain English.

**Append Dataset From Sheet**

> Use Gigasheet to append dataset from sheet and walk me through the result in plain English.

**Apply User Defined Http Enrichment**

> Use Gigasheet to apply user defined http enrichment and walk me through the result in plain English.

**Calculate Enrich Expected Credits**

> Use Gigasheet to calculate enrich expected credits and walk me through the result in plain English.

## ClawLink vs. building it yourself

The alternative to ClawLink is usually manual API key setup plus your own token handling, permission troubleshooting, and tool plumbing for Hermes Agent. That is fine if you want to build and maintain the integration yourself. Most teams just want Gigasheet working from chat.

| | Manual | ClawLink |
|---|---|---|
| **Credential handling** | Collect, validate, store, and rotate the Gigasheet API key yourself, then make sure every tool call uses the right account. | Users complete the hosted ClawLink setup once and the connected Gigasheet account becomes available to the agent without you building credential management. |
| **Ongoing maintenance** | You own refresh logic, permission debugging, environment config, and every provider-specific edge case for Gigasheet. | ClawLink handles the repetitive integration plumbing so your team can focus on the workflow instead of the infrastructure. |
| **Agent usability** | You still need to expose the right Gigasheet actions to the runtime in a format your agent can reliably use. | 150 tools for Gigasheet are already exposed through ClawLink, so the agent can read and act from chat immediately. |

## ClawLink vs. Composio

Composio also exposes Gigasheet to AI agents. It is developer infrastructure: Python and TypeScript SDKs, an MCP server, and a catalog past 1,000 apps, aimed at teams shipping agent products. ClawLink is built for Hermes Agent users instead. You install the plugin once, connect Gigasheet in the browser, and the 150 tools above work from chat. There is no SDK and no config file, and the Gigasheet key you paste at setup is stored server-side rather than kept in your environment. Choosing between them? Read the full [Composio alternatives](https://claw-link.dev/hub/composio-alternatives) comparison.

### Hermes paired but still can't use Gigasheet
Pairing is a two-step handshake: run `hermes clawlink begin`, approve the link in your browser, then run `hermes clawlink finish`. If you ran finish before approving, or the approval link expired, run `hermes clawlink begin` again to get a fresh link. Confirm the plugin was installed with `--enable`, then verify with `hermes clawlink test`.

### Connection succeeds but no tools appear
Reconnect Gigasheet from the dashboard, then start a fresh chat if the runtime still has the old tool catalog loaded.

### "Tool schema not loaded yet" error when calling Gigasheet tools
Gigasheet tool schemas load on demand the first time a tool runs and are cached after that, so this error usually clears on its own: wait a few seconds and retry the same request. If every Gigasheet call keeps failing with it in a fresh chat, reconnect from the dashboard, and contact support if it still persists — that pattern points to a configuration problem on our side, not something you can fix by reconnecting again.

### Gigasheet returns 403 or "permission denied" on one action while others work
Two usual causes. The connected account may not have access to the specific workspace, inbox, store, or project in the request — check that first. If access looks right, the agent may have sent a placeholder value (like "YOUR_ID" or an example id from documentation) instead of a real one: ask it to run a list or search tool first, then retry the action with a real id from those results. Most failures at this stage are one of these two, not ClawLink bugs.

### API key setup works but results look incomplete
Double-check that the API key for Gigasheet has the right scopes or account access. A valid key can still be too limited for some reads or writes.

### Is there a Hermes Agent Gigasheet integration?
Yes. ClawLink is the fastest way to connect Hermes to Gigasheet: link your Gigasheet account once in the browser and Hermes Agent can call the Gigasheet API through 150 ready-made tools — no custom code or token handling.

### How do I connect Gigasheet to Hermes with ClawLink?
Install the plugin with `hermes plugins install ClawLink-HQ/hermes-plugin --enable`, then pair once: run `hermes clawlink begin`, approve the link in your browser, and run `hermes clawlink finish`. Connect Gigasheet in the dashboard and Hermes can use it from the next message — no config files, and the Gigasheet key you paste is stored server-side instead of in your environment.

### How long does it take to connect Gigasheet to Hermes Agent?
About two minutes. Sign in, click Connect next to Gigasheet in the dashboard, authenticate, and Hermes Agent can use it from the next chat message.

### Why use ClawLink instead of wiring Gigasheet up myself?
The alternative to ClawLink is usually manual API key setup plus your own token handling, permission troubleshooting, and tool plumbing for Hermes Agent. That is fine if you want to build and maintain the integration yourself. Most teams just want Gigasheet working from chat.

### Hermes paired but still can't use Gigasheet
Pairing is a two-step handshake: run `hermes clawlink begin`, approve the link in your browser, then run `hermes clawlink finish`. If you ran finish before approving, or the approval link expired, run `hermes clawlink begin` again to get a fresh link. Confirm the plugin was installed with `--enable`, then verify with `hermes clawlink test`.

## Related

- [GitHub](https://claw-link.dev/hermes/github) — Manage repositories, issues, pull requests, and workflows
- [Connect PagerDuty](https://claw-link.dev/hermes/pagerduty) — Manage incidents, on-call schedules, and services
- [SafetyCulture](https://claw-link.dev/hermes/safetyculture) — SafetyCulture (formerly iAuditor) is a workplace operations platform that enables teams to conduct digital inspections, manage audits, track issues, schedule tasks, and maintain compliance through mobile and web applications.
