Real AI agent use cases, with sources and setup prompts

How to use AI agents with Excel and Google Sheets

Short answer: There are two ways in. Ask an agent to build a file, for example Claude Code writing a model.xlsx where every number outside the Assumptions tab is a live formula. Or connect the agent to the sheet, using Claude's Google Sheets integration, a Grok Bot with Google Sheets connected, or an n8n or MCP connection. Builders below run 3-year financial models with bear, base and bull scenarios, a bookkeeping sheet that categorizes transactions, an invoice chaser that drafts reminders from a sheet and a Monday competitor price log. Keep inputs on one tab and outputs as formulas, and have the agent check that every formula calculates. Let it read and draft freely, but approve any email or payment it triggers.

How people let agents build and update spreadsheets, from a 3-year Excel model with every cell a formula to a Grok Bot that chases unpaid invoices from a sheet. 22 matching use cases below, each with a public source.

Looking for something else? Search all 1448 use cases or .

Get started in 3 steps

  1. Put every assumption on one input tab and ask for formulas, not pasted numbers, so you can change one cell and see it flow through.
  2. Connect the agent with the narrowest access that works (one sheet, read and write) and log each run in a tab it appends to.
  3. Have the agent recalculate and check for errors after every change, and keep approval on any email, invoice or payment it sends from the sheet.

Common questions

How do you use AI agents with Excel and Google Sheets?
There are two ways in. Ask an agent to build a file, for example Claude Code writing a model.xlsx where every number outside the Assumptions tab is a live formula. Or connect the agent to the sheet, using Claude's Google Sheets integration, a Grok Bot with Google Sheets connected, or an n8n or MCP connection. Builders below run 3-year financial models with bear, base and bull scenarios, a bookkeeping sheet that categorizes transactions, an invoice chaser that drafts reminders from a sheet and a Monday competitor price log. Keep inputs on one tab and outputs as formulas, and have the agent check that every formula calculates. Let it read and draft freely, but approve any email or payment it triggers.
Which AI tools do people use to use AI agents with Excel and Google Sheets?
Across the 22 sourced use cases in this guide, the most used tools are Google Sheets, n8n, Gmail, Grok Bot, Claude Code.
How much does it cost to get started?
6 of the 22 use cases can start on a free plan. The most common paid starting price is $30/mo (6 use cases). Prices come from each tool's official pricing page.
How long does setup take?
7 of the 22 use cases list a setup time of an hour or less. Each card shows the setup time the builder reported.
Are these real examples?
Yes. Every use case links to its public source (an X post, a Hacker News thread or a GitHub repo) with the author and date, so you can check it yourself.

More how-to guides

How to make faceless YouTube videos with AI · How to automate work with n8n and AI · How to vibe code an app with Claude Code · How to build AI agents for SEO and ads · How to run multiple coding agents together · How to build an MCP server for AI agents · How to add memory to coding agents · How to secure vibe-coded apps and agents · How to observe and debug AI agents · How to build agent memory and context layers · How to control coding agents from your phone · How to add payments to vibe-coded apps · How to run local LLMs with AI agents · How to set up Grok Bot agents for real work · How to build with Gemini 4 Argon and Gemini agents · How to use AI agents for taxes, bills and budgets · How to make AI video ads and Reels with agents · How to set up Hermes Agent workflows · How to vibe code a game with AI · How to replace SaaS subscriptions with vibe-coded tools · How to use AI agents for errands, calls and shopping · How to use Cursor agents and automations · How to make 3D scenes and models with AI and Blender · How to use Claude Code skills and plugins · How to cut AI coding agent costs and token use · How to automate a small business with AI agents · How to compare AI models on the same prompt · How to build hardware projects with AI agents · How to make AI music videos and songs · How to use AI agents with Obsidian and your notes · How to build apps and games for your kids with AI · How to use ChatGPT for real projects and everyday tasks · How to make AI agents ask for approval before they act · How to build AI trading and investing agents · How to build AI agents that make and answer phone calls · How to plan meals and groceries with AI agents · How to use AI agents for fitness and health · How to undo, checkpoint and stop runaway coding agents · How to use AI agents for job hunting · How to automate social media posts with AI agents · How to build a smart home and voice assistant with AI agents · How to make money with AI agents · How to build a website with AI agents · How to use AI agents for research and science · How to build an iPhone or Android app with AI · How to automate email and your inbox with AI agents · How to use AI agents for Linux, servers and homelabs · How to build Telegram, Discord and WhatsApp bots with AI · How to research memecoins and crypto with AI agents · How to remove ads and bloatware from your smart TV with AI · How to self-host AI agents on a Raspberry Pi, Mac mini or homelab · How to learn anything with an AI tutor · How to build an AI second brain and personal wiki · How to reverse-engineer and revive old devices with AI · How to edit videos with Claude Code and Codex · How to set up an AI family assistant · How to make a Godot, Unity or 3D game with AI agents · How to build a custom Android TV or Google TV launcher with AI · How to use Claude Code and Codex together · How to build your own invoicing and bookkeeping app with AI · How to make a browser arcade game with AI · How to make a product demo or launch video with AI · How to fix Wi-Fi and secure your home network with AI · How to control Claude Code and Codex by voice · How to design a PCB and electronics with AI · How to save, share and resume coding agent sessions · How to run AI coding agents in a sandbox · How to make a multiplayer game with AI · How to let AI control your computer (computer use) · How to build a Mac menu bar app with AI · How to port code to another language with AI · How to make an AI animated short film or anime · How to build your own coding agent or harness · How to get notified when Claude Code or Codex needs you · How to build a Chrome extension with AI · How to run Claude Code and Codex in a desktop app (T3 Code, Codex app, Claude Desktop) · How to make a song or album with AI · How to vibe code classroom apps and quizzes as a teacher · How to plan and book a trip with an AI agent · How to make motion graphics and animated videos with Claude Code · How to mod and reverse engineer games with AI · How to run AI agents overnight while you sleep · How to negotiate bills and get refunds with an AI agent