Google Sheets MCP Server
by a1-x-techio.github.A1-x-Tech/mcp-google-sheetsv1.0.0
MCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing.
context tax
queued
security
queued
cold start
queued
freshness
Active6d ago
Install Google Sheets MCP server
Install in Claude Code
claude mcp add google-sheets-a1-x-tech -e GOOGLE_SHEETS_CLIENT_SECRET='<google-sheets-client-secret>' -e GOOGLE_SHEETS_REFRESH_TOKEN='<google-sheets-refresh-token>' -e GOOGLE_SHEETS_ACCESS_TOKEN='<google-sheets-access-token>' -- npx -y @a1-x-tech/mcp-google-sheetsInstall in Cursor
{
"mcpServers": {
"google-sheets-a1-x-tech": {
"command": "npx",
"args": [
"-y",
"@a1-x-tech/mcp-google-sheets"
],
"env": {
"GOOGLE_SHEETS_CLIENT_SECRET": "<google-sheets-client-secret>",
"GOOGLE_SHEETS_REFRESH_TOKEN": "<google-sheets-refresh-token>",
"GOOGLE_SHEETS_ACCESS_TOKEN": "<google-sheets-access-token>"
}
}
}
}Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).
Install in Claude Desktop
{
"mcpServers": {
"google-sheets-a1-x-tech": {
"command": "npx",
"args": [
"-y",
"@a1-x-tech/mcp-google-sheets"
],
"env": {
"GOOGLE_SHEETS_CLIENT_SECRET": "<google-sheets-client-secret>",
"GOOGLE_SHEETS_REFRESH_TOKEN": "<google-sheets-refresh-token>",
"GOOGLE_SHEETS_ACCESS_TOKEN": "<google-sheets-access-token>"
}
}
}
}Settings → Developer → Edit Config (claude_desktop_config.json), then restart.
Install in VS Code
{
"servers": {
"google-sheets-a1-x-tech": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@a1-x-tech/mcp-google-sheets"
],
"env": {
"GOOGLE_SHEETS_CLIENT_SECRET": "<google-sheets-client-secret>",
"GOOGLE_SHEETS_REFRESH_TOKEN": "<google-sheets-refresh-token>",
"GOOGLE_SHEETS_ACCESS_TOKEN": "<google-sheets-access-token>"
}
}
}
}Add to .vscode/mcp.json in your workspace.
Install in Windsurf
{
"mcpServers": {
"google-sheets-a1-x-tech": {
"command": "npx",
"args": [
"-y",
"@a1-x-tech/mcp-google-sheets"
],
"env": {
"GOOGLE_SHEETS_CLIENT_SECRET": "<google-sheets-client-secret>",
"GOOGLE_SHEETS_REFRESH_TOKEN": "<google-sheets-refresh-token>",
"GOOGLE_SHEETS_ACCESS_TOKEN": "<google-sheets-access-token>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json.
Configuration
| Variable | Required | Secret | Description |
|---|---|---|---|
| GOOGLE_SHEETS_CLIENT_ID | — | — | Google OAuth2 client id (refresh-token flow). |
| GOOGLE_SHEETS_CLIENT_SECRET | — | yes | Google OAuth2 client secret (refresh-token flow). Treat it as a secret. |
| GOOGLE_SHEETS_REFRESH_TOKEN | — | yes | Google OAuth2 refresh token, exchanged for access tokens automatically. Treat it as a secret. |
| GOOGLE_SHEETS_ACCESS_TOKEN | — | yes | Static OAuth2 access token (~1h lifetime) — alternative to the refresh-token trio, mostly for testing. |
| GOOGLE_SHEETS_OAUTH_PORT | — | — | Fixed port for the loopback listener of the in-chat login (127.0.0.1 + PKCE). Set it when the client runs over SSH port forwarding; otherwise a free port is picked per login. |
| GOOGLE_SHEETS_API_BASE | — | — | Sheets API root override. |
| GOOGLE_SHEETS_TIMEOUT_MS | — | — | Per-request timeout in milliseconds. |
| GOOGLE_SHEETS_MAX_RETRIES | — | — | Retries on transient errors (429 always; 5xx/network for reads). |
Freshness
Active — last maintenance signal 6d ago. The newest of the signals below sets the band.
Last commit (default branch)
2026-10-04 · 6d ago · GitHub
Latest release
2026-09-23 · 16d ago · GitHub · v1.0.0
Package published
no data · npm/PyPI
Registry entry updated
2026-09-23 · 16d ago · official registry · v1.0.0
FAQ
›How do I install the Google Sheets MCP server in Claude Code?
Run: claude mcp add google-sheets-a1-x-tech -e GOOGLE_SHEETS_CLIENT_SECRET='<google-sheets-client-secret>' -e GOOGLE_SHEETS_REFRESH_TOKEN='<google-sheets-refresh-token>' -e GOOGLE_SHEETS_ACCESS_TOKEN='<google-sheets-access-token>' -- npx -y @a1-x-tech/mcp-google-sheets. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.
›Does Google Sheets require an API key?
Yes. It expects GOOGLE_SHEETS_CLIENT_SECRET, GOOGLE_SHEETS_REFRESH_TOKEN, GOOGLE_SHEETS_ACCESS_TOKEN, of which 3 are secrets.
›Can I use Google Sheets as a remote (hosted) MCP server?
No hosted endpoint is published; it runs locally over stdio.
›Is Google Sheets in the official MCP registry?
Yes, as io.github.A1-x-Tech/mcp-google-sheets.