MCP server for Google Sheets API — read, write, format, batch operations.
npx -y mcp-gsheets{
"GOOGLE_PROJECT_ID": "YOUR_VALUE_HERE",
"GOOGLE_APPLICATION_CREDENTIALS": "YOUR_VALUE_HERE",
"GOOGLE_SERVICE_ACCOUNT_KEY": "YOUR_SECRET_VALUE",
"GOOGLE_PRIVATE_KEY": "YOUR_SECRET_VALUE",
"GOOGLE_CLIENT_EMAIL": "YOUR_VALUE_HERE"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-freema-mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"mcp-gsheets"
],
"env": {
"GOOGLE_PROJECT_ID": "YOUR_VALUE_HERE",
"GOOGLE_APPLICATION_CREDENTIALS": "YOUR_VALUE_HERE",
"GOOGLE_SERVICE_ACCOUNT_KEY": "YOUR_SECRET_VALUE",
"GOOGLE_PRIVATE_KEY": "YOUR_SECRET_VALUE",
"GOOGLE_CLIENT_EMAIL": "YOUR_VALUE_HERE"
}
}
}
}~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.jsonNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
mcp-gsheets is an MCP server for MCP server for Google Sheets API — read, write, format, batch operations.. It supports STDIO transport.
Use the generated config in Install. This server runs with npx -y mcp-gsheets; add any required environment variables before starting your client.
Choose the Claude Desktop tab in Install and copy the config for npx -y mcp-gsheets. Add required environment variables before starting Claude Desktop.
Choose the Claude Code tab in Install and copy the config for npx -y mcp-gsheets. Add required environment variables before starting Claude Code.
Choose the Codex tab in Install and copy the config for npx -y mcp-gsheets. Add required environment variables before starting Codex.
Choose the Cursor or VS Code tab in Install and copy the config for npx -y mcp-gsheets. Add required environment variables before starting Cursor or VS Code.
mcp-gsheets uses STDIO transport. Use the package or command config in Install.
mcp-gsheets inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
mcp-gsheets is marked with Auth required by registry metadata auth. You may need provider login, an API key, a bearer token, or a session header.
| Package | Registry | Version | Inputs |
|---|---|---|---|
mcp-gsheetsstdio | npm | 1.8.1 | Env: GOOGLE_PROJECT_ID required Env: GOOGLE_APPLICATION_CREDENTIALS Env: GOOGLE_SERVICE_ACCOUNT_KEY secret Env: GOOGLE_PRIVATE_KEY secret Env: GOOGLE_CLIENT_EMAIL |