Google Sheets and AI agents
In a small business the spreadsheet is the system of record nobody admits to: the client list, the price list, the shift rota, the numbers a report gets built from. An agent reads it as data rather than as a grid — pulling what the weekly report needs, keeping the register current, and showing you the rows that don't agree with each other.
What an agent does in Google Sheets
- Reads only the sheets and ranges you opened, and nothing else on the drive.
- Pulls the figures a report is built from, and shows which row each one came from.
- Adds rows to a register when something happens elsewhere: a payment, an enquiry, a new client.
- Checks the sheet against the system the data came from and lists what disagrees.
- Flags rows that contradict each other instead of quietly correcting them.
Processes that run themselves
A playbook isn't a button — it's a process with a condition that starts it. These three are the ones people set up on a spreadsheet.
A new row goes into the process
A row is added to the sheet — an order, a payment, a new client
- Check that the fields without which the row is useless are filled in
- Fill in what comes from another system: status, date, amount
- Ask whoever added the row for what's missing
- Mark the row as picked up
The weekly report, straight out of the sheet
The reporting week ends
- Collect the period's figures from the sheets that matter
- Reconcile the totals against the system the data came from
- Note what moved since last week
- Hand over the summary with the source row behind every number
A value outside the range
A value in a column falls outside the range you set
- Record the row, the column and how far out it is
- Check whether it's a typo by comparing with neighbouring periods
- Tell you, rather than nudge the value back into range
Where the agent stops
- It writes only to the sheets and ranges you opened; everything else is read-only or out of reach.
- It doesn't rewrite formulas and doesn't restructure columns — the sheet stays yours, only the data in it moves.
- A value it can't reconcile is flagged, not corrected: a silent edit is the worst thing you can do to a book of record.
- Where the spreadsheet contradicts the source system, the source wins and you are told — the row isn't rewritten behind your back.
FAQ
Will the agent get access to my whole Google Drive?
No. Access is granted to named spreadsheets rather than to the drive, and you change that list whenever you like. Anything you haven't opened doesn't exist as far as the agent is concerned.
Can it break my spreadsheet?
It doesn't touch formulas and doesn't move columns — it writes values into the ranges you pointed it at. Google Sheets version history stays exactly where it was, so every change is visible and reversible.
What happens when the sheet disagrees with the CRM or the bank?
The discrepancy goes onto a list instead of being quietly fixed. The rule is simple: the source system outranks the spreadsheet, but the agent won't rewrite the row without you — it shows you both numbers.
Our sheet runs on formulas and pivot tables. Will it survive this?
Yes, because the agent works with values and not with the logic of the sheet. Formulas and pivots recalculate on their own, exactly as they would if a person had typed the row in.
Where this shows up
Walkthroughs where Google Sheets carries part of the record.
How a solo bookkeeper goes from 8 clients to 20 without hiring
The ceiling isn't your expertise — it's the hours that disappear into categorising receipts. Here's what can come off your plate, and what has to stay under your review.
Read the walkthrough →Enterprise & productGetting through quarterly review without the 1 a.m. spreadsheet session
No team under you, no headcount coming, and you're held to a department's output. Here's which parts of that load are mechanical enough to hand off — and which have to stay yours, especially in the room.
Read the walkthrough →Tutoring & educationHow a tutor stops losing enquiries that land mid-lesson
An enquiry arrives while you're teaching. Four days later it belongs to someone else. Here's what comes off your plate, and why response speed is worth more here than any amount of promotion.
Read the walkthrough →Agencies & servicesAn agency run on AI agents: where strategy has to go back to a human
Agents carry production well. The problem is elsewhere: strategy starts looking the same across every client, and clients notice before you do.
Read the walkthrough →