Introducing the AI Chat Agent: Just Tell Your Spreadsheet What You Want
SheetMagic v6.0.0 puts a conversational AI agent inside Google Sheets. Describe what you want in plain English — it reads your data, writes formulas and cells, scrapes the web, and builds charts.
We just shipped SheetMagic v6.0.0, and it's the biggest release yet: the AI Chat Agent is now front and center.
You already know the formula game. Write =AITEXT(...), drag it down 1,000 rows, and watch it generate unique content for every one. That's incredible for repeatable, bulk work. But not everything you do in a spreadsheet is repeatable. Sometimes you're exploring a dataset you've never seen before. Sometimes the task is "clean this up, highlight the outliers, and chart it" — three operations, not one formula. Describing that as a formula chain is awkward. Describing it in plain English is natural.
That's what the Chat Agent is for.
Just ask
Open the sidebar, type what you want, and the agent reads your active sheet and acts on it directly. No formulas, no copy-pasting between tabs, no figuring out which function does what.
=AITEXT("Write a product description for: " & A1)This is what a formula asks for: one repeatable operation, dragged down a column.
The Chat Agent works differently. Instead of a formula, you just say what you want:
"Find my top 10 customers by revenue, highlight them in green, and build a bar chart."
That's one sentence. In the old world, that's a sort, a conditional format, and a chart — three separate manual steps, or three formulas stitched together. In the Chat Agent, it's one message, and it's done in your sheet before you finish your coffee.
A few more examples of what "just ask" looks like:
"Scrape the pricing table from these 12 competitor URLs in column B and put the results in new columns."
"Reformat this sheet: sort by close date, freeze the header row, and add a pivot table summarizing revenue by rep."
"Read this data and tell me which rows look like duplicates."
Read operations — like exploring or summarizing your data — happen instantly. Actions that write to your sheet or spend integration credits (like web scraping) ask for a quick confirmation first, so nothing changes or gets spent without your say-so.
Formulas and the Chat Agent, together
These aren't competing tools. Formulas are your assembly line — define the pattern once, scale it across hundreds of rows. The Chat Agent is your analyst on call — describe a one-off or multi-step task, and it handles it. A typical workflow might start in the Chat Agent to explore and clean a new dataset, then switch to formulas for the repeatable processing step.
Want the full walkthrough — every tool the agent can use, from sheet edits to web scraping? Read the complete AI Chat Agent guide.
Getting started
Open any Google Sheet with SheetMagic installed
If you haven't installed SheetMagic yet, grab it from the Google Workspace Marketplace first.
Go to Extensions > SheetMagic > Open AI Chat
The sidebar opens on the right side of your sheet and automatically reads your active data — headers, types, and contents — so you don't have to explain your sheet before asking for something.
Type what you want, in plain English
Ask it to analyze, write, format, chart, or scrape. Confirm any action that writes to your sheet or spends integration credits, and you're done.
The AI Chat Agent is available on Solo, Team, and Business plans. It's not available on the Free tier or for Lifetime Deal users without BYOK (Bring Your Own Key) enabled.
Try it today
The Chat Agent is live right now for every Solo, Team, and Business plan. Open your sidebar, ask it something you'd normally do by hand, and see what happens. If you're not on a paid plan yet, visit pricing — plans start at $19/month and include the Chat Agent from day one.
Wrap-up
Spreadsheets shouldn't limit what you can do. SheetMagic brings AI and web scraping to your workflow — whether you're generating content, scraping data, or automating repetitive tasks.
If that sounds like the kind of tooling you want to use — try SheetMagic or watch our tutorials.