The AI Chat Agent for Google Sheets
Describe what you want in plain English. The agent reads your data, writes formulas and cells, scrapes the web, and builds charts, right in your sheet. No formulas to write. No tutorials to follow.
An unedited session: one sentence, four eBay sold-listing scrapes, 40 rows written into new tabs.
Ask for data you do not have yet
This is the part that changes how the sheet works. With a formula you have to know that eBay comps live behind =EBAYSOLD and traffic data behind =SIMILARWEB, and get their arguments right. With the agent you describe the data you want; it picks the scraper, runs it, and writes the rows into a new tab. Thirty-five sources, none of which you have to memorise.
“Find every dentist in Austin on Google Maps with their rating, phone number and website.”
You never name a scraper. The agent recognises this as a Maps job and runs it.
| Practice | Rating | Phone | Website |
|---|---|---|---|
| Lamar Family Dental | 4.8 | (512) 555-0142 | lamarfamilydental.com |
| South Congress Smiles | 4.6 | (512) 555-0188 | socosmiles.com |
“What did Charizard ex cards actually sell for on eBay in the last 30 days?”
Sold prices, not asking prices. The gap between the two is the whole point.
| Listing | Sold for | Date | Condition |
|---|---|---|---|
| Charizard ex 223/197 PSA 10 | $284.00 | Jul 29 | Graded |
| Charizard ex 223/197 raw | $96.50 | Jul 27 | Near mint |
“Take the company URLs in column A and pull their traffic, category and employee count.”
It reads column A itself. No range arguments, no dragging a formula down.
| Domain | Monthly visits | Category | Employees |
|---|---|---|---|
| northwind.com | 1.2M | Business software | 210 |
| contoso.io | 486K | E-commerce | 85 |
“Pull the transcripts for these 8 YouTube videos and summarise each in two sentences.”
Scrape and AI in one sentence. The transcript never has to touch your clipboard.
| Video | Length | Summary |
|---|---|---|
| How we hit $1M ARR | 18:42 | Founder walks through pricing changes that doubled... |
| Cold email teardown | 11:05 | Breaks down four sequences and why the third... |
“Scrape the pricing table from the 12 competitor URLs in column B into new columns.”
Arbitrary pages, not just the platforms with a dedicated scraper.
| Competitor | Entry | Mid | Top |
|---|---|---|---|
| Acme Analytics | $29 | $99 | $249 |
| Globex Insights | $25 | $120 | Custom |
Rows above are illustrative; the columns and credit rates are the real ones.
“Find my top 10 customers by revenue, highlight them in green, and build a bar chart.”
A sort, a conditional format, and a chart, three manual steps, one sentence.
“Scrape the pricing table from these 12 competitor URLs in column B and put the results in new columns.”
The agent uses the same scraping engine as the 41 scraper formulas.
“Reformat this sheet: sort by close date, freeze the header row, and add a pivot table summarizing revenue by rep.”
Multi-step cleanup jobs are exactly what plain English is good at.
“Read this data and tell me which rows look like duplicates.”
Read-only questions are answered instantly, without changing your sheet.
It reads your sheet
Open the sidebar and ask. The agent reads your active sheet, headers, data, structure, so you never have to describe what is already there.
It acts directly
Writing cells, formatting, building charts and pivot tables, scraping the web, the agent does the work in your sheet, not in a chat transcript you have to copy from.
You stay in control
Reading and analyzing happen instantly. Anything that writes to your sheet or spends integration credits asks for a quick confirmation first.
Formulas and the agent, together
These are not competing tools. Formulas are your assembly line: define the pattern once with =AITEXT() or =AMAZONSEARCH(), then scale it across a thousand rows. The Chat Agent is your analyst on call: describe a one-off or multi-step task and it handles it. A typical workflow starts in the chat to explore and clean a new dataset, then switches to formulas for the repeatable processing.
Included on Solo, Team & Business plans
The Chat Agent is available on Solo, Team & Business plans. The Free tier includes all AI formulas with a one-time 20,000 AI-token allowance, no credit card required. Join 3,900+ users.