Claude Cowork and Google Sheets: Read Yes, Edit No
Cowork can read your Google Sheets and cannot edit them in place. There is no Google Sheets connector in Anthropic’s directory. Sheets arrive through the Google Drive connector, whose documented capability is to “read Sheets, Slides, PDFs, images, and MS Office files.” Read. Not update, not append, not set a cell.
What Cowork does instead is build a new spreadsheet, which for a lot of jobs is the better outcome anyway. Here is the exact shape of what works, and the two ways to get changes back into the sheet your team already uses.
What the Drive connector actually gives Cowork
| Action on a Google Sheet | Available |
|---|---|
| Find the sheet by search or URL | Yes |
| Read its contents into the task | Yes |
| Look up file metadata and permissions | Yes |
| Create a brand new file in Drive | Yes |
| Upload a file, optionally converting to Google format | Yes |
| Share, move or trash the file | Yes, with approval |
| Change a value in an existing sheet | No tool for it |
| Add a row to an existing sheet | No tool for it |
| Write a formula into an existing sheet | No tool for it |
One caveat on the read side that bites in practice: Anthropic notes that Claude “extracts text content only from Google Drive files” and that images embedded in documents are not processed. A sheet whose real content is a pasted screenshot of a table comes back empty.
What Cowork builds instead, and why it is genuinely good
Cowork’s spreadsheet output is Excel, and it is not a flat CSV dump. Anthropic’s own description is “Excel files with working VLOOKUP, conditional formatting, and multiple tabs, not just CSVs that need fixing.” Sub-agents run parts of a large job in parallel, so a multi-source build is not a single slow pass.
The worked example on Anthropic’s Cowork page is a month-end close, and it is a fair picture of the sweet spot:
Our October close is in the Close/October folder. Pull actuals from the four regional exports, roll them into one summary tab, and compare against the budget file. Flag any line where the variance is over 5% or over $50k. Give me a tab per region plus the summary, and a short note on what didn’t reconcile.
That job reads several files and produces one new file. Nothing in it edits an existing sheet, which is exactly why it fits.
Once the file exists, Claude for Excel and Claude for PowerPoint pick up where Cowork stops, so further edits happen inside the Office surface rather than back in the task thread.
Getting the result into your real Google Sheet
Three routes, in ascending order of effort.
1. Save and convert. Cowork can save its generated files straight to Drive, and Drive’s upload capability includes optional auto-convert to Google formats. So the .xlsx Cowork built lands in Drive as a Google Sheet. This creates a new sheet. It does not update the one your dashboard is pointed at.
2. Paste the range. For a small result, have Cowork output the values and formulas as text and paste them in yourself. Unglamorous and reliable.
3. A Google Sheets MCP server. Sheets has a real write API, and third-party MCP servers expose it. Add one under Customize → Connectors → Add custom connector and Cowork gains actual cell-level writes. Anthropic’s documentation confirms custom remote MCP connectors work “on Claude, Cowork, and Claude Desktop” across free and paid plans, with free accounts limited to one. The catch is that the server is called from Anthropic’s cloud, so it has to be reachable on the public internet, and you are the one running it.
The part no connector solves
Even with an MCP server wired up, the run has to be started. Cowork’s /schedule command gets you daily, weekly or monthly runs in Anthropic’s cloud without your laptop awake, which is real. A clock is still not an event.
MCP has no trigger mechanism and no scheduler. Its own Triggers and Events working group opens by conceding that clients learn about server-side changes by polling, and that work is still listed as on the horizon rather than shipped.
So “update the tracker whenever a deal closes” is not a Cowork job. “Rebuild the tracker every Monday at 8am” is.
Sheets that update themselves
Carly connects Google Sheets natively, alongside Excel, Airtable, Coda and Notion, from its 260+ integrations. The difference is direction: a Carly workflow starts when something happens, and writing a row is a step in it rather than a thing you ask for.
The jobs people actually wire up look like this. A form submission appends a row and tags the lead. An inbound email from a client updates the status column and drafts the reply. A closed deal in the CRM writes the amount into the revenue tab and posts the number to Slack. A booking on your calendar logs itself against the account.
Because Carly holds several accounts at once, the sheet in your work Google identity and the mailbox in your personal one can be steps in the same workflow, which is where the single-identity connector model runs out. Zapier-style workflow steps are free, so the spreadsheet plumbing costs nothing to run, and AI agents start at $35 a month for the parts that need judgment. Wire the first one at carlyassistant.com.
FAQ
Can Claude Cowork edit Google Sheets?
Not through the built-in Google Drive connector, which reads Sheets but exposes no tool to change a cell, add a row or write a formula into an existing file. A third-party Google Sheets MCP server added as a custom connector does give Cowork cell-level writes.
Can Claude Cowork read a Google Sheet?
Yes. The Drive connector searches for the file, reads its contents and reports its metadata and permissions. It extracts text only, so tables pasted in as images are not read.
Does Cowork output Excel or Google Sheets?
Excel. Cowork generates .xlsx files with working formulas, multiple tabs and conditional formatting, then can save them to Drive with optional conversion to Google Sheets format.
Is there a Google Sheets connector for Claude?
No. Anthropic’s directory has no standalone Google Sheets entry. Sheets are reached through the Google Drive connector or through a custom MCP server you supply.
Can Cowork update a sheet on a schedule?
It can rebuild one on a schedule. Type /schedule in a Cowork task to run daily, weekly or monthly in Anthropic’s cloud with no device online, though the run starts from the clock rather than from a change in your data.
More: Claude Cowork connectors · Can Claude edit Google Sheets · Google Sheets MCP · Claude Cowork use cases · Best AI assistants for Google Sheets
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
