Google Sheets MCP
MCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts…
- Pricing
- Open source
- Runs
- Locally
- Version
- 1.1.2
- Listing updated
- 4 days ago
About Google Sheets MCP
Google Sheets MCP is an open-source MCP server. It runs locally on your machine and is started by your AI client.
MCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing.
Install
Run in a terminal
claude mcp add mcp-google-sheets --env GOOGLE_SHEETS_CLIENT_SECRET='<GOOGLE_SHEETS_CLIENT_SECRET>' --env GOOGLE_SHEETS_REFRESH_TOKEN='<GOOGLE_SHEETS_REFRESH_TOKEN>' --env GOOGLE_SHEETS_ACCESS_TOKEN='<GOOGLE_SHEETS_ACCESS_TOKEN>' -- npx -y @a1-x-tech/mcp-google-sheetsAdd to claude_desktop_config.json
{
"mcpServers": {
"mcp-google-sheets": {
"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
{
"mcpServers": {
"mcp-google-sheets": {
"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
{
"servers": {
"mcp-google-sheets": {
"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 ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"mcp-google-sheets": {
"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 your client's MCP settings (most use this shape)
{
"mcpServers": {
"mcp-google-sheets": {
"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>"
}
}
}
}Configuration
GOOGLE_SHEETS_CLIENT_IDGoogle OAuth2 client id (refresh-token flow).GOOGLE_SHEETS_CLIENT_SECRETGoogle OAuth2 client secret (refresh-token flow). Treat it as a secret.GOOGLE_SHEETS_REFRESH_TOKENGoogle OAuth2 refresh token, exchanged for access tokens automatically. Treat it as a secret.GOOGLE_SHEETS_ACCESS_TOKENStatic OAuth2 access token (~1h lifetime) — alternative to the refresh-token trio, mostly for testing.GOOGLE_SHEETS_OAUTH_PORTFixed 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_BASESheets API root override.GOOGLE_SHEETS_TIMEOUT_MSPer-request timeout in milliseconds.GOOGLE_SHEETS_MAX_RETRIESRetries on transient errors (429 always; 5xx/network for reads).
Pricing
Open source
Google Sheets MCP FAQ
Is Google Sheets MCP free?
Yes. Google Sheets MCP is open source, so you can use and self-host it for free.
How do I add Google Sheets MCP to Claude Code?
Run this command in your terminal: claude mcp add mcp-google-sheets --env GOOGLE_SHEETS_CLIENT_SECRET='<GOOGLE_SHEETS_CLIENT_SECRET>' --env GOOGLE_SHEETS_REFRESH_TOKEN='<GOOGLE_SHEETS_REFRESH_TOKEN>' --env GOOGLE_SHEETS_ACCESS_TOKEN='<GOOGLE_SHEETS_ACCESS_TOKEN>' -- npx -y @a1-x-tech/mcp-google-sheets