mcp-gsheets
mcp-gsheets reads and edits Google Sheets through a service account: values, formatting, charts and native tables.
- 105 ★ on the repository
- Last commit
- MIT
Extended access
Why this level
- The server can delete rows, columns and sheets in spreadsheets shared with the service account.
- The service account key is stored in the client configuration.
Install
- Works in
In your terminal, with SkillFoxx CLI
npx skillfoxx add mcp/mcp-gsheetsDetects the agents on your machine, shows the access level and pins the version.
Other ways to install
Access and checks
How we reviewExtended accessThe tool runs code or makes network calls and only reads external data.
- The server can delete rows, columns and sheets in spreadsheets shared with the service account.
- The service account key is stored in the client configuration.
This is third-party code. Review the repository files before installing.
What it does
mcp-gsheets is an MCP server that connects a client to the Google Sheets API. Its tools read range values, write and append rows, create and delete sheets, format cells, add conditional formatting, build charts and manage native tables. Access goes through a Google Cloud service account: the key can be a file, a JSON string or a private key and email pair. To keep context small, the tool set can be trimmed with toolsets. A Claude Code plugin ships in the repository and the server is published in the MCP registry.
Who it is for. Developers and analysts who keep reports and records in Google Sheets and want to delegate edits to an agent.
Good fit when
- An agent fills a sheet with parsing results row by row.
- Formatting across several sheets must be made uniform.
- A chart is needed from range data inside the file itself.
- Data is copied from one spreadsheet to another without manual steps.
Not a fit when
- A Google Cloud project and a service account cannot be created.
- The spreadsheet cannot be shared with the service account email.
- Work as a personal account through OAuth sign-in is required.
Example request
Append the weekly totals to the report sheet with INSERT_ROWS, then format the header and build a column chart.MCP
- Transport
- stdio
- Authentication
- API key
Environment variables
GOOGLE_PROJECT_IDrequired- Google Cloud project ID
GOOGLE_APPLICATION_CREDENTIALSrequired, secret- Path to the service account JSON key
Limitations
It needs Node.js 22 or newer, a Google Cloud project with the Sheets API enabled and a service account with a JSON key. The spreadsheet must be shared with the service account email. Destructive tools exist: deleting rows, columns and sheets. `sheets_append_values` defaults `insertDataOption` to `OVERWRITE`, so set `INSERT_ROWS`. The account key lives in the client configuration. The server makes no backups of spreadsheets, so copy the file in Google Sheets before bulk edits.
How to disable. Run `claude mcp remove mcp-gsheets` or delete the entry from the client config. Revoke the service account's access in the spreadsheets and delete its key in the Google Cloud console.
FAQ
How do I give the server access to a spreadsheet?
Open the spreadsheet, click Share and add the service account email from the JSON key. Verify with the `sheets_check_access` tool.
How can the key be supplied?
A file via `GOOGLE_APPLICATION_CREDENTIALS`, a JSON string in `GOOGLE_SERVICE_ACCOUNT_KEY`, or the pair `GOOGLE_PRIVATE_KEY` and `GOOGLE_CLIENT_EMAIL`.
How do I reduce the number of tools?
The toolsets section of the README describes trimming the set so tool descriptions take less context.
Why were rows overwritten when appending?
`insertDataOption` defaults to `OVERWRITE`. Pass `INSERT_ROWS` to push existing rows down.
Is OAuth sign-in needed?
No. The server works through a Google Cloud service account and does not use personal user sign-in.
Discussion
No questions or reviews yet.
Related
MCP serversGoogle Docs MCP: Docs, Sheets, Drive, Gmail and Calendar
Google Docs MCP
An MCP server giving an agent Google Docs, Sheets, Drive, Gmail, Calendar and Apps Script: reading, editing, mail and events; sign-in over OAuth
One MCP server for Gmail, Calendar, Drive, Docs, Sheets, Slides, Forms, Tasks, Contacts, Chat and Apps Script with OAuth 2.1
GSuite MCP
mcp-gsuite
A Python MCP server for Gmail and Google Calendar: search and read emails, drafts and replies, events with attendees, several accounts at once
MCP server for Google mail, calendar and files: an agent works across several accounts as you
Google Calendar MCP Server: calendar for Claude
Google Calendar MCP Server
A calendar MCP for Claude Desktop: the agent views, creates, updates and deletes Google Calendar events, recurring ones included
A CLI for every Google Workspace API with JSON output and agent skills: Drive, Gmail, Calendar, Sheets and more
README in short
The README moves from requirements and quick install to Google Cloud setup, three ways to supply the key and a table of dozens of tools grouped by reading, writing, formatting and charts.