Hermes Agent Tutorials & Use Cases

Currently Playing: How I Put Hermes Agent Inside Excel (And Made It a Custom Function)

I put Hermes Agent directly inside Excel — chat with it in a task pane to clean data and build charts, or call it as a cell formula. Full code open-sourced. Sign up for my FREE weekly newsletter, where I spill my unfiltered thoughts on the latest AI news, cool research, and projects I'm building: https://www.onchainaigarage.com/ 🐦 Follow Tonbi on X for real-time AI x blockchain updates! https://x.com/tonbistudio Excel is still everywhere, so this video shows two ways to put a real agent — Hermes Agent, with its tools, memory, and skills — right inside the spreadsheet you're already working in. First, a task pane: a chat panel docked in Excel that can read your selected range, clean messy data, fix broken formulas, and generate charts, only touching the sheet after you approve. Second, custom functions that turn Hermes into a cell formula — HERMES.SUMMARIZE, HERMES.CLASSIFY, HERMES.EXTRACT, and HERMES.FORMULA_HELP — that recompute live as your data changes. I walk through the full setup: enabling the Hermes API server (the full agent as an OpenAI-compatible endpoint, not just the model like Hermes Proxy) in your .env, putting it behind Caddy for the HTTPS that Office add-ins require, and scaffolding the add-in with the office generator. Along the way I clean up a genuinely messy old NFT spreadsheet, pull insights, build charts from a selection, and show that because it's the API server, every session is logged and the agent keeps its memory across projects. I'm honest about the gotchas too — never let a cell formula write to other cells (infinite loops), use the built-in cache, and avoid volatile cells. All the code is open-sourced at the end so you can hand it to your own agent. Resources: 🔗 Hermes Agent: https://github.com/NousResearch/hermes-agent 🔗 Tonbi Studio Hermes Office: https://github.com/tonbistudio/hermes-office Timestamps: 0:00 - The goal: Hermes Agent inside Excel 1:36 - Baseline: the agent working on an Excel file 3:59 - Two methods + API server vs Proxy 4:43 - Setup: .env, the gateway, and Caddy for HTTPS 6:41 - Building the task pane add-in (manifest + yo office) 9:30 - The task pane in action: insights, cleanup, charts 14:00 - Custom functions: Hermes as a cell formula 16:33 - Caveats: loops, caching, volatile cells 17:41 - Shared memory + the open-source repo Would you use an agent inside Excel — and what would you point it at first? Let me know in the comments. I'd like to do more integrations with office software people use every day, so if this was useful please like, subscribe, and hit the bell! 🦐✨ #HermesAgent #Excel #AIAgents #Productivity #AITools #Spreadsheets #OpenSource #LocalLLM #Automation