AI Agents for Google Sheets
Google Sheets MCP: ask ChatGPT and Claude about your rows
Connect your Google Sheets to ChatGPT and Claude. The assistant reads every tab and row of the spreadsheets you choose, works out totals and finds what needs attention, and with AI Agent adds rows and changes cells when you ask.
- Open to every account for Google Sheets
- AI Analyst $9.99 or AI Agent $29.99 a month
- 7 day free trial, once per account.
- Every change shown first. Nothing is ever deleted.
Which cases are still in Documents with papers missing, and how much are they worth together?
Three cases are waiting on documents, 465,000 together:
- C-104 Ana Ruiz: 250,000, payslips missing
- C-117 Cris Vega: 90,000, ID missing
- C-121 Dan Mora: 125,000, bank statements missing
Part by part
Everything it reaches in Google Sheets
One card for each part of your system. You choose per record type whether the assistant may read it, or read and write.
Rows
Reads- Every row of every tab you chose
- Rows by words, or by rules on any column
- Amounts and dates compared as numbers and dates
With AI Agent- Add rows, never the same one twice
- Change cells by their column name
- Never writes over a formula
Totals and analysis
Reads- Totals, averages and counts worked out from your rows
- Per status, per person or per month
- What stands still or misses information
Customers, deals and invoices
Reads- Tabs that hold customers, deals, quotes, invoices, jobs or appointments
- Searched and counted as those, by any column
They change through their rows.
Spreadsheets and tabs
Reads- The spreadsheets you chose, with their tabs and columns
With AI Agent- Add a tab with the columns you name
- Make a new spreadsheet in your Google Drive
Ask it, in Google Sheets
Two packages, one question away
AI Analyst answers from your records. AI Agent also does the work, once you say yes.
AI Analyst
Ask anything about your customers, deals and invoices.
- Reads every tab and row of the spreadsheets you choose
- Finds rows by words or by rules on any column
- Works out totals, averages and counts
- Finds what stands still or misses information
Ask it
- Which cases are in Documents and still miss papers?
- What is the total loan amount per stage, and how much capital do the investors have left?
- Which requests marked urgent have been open the longest?
AI Agent
Also gets the work done: changes records once you approve.
- Everything in AI Analyst
- Adds rows and changes cells
- Adds tabs and makes new spreadsheets
- Keeps your formulas as they are
Ask it
- Move case C-104 to Analysis and clear its missing documents.
- Add a row for Dana Price: 180,000, stage Contact, investor to be assigned.
- Add a tab Investors with the columns Name, Email and Available capital.
Automations, with AI Agent
Rules that run in your system by themselves
Describe a rule in the chat and approve it with a yes. It then runs in your system by itself.
- Starts when a record changes, a date comes up, a record stands still or a tag changes
- Sets fields, moves stages, adds notes and tasks, tells your team or emails your customer
- Never deletes; rules that message your customers you approve in CRM Connector
When a deal's stage becomes Won in my sheet, tell the team.
- When
- The stage of a deal in your sheet becomes Won
- Only if
- Its amount is above a value you choose
- Then
- 1Tell your team by email and in CRM Connector
Approval, change log and undo
Nothing changes until you approve it
The assistant proposes, you approve, CRM Connector writes. AI Analyst never writes.
Every change is proposed first
You see a before and after list. Nothing is written until you approve.
Risky changes need your click
Messages to your customers, payments, voids and setup changes need your own click.
Newer work is never overwritten
Each record is read again right before the change. Changed since? Refused.
A change log with undo
Every change is kept, with undo where the system allows it.
You choose what it may do
Per record type: off, read, or read and write. Pause it any time.
- ContactsOffReadRead and write
- DealsOffReadRead and write
- InvoicesOffReadRead and write
Nothing is ever deleted
Never a deleted record. A payment only where your system allows it, after your own click.
What the assistant reaches
- Only the system and record types you switched on
- Never passwords or sign ins
- Answers go to OpenAI or Anthropic under your own agreement
- The change log is kept for 90 days
Good to know
How the Google Sheets agent behaves
You choose the spreadsheets
Google lets CRM Connector open only the spreadsheets you choose, and the ones it made for you. Choose more at any time from the agent's settings.
Your formulas stay yours
A cell that works out its value with a formula is never written over, and nothing is ever deleted.
AI Agents pricing
One monthly package per system
ChatGPT and Claude included, with or without a sync plan.
The monthly fee per connected system
Connect Google Sheets to ChatGPT and Claude, through MCP. A monthly package for Google Sheets. Google Sheets is on our lower price.
- ChatGPT included
- Claude included
- Try it free first
One package covers one Google Sheets Google account.
Google Sheets AI Analyst
Ask anything about your customers, deals and invoices.
$9.99per month
One system at $9.99 each
7 day free trial, once per account.
- Reads and searches one system
- Notes, activities, stages and custom fields
- You choose what it may see
- ChatGPT and Claude included
Google Sheets AI Agent
Also gets the work done: changes records once you approve.
$29.99per month
One system at $29.99 each
7 day free trial, once per account.
- Everything in AI Analyst, for one system
- Changes and creates records
- Every change shown first, risky ones approved by you
- A change log, with undo
Set up your Google Sheets agent yourself
Nothing to request. Connect Google Sheets, try it for free, then switch it on.
- Step 1
Set up your Google Sheets agent
Connect Google Sheets and choose what it may do. Try it free: 100 reads and 25 changes.
- Step 2
Connect ChatGPT or Claude
Add CRM Connector to your assistant. We show when it is connected.
- Step 3
Ask, and automate
Ask a first question. With AI Agent, approve a first automation.
- Step 4
Switch it on
One purchase for all your saved agents, with a 7 day free trial.
FAQ
Questions about the Google Sheets agent?
The answers about Google Sheets. What every AI agent shares is on the AI Agents page.
Yes. CRM Connector is an MCP server with an AI agent for Google Sheets, in both ChatGPT and Claude.
Open the setup in CRM Connector, or plan it in ChatGPT or Claude and follow its link:
- Sign in with Google, pick your spreadsheets, and choose what the assistant may do
- Connect ChatGPT or Claude
- Try it for free, then switch it on
No. It reads only the spreadsheets you choose, every tab and row of them, and the ones CRM Connector made for you. You can add more at any time.
Yes. The assistant reads your rows and works out totals, averages and counts, per status, per person or per month, and CRM Connector filters rows on any column first, so the answer covers the rows that matter.
Rules check your spreadsheets every 15 minutes, on tabs that hold customers, deals, quotes, invoices, jobs or appointments. For example:
- A status column becomes a value you choose: tell your team
- A column changes: change another cell in the same row
A monthly fee for this Google account: AI Analyst $9.99 or AI Agent $29.99 a month. It is on our lower price. Billed yearly you pay ten months.
Saving and trying it is free. 7 day free trial, once per account.