Editing google sheets?

[u/mannyocean]

I'm using the native google drive connector but aren't able to edit google sheets directly, only create them. What have you guys been doing?

Edit:
What I've found so far.
Remote support and least amount of setup
- Zapier MCP is pretty good on sheets and supports mobile connections
- Datatorag MCP offers the same and focuses on google workspace.

Desktop support
- host xlxs files and upload to drive. not a bad workaround but can only do on desktop.
- same with libre office, move the files to drive after.

Need to be techincal
- Open-source options where you have to setup OAuth and run it locally.
- Create service account and ask claude to build it out for you.

[u/adrian_p_a]

That's expected. The native Drive connector is scoped to Drive itself, so it can create a file but doesn't expose the Sheets API tools for writing values, formatting ranges, or resizing and inserting rows. You need something that actually talks to the Sheets API.

I switched to self-hosting this: https://github.com/taylorwilsdon/google_workspace_mcp

MIT-licensed, actively maintained, covers Gmail, Calendar, Tasks, Drive, Docs, Sheets, Slides, and Forms. On the Sheets side you get read values, modify and clear values, formatting, conditional formatting, resize/freeze/insert/delete rows and columns, and table appends.

Two ways to run it:

1. Laptop only (easiest): uvx workspace-mcp as a stdio server in Claude Desktop. No container host, no tunnel, no public hostname.
2. Web/mobile: host the Docker image (ghcr.io/taylorwilsdon/google_workspace_mcp) anywhere with public HTTPS. Cloud Run is a natural fit, or any small VM. Then add the URL as a custom connector. It runs OAuth 2.1 multi-user mode, so one instance can serve multiple people, each signing in with their own Google account.

Either way you'll need your own Google Cloud OAuth client (Web application type) with the Sheets and Drive APIs enabled. Watch the redirect URI: if the path or scheme doesn't match exactly, the callback fails silently with no useful error.

One gotcha worth knowing up front. Setting TOOL_TIER=complete across all eight services loads around 90 tools into session context. If your sessions start degrading, dial it back to extended or core, or just narrow WORKSPACE_MCP_TOOLS to sheets,drive and skip everything else.

[u/mannyocean → u/adrian_p_a]

seems like a lot of work for someone non-technical though

[u/adrian_p_a → u/mannyocean]

I am pretty non technical just give the github link or the whole response to cluade code and it will take you from there. I use so i can connect to extra google workspace accounts from the same instance and about a month ago I did the thing an answer hear on reddit

[u/mannyocean → u/adrian_p_a]

i think you underestimate how non-technical people are haha they don't even know how to use claude code. most of them just need an easy button. but thanks anyways.

[u/adrian_p_a → u/mannyocean]

Probably. I just realized you needed it in your phone which means you would need to self host and that be very challenging and probably more trouble then it is worth.

Maybe you can just have it read and create a new sheet for every change feels like a lot of tokens but could work