Stay In The Spreadsheet

You know the dance.

Copy a chunk of a spreadsheet. Paste it into a chat window. Ask for a formula. Copy the formula back. Paste it into the wrong cell. Fix the cell reference. Realize the model assumed your dates were in column B when they're in column D. Go back to the chat. Repeat until lunch.

It works, technically. It's also a ridiculous way to spend a Tuesday. The AI can't see your sheet, so you spend half your time describing the sheet to it.

That's the problem Anthropic went after with Claude for Google Workspace, which went into public beta on October 6. It's an add on that puts Claude in a sidebar right next to your open Doc, Sheet or Slides deck. It reads the file, sees what you've selected and edits the file directly. You don't have to copy anything or explain your columns.

I've been running it against the kind of spreadsheets I actually see in small businesses. Not tidy demo data. The lead export with three date formats. The budget someone built in 2019 and nobody understands. Here's my take.

The add on is free to install from the Google Workspace Marketplace, and it's included on all paid Claude plans. Once it's in, you open any file and go to Extensions, then Claude, then Open Claude. The sidebar opens on the right.

In Sheets, Claude can write formulas, build pivot tables and native charts, and add tabs. For heavier jobs like joining two tables or cleaning messy data, it can pull a range into Python, do the work there, and write the results back into your sheet.

In Docs, it makes small edits without wrecking the formatting around them, and shows bigger rewrites as suggestion cards you can apply or dismiss.

In Slides, it builds slides from your deck's existing layouts and themes, and it checks its own work for text that overlaps, runs off the slide or is hard to read.

By default it runs in a mode called Ask before edits. Every change shows up as a card with a summary, and nothing happens until you approve it. You can switch to Accept all edits, which lets it finish the whole job without stopping.

When you're signed in with your Claude account, the sidebar has the same models, connectors and skills you use in the regular Claude app. Its access to other Google files matches your existing sharing permissions.

It sees the actual sheet. This sounds minor until you've used it. You select a range, ask a question, and the answer is about your data, with your column names, your formats and your weird blank rows. The single biggest source of errors in the old copy and paste routine, the model guessing at your layout, mostly disappears.

It builds native things. When it makes a pivot table or a chart, it's a real Google Sheets pivot table or chart. Not an image. Not a block of text pretending to be a table. You can click into it, change it and share it like anything else you'd build by hand.

The Python step is the sleeper feature. Cleaning data with formulas gets ugly fast. Nested IFs, REGEXREPLACE, helper columns everywhere. Claude can take the range into Python, standardize phone numbers, split full names, fix three date formats and merge duplicates, then write clean data back. You get the result without a sheet full of fragile formulas you'll never understand later.

The approval cards are actually good. Each proposed change comes with a plain summary. "Add a column D that combines first and last name." "Create a pivot table on a new tab summarizing revenue by month and service." You can see exactly what's about to happen. For any sheet that touches money, that's the right default.

It explains inherited sheets. Point it at a formula you didn't write and ask what it does. You'll get a plain English walkthrough. This alone is worth the install for anyone who's taken over a business, a department or a bookkeeper's old files.

It's a beta, and it acts like one. Anthropic calls it a public beta, and that's honest. The announcement doesn't spell out usage limits, so on a big job you may hit a ceiling without warning. Plan your bigger jobs around that.

Ask before edits gets slow on big jobs. Approving forty cards for a forty step cleanup is tedious. The fix is to work on a copy, switch that copy to Accept all edits, then review the finished result. More on that below.

It has your permissions. Claude's access matches your Google sharing permissions. If you can open the payroll sheet, so can Claude, through the connectors. That's how it should work, but it means the add on is only as tidy as your Drive. If your sharing is a mess, this is a good week to clean it up.

Teams need an owner to flip a switch. On Claude Team and Enterprise plans, an owner or primary owner has to enable the Google connectors before anyone can use them. If it's not working for your staff, that's usually why.

Right formula, wrong meaning. This is the big one. Claude will write a formula that works perfectly and answers a slightly different question than the one you meant. "Revenue by month" might use the invoice date when you wanted the payment date. No tool catches that for you. You have to know your own numbers.

