How to connect Microsoft Excel to Hermes Agent (no API keys)

Most guides for giving Hermes Agent Microsoft Excel 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 Microsoft Excel setup: pair once in the browser and your always-on Hermes agent can act on Microsoft Excel for you, reading and doing real work on your behalf with no auth, token refresh, or tool wiring to build yourself.

Copy this prompt into Hermes to install the plugin and pair your account.

Prompt for Hermes

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. It prints an approval link, so show me the link and stop, don't wait:
hermes clawlink begin

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

1
Install and pair
Install the ClawLink plugin, then pair Hermes with a one-time browser approval:
hermes plugins install ClawLink-HQ/hermes-plugin --enable
2
Connect Microsoft Excel
One-click OAuth in the dashboard.
3
Use it from chat
Ask Hermes Agent: "What can you do with Microsoft Excel?"

Install by command

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

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 Microsoft Excel in the ClawLink dashboard — a one-click OAuth approval, no API keys.

Verify the connection by asking Hermes:

Use Microsoft Excel to excel add chart 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:

npx -y @useclawlink/cli login

login opens the same browser approval and stores a credential locally. Once Microsoft Excel is connected in the dashboard, that agent calls the same 54 Microsoft Excel tools over MCP. Full setup for MCP clients and shell agents: connect apps to any AI agent.

Microsoft Excel MCP for Hermes

Looking for a Microsoft Excel MCP server for Hermes Agent? ClawLink connects Microsoft Excel to Hermes Agent and exposes 54 Microsoft Excel tools your agent can call over MCP, with hosted auth and nothing to run or maintain yourself. Using OpenClaw instead? The OpenClaw Microsoft Excel integration works the same way.

What the Hermes Agent Microsoft Excel integration can do

54 Microsoft Excel 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 54.

30 of 54 Microsoft Excel tools for Hermes

Tool	What it does
Excel add chart `excel_add_chart`	Add a chart to a worksheet using Microsoft Graph API.
Excel add sharepoint worksheet `excel_add_sharepoint_worksheet`	Add a new worksheet to a SharePoint Excel workbook using Microsoft Graph Sites API.
Excel add table `excel_add_table`	Create a new table in a worksheet using the Microsoft Graph API.
Excel add table column `excel_add_table_column`	Add a column to a table using Microsoft Graph API.
Excel add table row `excel_add_table_row`	Add a row to a table using Microsoft Graph API.
Excel add workbook permission `excel_add_workbook_permission`	Tool to grant access to a workbook via invite. Use when you need to share a specific workbook file with designated recipients and roles.
Excel add worksheet `excel_add_worksheet`	Add a new worksheet to an Excel workbook using Microsoft Graph API.
Excel apply table filter `excel_apply_table_filter`	Apply a filter to a table column using Microsoft Graph API.
Excel apply table sort `excel_apply_table_sort`	Apply a sort to a table using Microsoft Graph API.
Excel clear range `excel_clear_range`	Tool to clear values, formats, or contents in a specified worksheet range. Use when you need to reset cells before adding new data.
Excel clear table filter `excel_clear_table_filter`	Clear a filter from a table column using Microsoft Graph API.
Excel close session `excel_close_session`	Tool to close an existing Excel workbook session. Use when you need to explicitly end a persistent session to release workbook locks.
Excel get chart axis `excel_get_chart_axis`	Retrieve a specific axis from a chart
Excel get chart data labels `excel_get_chart_data_labels`	Retrieve the data labels object of a chart
Excel get chart legend `excel_get_chart_legend`	Retrieve the legend object of a chart
Excel get range `excel_get_range`	Get a range from a worksheet using Microsoft Graph API
Excel get sharepoint range `excel_get_sharepoint_range`	Get a range from a worksheet in SharePoint using Microsoft Graph Sites API
Excel get sharepoint worksheet `excel_get_sharepoint_worksheet`	Get a worksheet by name or ID from a SharePoint Excel workbook using Microsoft Graph Sites API
Excel get table column `excel_get_table_column`	Retrieve a specific column from a workbook table
Excel get workbook `excel_get_workbook`	Retrieve the properties and relationships of a workbook
Excel get worksheet `excel_get_worksheet`	Get a worksheet by name or ID from an Excel workbook using Microsoft Graph API
Excel get worksheet used range `excel_get_worksheet_used_range`	Retrieve a worksheet's used range (active data region) without specifying a fixed range address
Excel list chart series `excel_list_chart_series`	List all data series in a chart
Excel list charts `excel_list_charts`	List charts in a worksheet using Microsoft Graph API
Excel list comments `excel_list_comments`	List comments in an Excel workbook
Excel list drive item children `excel_list_drive_item_children`	List immediate children (files/folders) of a folder DriveItem using driveId and itemId
Excel list files `excel_list_files`	List files and folders in a drive root or specified path
Excel list named items `excel_list_named_items`	List named items in a workbook using Microsoft Graph API
Excel list sharepoint tables `excel_list_sharepoint_tables`	List tables in a SharePoint worksheet using Microsoft Graph Sites API
Excel list sharepoint worksheets `excel_list_sharepoint_worksheets`	List worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API

