Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting
npx -y @mcp-z/mcp-sheets{
"GOOGLE_CLIENT_ID": "YOUR_VALUE_HERE",
"GOOGLE_CLIENT_SECRET": "YOUR_SECRET_VALUE",
"GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "YOUR_VALUE_HERE",
"AUTH_MODE": "YOUR_VALUE_HERE",
"HEADLESS": "false",
"REDIRECT_URI": "YOUR_VALUE_HERE",
"RESOURCE_STORE_URI": "YOUR_VALUE_HERE",
"PORT": "YOUR_VALUE_HERE",
"BASE_URL": "YOUR_VALUE_HERE",
"LOG_LEVEL": "YOUR_VALUE_HERE",
"DCR_MODE": "self-hosted",
"DCR_VERIFY_URL": "YOUR_VALUE_HERE",
"DCR_STORE_URI": "file://~/.mcp-z/mcp-sheets/dcr.json"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-mcp-z-mcp-sheets": {
"command": "npx",
"args": [
"-y",
"@mcp-z/mcp-sheets"
],
"env": {
"GOOGLE_CLIENT_ID": "YOUR_VALUE_HERE",
"GOOGLE_CLIENT_SECRET": "YOUR_SECRET_VALUE",
"GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "YOUR_VALUE_HERE",
"AUTH_MODE": "YOUR_VALUE_HERE",
"HEADLESS": "false",
"REDIRECT_URI": "YOUR_VALUE_HERE",
"RESOURCE_STORE_URI": "YOUR_VALUE_HERE",
"PORT": "YOUR_VALUE_HERE",
"BASE_URL": "YOUR_VALUE_HERE",
"LOG_LEVEL": "YOUR_VALUE_HERE",
"DCR_MODE": "self-hosted",
"DCR_VERIFY_URL": "YOUR_VALUE_HERE",
"DCR_STORE_URI": "file://~/.mcp-z/mcp-sheets/dcr.json"
}
}
}
}~/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.
Google Sheets is an MCP server for Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting. It supports STDIO, HTTP transport.
Use the generated config in Install. This server runs with npx -y @mcp-z/mcp-sheets; add any required environment variables before starting your client.
Choose the Claude Desktop tab in Install and copy the config for npx -y @mcp-z/mcp-sheets. Add required environment variables before starting Claude Desktop.
Choose the Claude Code tab in Install and copy the config for npx -y @mcp-z/mcp-sheets. Add required environment variables before starting Claude Code.
Choose the Codex tab in Install and copy the config for npx -y @mcp-z/mcp-sheets. Add required environment variables before starting Codex.
Choose the Cursor or VS Code tab in Install and copy the config for npx -y @mcp-z/mcp-sheets. Add required environment variables before starting Cursor or VS Code.
Google Sheets uses STDIO, HTTP transport. Use the package or command config in Install.
Google Sheets inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
Google Sheets 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-z/mcp-sheetsstdio | npm | 1.0.7 | Argument: --auth Argument: --headless Argument: --redirect-uri Argument: --service-account-key-file Argument: --resource-store-uri Argument: --base-url Argument: --log-level Env: GOOGLE_CLIENT_ID required Env: GOOGLE_CLIENT_SECRET secret Env: GOOGLE_SERVICE_ACCOUNT_KEY_FILE Env: AUTH_MODE Env: HEADLESS Env: REDIRECT_URI Env: RESOURCE_STORE_URI Env: PORT Env: BASE_URL Env: LOG_LEVEL |