Here's where I'd start, with the exact prompts. Paste them into the sidebar with the right range selected.

If you pull contacts out of Go High Level or any CRM, you know the mess. Duplicate contacts, phone numbers in five formats, names in all caps, sources spelled three ways.

Two things to notice. "Leave the original untouched" means you always have the raw data. And "show me the mapping before applying it" catches the moment it decides "FB" and "Facebook Ads" are the same thing when you track them separately.

That last sentence earns its keep. Categories that don't match between tabs are where these reports quietly lie to you.

Hardcoded numbers buried in formulas are the classic time bomb. Someone typed 0.07 for sales tax five years ago and nobody's looked since. This prompt finds them in about a minute.

Pair it with Make.com to drop fresh lead data into the sheet every week, and the report updates itself. You open it on Monday instead of building it on Monday.

Here's where the cross file connectors come in. From the regular Claude app, paste the link to your report sheet and ask:

You end up with a Doc in your Drive, built from the live numbers.

Always work on a copy for big jobs. File, make a copy, then run Claude on the copy. The tool isn't reckless, but working on a copy means a mistake costs you nothing.

Ask before edits on anything with money in it. Budgets, invoices, payroll, pricing. Approve each card. It's slower and that's the point.

Accept all edits on scratch copies. Data cleaning on a duplicate, building a new report tab, formatting. Let it run, then check the result.

Know where the undo is. Google Sheets keeps version history under File, then Version history. If a big edit goes sideways, you can roll the whole sheet back to before you started. Check it once so you know how before you need it.

Spot check five rows. After any cleanup, pick five random rows and compare them to the original by hand. If all five are right, you can trust the job. If one's wrong, look harder.

Google's own Gemini already sits in a side panel in Sheets for paid Workspace plans, and you can always go back to the copy and paste routine with ChatGPT. I'm not going to hand you a benchmark I can't stand behind. Here's the practical difference I'd weigh.

If your team already lives in Claude, with projects, connectors and skills set up the way you like, the add on carries all of that into the sheet. That's reason enough to install it.

If you've never used Claude and you're happy with Gemini inside Workspace, try both on the same messy file for a week. Pick the one whose mistakes you catch more easily. That's a better test than any feature list.

And if you want to know whether it's actually saving you time, measure it. Rize tracks time by app and project automatically, so you can compare your hours in spreadsheets the month before you installed it with the month after. Then you're working from real hours.

Use it if you spend more than an hour a week fighting spreadsheets. Bookkeeping cleanup, lead lists, reports, inventory. This is the most practical place AI can save you time this month.

Use it if you've inherited sheets you don't fully understand. Start with the audit prompt.

Use it if your team already pays for Claude. It's included, so there's no new bill to justify.

Skip it if your sharing permissions are a disaster and you're not ready to fix them. Clean up access first. The tool will see whatever you can see.

Skip it for now if you need it in a regulated workflow that requires a fully released product. The Enterprise plan carries over audit and compliance controls, but your compliance person should make that call, not me.

Claude for Google Workspace fixes the dumbest part of using AI with spreadsheets: the part where you describe your sheet to something that can't see it. It builds real pivots and charts, cleans data properly without leaving a mess of helper formulas behind, and explains formulas better than most people who wrote them.

It's still a beta. You have to check what the numbers mean, and it sees every file your permissions let it see. But if you've got a handful of spreadsheets everybody's slightly afraid of, this is the AI install I'd tell you to grab this month. It's staying in my stack.

Install the add on from the Google Workspace Marketplace. If you're on a Claude Team plan, have the owner turn on the Google connectors first.

Pick your messiest spreadsheet. Make a copy.

Run the audit prompt on it before you change anything. Read what comes back.

Run the lead cleanup prompt on your latest CRM export, on a new tab, with Ask before edits switched on.

Spot check five rows against the original.

Then build the marketing report and set a reminder to open it Monday morning instead of building it Monday afternoon.

Jordan

The AI Newsroom | Practical AI for people with a business to run.