sheets-mcp
Integrates with Google Sheets and Google Drive, enabling spreadsheet and file management such as listing, creating, copying, moving, sharing, importing/exporting, editing tabs and values, modifying rows/columns, and formatting cells.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
sheets-mcp
A general-purpose MCP server for Google Sheets. It lets an MCP client such as Claude find, create, copy, move, share, import, export and delete spreadsheets; add, edit, copy and delete tabs; read, write, append and clear values; insert, move, resize and delete rows and columns; and format cells.
Tools
Object | Tools |
Files |
|
Sharing |
|
Import, export |
|
Tabs |
|
Values |
|
Rows, columns |
|
Formatting |
|
Each tool carries MCP annotations. The four read tools are marked read-only, and every tool that overwrites or removes data is marked destructive, so a client can ask before running one.
Related MCP server: google-sheets-mcp
Installation
pipx install git+https://github.com/bissli/sheets-mcpCredentials
The server reads one of three kinds of Google credentials:
Application Default Credentials. With no
--credentialsflag, the server uses the account set bygcloud auth application-default login --scopes=https://www.googleapis.com/auth/spreadsheets,https://www.googleapis.com/auth/drive,https://www.googleapis.com/auth/cloud-platform.A personal Google account. A Desktop app OAuth client from the Google Cloud console, with the Sheets and Drive APIs enabled.
sheets-mcp login client.jsonruns the browser consent once and stores the token in~/.config/sheets-mcp/token.json. The server then runs with--credentials client.json.A service account.
--credentials key.jsonwith the account's key file. A service account sees only the files shared with its email address, and has no My Drive storage, so it creates files in a shared drive folder.
The server asks for the spreadsheets and drive scopes. Moving, sharing
and deleting any file the account can reach needs the full Drive scope.
Client setup
Claude Code:
claude mcp add sheets -- sheets-mcp --credentials ~/client.jsonClaude Desktop, in claude_desktop_config.json:
{
"mcpServers": {
"sheets": {
"command": "sheets-mcp",
"args": ["--credentials", "/home/ana/client.json"]
}
}
}--read-only serves only the four read tools.
Safety
delete_filemoves a file to the trash. Onlypermanent=truedeletes it beyond recovery.A written value that Sheets would parse as a formula may not call IMPORTXML, IMPORTHTML, IMPORTDATA, IMPORTFEED, IMPORTRANGE or IMAGE. Those functions fetch a URL, so a prompt injection could use them to send cell contents to a third party.
copy_tabapplies the same check to a tab it copies into another spreadsheet.The check closes only that channel. Any write or copy into a file or folder someone else can read shows them the data, so a client should confirm write tools whose target it did not choose.
read_rangeanswers in pages of at most 60 KB, withnext_offsetfor the next page.export_spreadsheetkeeps an existing local file unless the call setsoverwrite=true.The server runs over stdio only, so no network port exposes the account.
Development
poetry install --with test
poetry run pytestThe tests run against an in-memory fake of the Drive and Sheets APIs in
tests/fake_google.py and make no network calls.
License
MIT
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Hosted Google Sheets MCP server, with each action switched on or off per account.
Streamable HTTP MCP server for Google Calendar and Sheets with OAuth login.
An MCP server that provides read access to your cloud storage providers, bank accounts and more.
Google Ads MCP server — manage campaigns, keywords, and metrics.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceAn MCP server that enables interaction with Google Sheets through natural language, allowing users to create, read, update, and manage spreadsheet data via the Google Sheets API v4.-
- AlicenseNot gradedqualityBmaintenanceMCP server for Google Sheets - read, write, and query spreadsheet data.599 npm2MIT
- AlicenseAqualityDmaintenanceMCP server for interacting with Google Sheets, providing tools to list sheets, read data from cell ranges, and write data to cell ranges.33MIT
- AlicenseNot gradedqualityCmaintenanceMCP server for Google Sheets operations, enabling spreadsheet management including reading, writing, appending, creating, and searching sheets via natural language.MIT