Latest / Ctrl AI Profit / Ep. 245 | Claude Can Now Edit Your Google Docs and Sheets
Transcript
- 0:20SPEAKER_00: Claude, the AI from Anthropic, can now sit inside Google Docs Sheets and Slides and make changes to the file you have open.
- 0:28SPEAKER_00: Right there in the file.
- 0:30SPEAKER_01: That's the news in one line.
- 0:32SPEAKER_01: Anthropic calls it Claude for Google Workspace.
- 0:35SPEAKER_01: It's in beta and it's for people on a paid Claude plan.
- 0:38SPEAKER_01: Pro, Macs, Team, or Enterprise.
- 0:42SPEAKER_00: Okay.
- 0:43SPEAKER_00: Before we go any further, people hear Claude is in my Google Docs and picture it rummaging through every file they own.
- 0:50SPEAKER_00: Is that what this is?
- 0:52SPEAKER_01: No, and that's the first thing worth knowing.
- 0:54SPEAKER_01: It's an add-on.
- 0:56SPEAKER_01: An add-on is a small app you install into Google's apps, and it shows up under the extensions menu at the top of your document.
- 1:03SPEAKER_01: You open it, a panel slides out on the right, and Claude lives in that panel.
- 1:07SPEAKER_01: So it's a sidebar, not a takeover.
- 1:10SPEAKER_01: Right.
- 1:11SPEAKER_01: And Anthropic's help page is blunt about the reach.
- 1:15SPEAKER_01: Claude reads the file you have open and only that file.
- 1:20SPEAKER_01: It can't open your other drive files, your email or your calendar, unless you separately turn on a connector.
- 1:26SPEAKER_00: Here's what I'd ask though.
- 1:28SPEAKER_00: Google already has its own AI, Gemini, built into a lot of those apps.
- 1:32SPEAKER_00: Why would anybody want a second one in there?
- 1:35SPEAKER_01: Fair question.
- 1:36SPEAKER_01: If Gemini works for you, keep using it.
- 1:39SPEAKER_01: This is for shops that already pay for Claude and like how it writes or how it handles numbers.
- 1:43SPEAKER_01: Now they don't have to copy a spreadsheet out, paste it into a chat, and paste the answer back.
- 1:48SPEAKER_00: The copy-paste shuffle.
- 1:50SPEAKER_00: I've done that dance more times than I'd like to admit.
- 1:53SPEAKER_00: So once it's in there, what can it actually do?
- 1:56SPEAKER_01: In Sheets, it writes and fixes formulas, builds pivot tables and charts, adds new tabs, and cleans up messy data.
- 2:04SPEAKER_01: In docs, it rewrites, shortens, and restructures.
- 2:07SPEAKER_01: In slides, it builds new slides that match the look of your deck.
- 2:12SPEAKER_00: Give me a shop example because the words pivot table make half our listeners reach for the radio dial.
- 2:19SPEAKER_01: Say you run a pest control office, and your job tracker has dates typed three different ways because three different people enter them, you select that column and say, put all of these dates in one format.
- 2:31SPEAKER_01: Claude does it in the sheet.
- 2:34SPEAKER_00: Or the classic.
- 2:35SPEAKER_00: Somebody built the pricing sheet years ago, they moved on, and now nobody knows how the total gets calculated.
- 2:57SPEAKER_00: That alone is worth something.
- 2:59SPEAKER_00: That's the number that bites you when your costs go up and the sheet doesn't notice.
- 3:05SPEAKER_01: And it can answer questions without changing anything.
- 3:07SPEAKER_01: Which slides mention pricing?
- 3:09SPEAKER_01: What changed between the second quarter tab and the third?
- 3:13SPEAKER_01: Questions that only read the file are the safest place to start.
- 3:16SPEAKER_00: Okay, here's my real worry.
- 3:18SPEAKER_00: It's editing my files.
- 3:19SPEAKER_00: What stops it from rewriting my whole proposal while I'm out getting coffee?
- 3:23SPEAKER_01: There's a switch for exactly that, at the bottom of the sidebar, with two settings.
- 3:28SPEAKER_01: The default is called Ask Before Edits.
- 3:31SPEAKER_01: Claude tells you in plain language what it's about to change, and then it waits for you to click allow.
- 3:36SPEAKER_00: And the other setting is accept all edits, which I'm guessing is the first thing my most impatient employee turns on.
- 3:45SPEAKER_01: Probably.
- 3:46SPEAKER_01: In that mode, it works through the job without stopping for ordinary changes.
- 3:50SPEAKER_01: But even in that mode, it still stops and asks before anything that touches links, pictures pulled from the web, web addresses, or who has access to the file.
- 4:00SPEAKER_00: So the careful setting is the default.
- 4:02SPEAKER_00: I'll take that.
- 4:03SPEAKER_00: And I read the list of things that Flat won't do, and I liked it.
- 4:06SPEAKER_00: It can't share the file, it can't give anybody access, and it can't change who owns it.
- 4:11SPEAKER_01: Right.
- 4:12SPEAKER_01: It also can't set up menus or scheduled automations.
- 4:15SPEAKER_01: Anthropic says those requests get refused even if you ask for them.
- 4:18SPEAKER_00: Good.
- 4:19SPEAKER_00: Now here's a detail I caught on that help page that I think matters more than people realize.
- 4:25SPEAKER_00: When Claude makes an edit, whose name goes on it?
- 4:29SPEAKER_01: Yours.
- 4:30SPEAKER_01: Google Records Claude's changes under your name.
- 4:34SPEAKER_01: The same as if you typed them yourself.
- 4:36SPEAKER_01: They show up under file, then version history, like any other edit.
- 4:41SPEAKER_00: So if it fat fingers a price on a quote, the history says, I did it.
- 4:46SPEAKER_01: That's right.
- 4:47SPEAKER_01: And that same history is your safety net.
- 4:50SPEAKER_01: You can hit undo for the last change or restore an earlier version from version history.
- 4:55SPEAKER_01: The receipt is already built into Google.
- 4:58SPEAKER_00: So the shared doc says, Michael edited this and Michael was at lunch.
- 5:02SPEAKER_00: I'd want my whole team to understand that before anybody turns it on.
- 5:06SPEAKER_01: Worth saying out loud at your next staff meeting.
- 5:09SPEAKER_01: One more catch, and this one is sneaky.
- 5:12SPEAKER_01: Files can contain instructions written by somebody else, sometimes hidden in white text or tiny fonts.
- 5:18SPEAKER_00: Wait, somebody can hide a note inside a document that talks to the AI?
- 5:23SPEAKER_00: That's like slipping a fake work order into the middle of the stack.
- 5:27SPEAKER_01: It's a known trick.
- 5:28SPEAKER_01: Anthropic says Claude treats what's in the document as information, not orders, and it labels hidden text when it finds it.
- 5:36SPEAKER_01: But their own advice is to still review what Claude proposes before you approve it, especially in files that came from outside your company.
- 5:43SPEAKER_00: So a bid packet from a contractor or a spreadsheet a customer sent over, those are the ones where I keep it on ask before edits, no matter what.
- 5:52SPEAKER_00: Exactly.
- 5:54SPEAKER_00: Now the data question, because somebody always asks, if I open a customer spreadsheet with Claude, is that going into training the next model?
- 6:02SPEAKER_01: Anthropic says no.
- 6:04SPEAKER_01: It doesn't use this content to train its models.
- 6:07SPEAKER_01: Inputs and outputs are deleted from its systems within 30 days, with a few exceptions spelled out on its help page.
- 6:13SPEAKER_01: And it's not set up for health information, so keep it away from anything with patient details.
- 6:18SPEAKER_00: How hard is it to get going?
- 6:20SPEAKER_00: Because if it takes an IT guy, a lot of folks are out, the help page says about two minutes.
- 6:26SPEAKER_00: If your Google account is allowed to install apps.
- 6:30SPEAKER_01: That's right.
- 6:30SPEAKER_01: Go to the Google Workspace Marketplace, find Claude, click install, and allow the two permissions Google shows you.
- 6:38SPEAKER_01: Then open any Docker sheet, go to extensions, then Claude, then open Claude, and sign in with your Claude account.
- 6:46SPEAKER_00: And if that install button is grayed out.
- 6:49SPEAKER_01: Then your Google Workspace Admin has blocked outside apps, which a lot of companies do by default.
- 6:55SPEAKER_01: The admin can allow Claude or install it for everyone, or just for certain groups, from the Google Admin console, and they can uninstall it for everyone the same way.
- 7:06SPEAKER_00: And in a lot of small shops, the admin is the owner.
- 7:10SPEAKER_00: So that decision is on you, which honestly is how it should be.
- 7:14SPEAKER_01: A few practical limits while it's in beta.
- 7:17SPEAKER_01: Use Chrome, Edge, or Safari, because Firefox isn't supported.
- 7:21SPEAKER_01: Keep the sidebar open while it works.
- 7:23SPEAKER_01: Since closing, it stops the task.
- 7:26SPEAKER_01: And charts it builds and slides go in as pictures, so they won't update when your numbers change.
- 7:31SPEAKER_00: Okay, let me try the takeaway for somebody who doesn't want to test any of this themselves.
- 7:36SPEAKER_00: If you don't pay for Claude, nothing changes for you.
- 7:40SPEAKER_00: Skip it.
- 7:42SPEAKER_01: If you do pay for Claude, and your shop lives in Google Sheets and Docs, it's worth the two-minute install.
- 7:47SPEAKER_01: Start by asking questions about a sheet, not editing it, and leave it on ask before edits.
- 7:54SPEAKER_00: Try it on a copy of a file the first time, and tell your team out loud that Claude's edits show up under their name.
- 8:02SPEAKER_01: Then keep version history in your back pocket.
- 8:04SPEAKER_01: That's the receipt, and it's the undo button.
- 8:08SPEAKER_00: That's the profit.
- 8:09SPEAKER_00: You don't have to install anything to know where the brakes are.
- 8:12SPEAKER_00: Thanks for spending a few minutes with us.
- 8:13SPEAKER_00: If this helped, pass it along to whoever keeps your spreadsheets running.
- 8:18SPEAKER_01: We'll see you next time on Control AI Profit.