Try it: find the Microsoft Excel tool you need

Browse the 30 Microsoft Excel tools

Click any tool to see exactly what Hermes can do and copy a ready-to-use prompt.

Example prompts

Use Microsoft Excel to excel add chart and walk me through the result in plain English.

Use Microsoft Excel to excel add sharepoint worksheet and walk me through the result in plain English.

Use Microsoft Excel to excel add table and walk me through the result in plain English.

Use Microsoft Excel to excel add table column and walk me through the result in plain English.

ClawLink vs. building it yourself

The alternative to ClawLink is usually manual OAuth app 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 Microsoft Excel working from chat.

	Manual	ClawLink
Connection flow	Register a Microsoft Excel app, configure redirect URLs, manage consent details, and reconnect users when auth settings drift.	Users connect Microsoft Excel through the hosted browser flow and ClawLink keeps the token lifecycle out of your app code.
Ongoing maintenance	You own refresh logic, permission debugging, environment config, and every provider-specific edge case for Microsoft Excel.	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 Microsoft Excel actions to the runtime in a format your agent can reliably use.	54 tools for Microsoft Excel are already exposed through ClawLink, so the agent can read and act from chat immediately.

ClawLink vs. Composio

Composio also exposes Microsoft Excel 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 Microsoft Excel in the browser, and the 54 tools above work from chat. There is no SDK, no config file, and no API key handling. Choosing between them? Read the full Composio alternatives comparison.

Troubleshooting

Hermes paired but still can't use Microsoft Excel

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 Microsoft Excel 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 Microsoft Excel tools

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

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

OAuth finished in the browser but the account is still missing

Try reconnecting Microsoft Excel and complete the consent flow in the same browser session. Partial OAuth approvals or switching accounts mid-flow can leave the connection incomplete.

FAQ

Is there a Hermes Agent Microsoft Excel integration?

Yes. ClawLink is the fastest way to connect Hermes to Microsoft Excel: link your Microsoft Excel account once in the browser and Hermes Agent can call the Microsoft Excel API through 54 ready-made tools — no custom code or token handling.

How do I connect Microsoft Excel 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 Microsoft Excel in the dashboard and Hermes can use it from the next message — no config files or API keys to manage.

How long does it take to connect Microsoft Excel to Hermes Agent?

About two minutes. Sign in, click Connect next to Microsoft Excel in the dashboard, authenticate, and Hermes Agent can use it from the next chat message.

Why use ClawLink instead of wiring Microsoft Excel up myself?

Hermes paired but still can't use Microsoft Excel

How to connect Microsoft Excel to Hermes Agent

Setup

Install and pair

Connect Microsoft Excel

Use it from chat