MCP server for Google Sheets API — read, write, format, batch operations.
Connect Runs on your machine
claude mcp add mcp-gsheets -e GOOGLE_PROJECT_ID=<GOOGLE_PROJECT_ID> -e GOOGLE_APPLICATION_CREDENTIALS=<GOOGLE_APPLICATION_CREDENTIALS> -e GOOGLE_SERVICE_ACCOUNT_KEY=<GOOGLE_SERVICE_ACCOUNT_KEY> -e GOOGLE_PRIVATE_KEY=<GOOGLE_PRIVATE_KEY> -e GOOGLE_CLIENT_EMAIL=<GOOGLE_CLIENT_EMAIL> -- npx -y [email protected]{
"mcpServers": {
"mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"GOOGLE_PROJECT_ID": "<GOOGLE_PROJECT_ID>",
"GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
"GOOGLE_SERVICE_ACCOUNT_KEY": "<GOOGLE_SERVICE_ACCOUNT_KEY>",
"GOOGLE_PRIVATE_KEY": "<GOOGLE_PRIVATE_KEY>",
"GOOGLE_CLIENT_EMAIL": "<GOOGLE_CLIENT_EMAIL>"
}
}
}
}{
"mcpServers": {
"mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"GOOGLE_PROJECT_ID": "<GOOGLE_PROJECT_ID>",
"GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
"GOOGLE_SERVICE_ACCOUNT_KEY": "<GOOGLE_SERVICE_ACCOUNT_KEY>",
"GOOGLE_PRIVATE_KEY": "<GOOGLE_PRIVATE_KEY>",
"GOOGLE_CLIENT_EMAIL": "<GOOGLE_CLIENT_EMAIL>"
}
}
}
}{
"servers": {
"mcp-gsheets": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"GOOGLE_PROJECT_ID": "<GOOGLE_PROJECT_ID>",
"GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
"GOOGLE_SERVICE_ACCOUNT_KEY": "<GOOGLE_SERVICE_ACCOUNT_KEY>",
"GOOGLE_PRIVATE_KEY": "<GOOGLE_PRIVATE_KEY>",
"GOOGLE_CLIENT_EMAIL": "<GOOGLE_CLIENT_EMAIL>"
}
}
}
}Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
GOOGLE_PROJECT_IDRequired | Google Cloud project ID |
GOOGLE_APPLICATION_CREDENTIALSOptional | Path to service account key JSON file (auth method 1) |
GOOGLE_SERVICE_ACCOUNT_KEYOptional, secret | Service account key as JSON string (auth method 2) |
GOOGLE_PRIVATE_KEYOptional, secret | Service account private key in PEM format (auth method 3) |
GOOGLE_CLIENT_EMAILOptional | Service account email (auth method 3) |
Details
| Package | [email protected] (NPM, stdio) |
| First published | 6 Nov 2026 |
| Last updated | 6 Nov 2026 |
| Registry name | io.github.freema/mcp-gsheets |
More search and web servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.