`mcp-google-sheets` is a Python-based MCP server that acts as a bridge between any MCP-compatible client (like Claude Desktop) and the Google Sheets
Most developer tooling work still happens through a UI a human drives. MCP Google Sheets MCP server moves it into the conversation instead. mcp-google-sheets is a Python-based MCP server that acts as a bridge between any MCP-compatible client (like Claude Desktop) and the Google Sheets API. It allows you to interact with your Google Spreadsheets using a defined set of tools.
Installation goes through your MCP client rather than a global install: point it at mcp-google-sheets on PyPI and it is fetched when the client starts. The copy-paste blocks for Claude Desktop, Claude Code and Cursor are further down this page.
Configuration is passed through the environment: SERVICE_ACCOUNT_PATH, ENABLED_TOOLS, DRIVE_FOLDER_ID, CREDENTIALS_CONFIG, YOUR_DRIVE_FOLDER_ID, THIS_IS_THE_FOLDER_ID, CREDENTIALS_PATH, TOKEN_PATH. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.
Among the developer tooling options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. It is maintained by xing5; worth a glance at recent repository activity before you build anything load-bearing on it.
This entry was verified against MCP Google Sheets's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.
{
"mcpServers": {
"google-sheets": {
"command": "uvx",
"args": [
"mcp-google-sheets@latest",
"--include-tools",
"get_sheet_data,update_cells,list_spreadsheets,list_sheets"
],
"env": {
"SERVICE_ACCOUNT_PATH": "/path/to/credentials.json"
}
}
}
}Configuration as documented by the project. Restart the client after saving.
| Variable | Description | Required |
|---|---|---|
| SERVICE_ACCOUNT_PATH | Filesystem location the server is allowed to use. | Optional |
| ENABLED_TOOLS | Configuration value read at startup. | Optional |
| DRIVE_FOLDER_ID | Configuration value read at startup. | Optional |
| CREDENTIALS_CONFIG | Configuration value read at startup. | Optional |
| YOUR_DRIVE_FOLDER_ID | Configuration value read at startup. | Optional |
| THIS_IS_THE_FOLDER_ID | Configuration value read at startup. | Optional |
| CREDENTIALS_PATH | Filesystem location the server is allowed to use. | Optional |
| TOKEN_PATH | Credential the server authenticates with. | Yes |
Kill hallucinated APIs — version-accurate, up-to-date library documentation injected straight into context.
Microsoft's official browser automation server — drive a real browser through the accessibility tree, no screenshots needed.
GitHub's official server — repos, issues, pull requests, Actions and code security, straight from your assistant.
Issue tracking at the speed of conversation — Linear's official hosted server with OAuth and zero install.
Local repository surgery — status, diffs, commits, branches and history for any repo on disk.
Timezone sanity for AI — current time anywhere and correct conversions, without the model doing date math.