Can NoClick add rows to an Excel spreadsheet automatically?

Yes. The Excel node supports adding rows to a table, which is the typical way to log incoming data. You can also add table columns, insert blank cell ranges, and update existing ranges, so the node covers both append-style logging and targeted edits.

Does the Excel node support formulas and charts?

It does. You can write formulas into cells with the update range operation, recalculate the whole workbook, and execute any of Excel's 300-plus built-in functions directly. For charts, the node can create a chart from a range, update its title and size, list charts on a worksheet, and export a chart as a PNG image.

How does NoClick connect to Excel?

The Excel node authenticates through Microsoft OAuth using the Microsoft Graph API. You connect your Microsoft account once, and NoClick handles token refresh automatically so workflows keep running without you re-authenticating.

Can I manage worksheets and tables, not just cells?

Yes. The node can add, delete, rename, and reposition worksheets, and it can create tables from a range, list tables and their rows and columns, convert a table back to a plain range, and sort or filter table data.

What is an Excel session and do I need one?

A session lets a series of operations share state and apply changes efficiently against the same workbook. The node can create a persistent or non-persistent session, refresh it to keep it alive, and close it when finished. For simple one-off reads or writes you can skip sessions entirely.

Hermes is an open agent based on Nous Research’s Hermes models. NoClick runs it for you and adds your connected apps as tools.

How do I give Hermes access to an app?

Connect the app's integration node to the agent's tools handle and pick the operations to expose. Each becomes a callable tool.

Do I need my own infrastructure?

No. The harness runs in a hosted sandbox and NoClick handles credentials for the apps you connect.

Can Hermes use multiple apps at once?

Yes. Wire in several integrations and the agent can use them together in a single run.

Connect Hermes to Excel

Connect a coding agent to your Excel workbook and it builds the sheet for you. It can add worksheets, turn a range into a table, add rows and columns, apply and clear column filters, create charts, and recalculate the workbook, calling each operation as a tool as it goes. Inside a hosted agent in NoClick, it can take a raw range and return a structured, charted report on its own.

Loading preview…

Opens a workflow with 43 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 Hermes, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in Excel
A preset of real Excel operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Connect Excel
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 Hermes first calls in. Hermes connects when it next starts a session.
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.

Excel

43 tools

Create Workbook Session

Create a workbook session for persistent or non-persistent changes

Close Workbook Session

Close a workbook session

Refresh Workbook Session

Refresh a workbook session to keep it alive

Recalculate Workbook

Recalculate all formulas in the workbook

Execute Excel Function

Execute built-in Excel function (300+ functions available)

List Workbook Worksheets

List all worksheets in a workbook

Get Worksheet

Get worksheet details by name

Add Worksheet

Add a new worksheet to the workbook

Update Worksheet

Update worksheet properties (name, visibility, position)

Delete Worksheet

Delete a worksheet from the workbook

Get Worksheet Used Range

Get the used range of a worksheet (all cells with data)

Get Range Values

Get data from a specific cell range

Update Range Values

Update cell values, formulas, or formatting in a range

Clear Range Contents

Clear content, format, or both from a range

Insert Blank Cells in Range

Insert blank cells and shift existing cells down or right

Delete Range and Shift Cells

Delete cells and shift remaining cells up or left

Merge Range Cells

Merge cells into a single region

Unmerge Range Cells

Unmerge merged cells

Sort Range by Column

Sort a range by column

Format Range

Apply formatting to a range (font, fill, borders, alignment)

List Workbook Tables

List all tables in the workbook

Get Table

Get table details by name

Create Table from Range

Create a new table from a range

Delete Table

Delete a table (converts back to range)

Convert Table to Range

Convert table to normal range (keeps data, removes table structure)

List Table Rows

List all rows in a table

Add Table Row

Add a row to a table

Delete Table Row

Delete a row from a table by index

List Table Columns

List all columns in a table

Add Table Column

Add a column to a table

Delete Table Column

Delete a column from a table

Sort Table by Column

Sort a table by column

Apply Table Column Filter

Apply auto-filter to a table column

Clear Table Column Filter

Clear filter from a table column

List Worksheet Charts

List all charts in a worksheet

Get Chart

Get chart details by name

Create Chart

Create a new chart from data range

Update Chart

Update chart properties (title, size, position)

Delete Chart

Delete a chart from worksheet

Get Chart Image

Get chart as base64-encoded PNG image

List Named Items

List all named ranges and items in the workbook

Get Named Item

Get value of a named range or item

Create Named Item

Create a named range or constant

Starting points

What you can build

Pull values from a specific cell range and feed them into a downstream node for reporting or notifications.

Append a new row to an Excel table every time an upstream trigger fires, keeping a running log without manual entry.

Create a fresh worksheet, write a block of values into it, and apply font and fill formatting in a single workflow run.

Sort a table by a chosen column and apply an auto-filter so the spreadsheet always presents the most relevant records first.

Generate a chart from a data range and export it as a base64 PNG image to embed in an email or dashboard.

Run a built-in Excel function against your data and use the calculated result to drive a branch in the workflow.

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