MCP server
Google Sheets
Google Sheets integration with OAuth, spreadsheet management, batch operations, and…
- Runs
- Locally or Remotely
- Version
- 2.6.1
- Listing updated
- 5 days ago
About Google Sheets
Google Sheets is an MCP server. It can run locally on your machine or as a hosted remote server.
Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting
Install
Run in a terminal
claude mcp add mcp-sheets --env GOOGLE_CLIENT_ID='<GOOGLE_CLIENT_ID>' --env GOOGLE_CLIENT_SECRET='<GOOGLE_CLIENT_SECRET>' -- npx -y @mcp-z/mcp-sheetsAdd to claude_desktop_config.json
{
"mcpServers": {
"mcp-sheets": {
"command": "npx",
"args": [
"-y",
"@mcp-z/mcp-sheets"
],
"env": {
"GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
"GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"mcp-sheets": {
"command": "npx",
"args": [
"-y",
"@mcp-z/mcp-sheets"
],
"env": {
"GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
"GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"mcp-sheets": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@mcp-z/mcp-sheets"
],
"env": {
"GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
"GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"mcp-sheets": {
"command": "npx",
"args": [
"-y",
"@mcp-z/mcp-sheets"
],
"env": {
"GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
"GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"mcp-sheets": {
"command": "npx",
"args": [
"-y",
"@mcp-z/mcp-sheets"
],
"env": {
"GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
"GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
}
}
}
}Using several servers? Build one config file with the MCP config generator.
Configuration
GOOGLE_CLIENT_IDGoogle OAuth client ID (required for OAuth authentication modes)RequiredGOOGLE_CLIENT_SECRETGoogle OAuth client secret (optional for public clients)GOOGLE_SERVICE_ACCOUNT_KEY_FILEPath to service account JSON key file (required for service-account auth mode)AUTH_MODEAuthentication modeHEADLESSDisable browser auto-open, return auth URL instead (true/false)REDIRECT_URIOAuth redirect URI (optional, default: ephemeral loopback)RESOURCE_STORE_URIResource store URI for exported files (file://)PORTHTTP server port (overrides --port)BASE_URLBase URL for HTTP transport (used for OAuth/DCR endpoints and file links)LOG_LEVELLogging levelGOOGLE_CLIENT_IDGoogle OAuth client ID (required for OAuth authentication modes)RequiredGOOGLE_CLIENT_SECRETGoogle OAuth client secret (optional for public clients)GOOGLE_SERVICE_ACCOUNT_KEY_FILEPath to service account JSON key file (required for service-account auth mode)AUTH_MODEAuthentication modeHEADLESSDisable browser auto-open, return auth URL instead (true/false)REDIRECT_URIOAuth redirect URI (optional, default: ephemeral loopback)DCR_MODEDynamic Client Registration modeDCR_VERIFY_URLExternal verification endpoint URL (required for external DCR mode)DCR_STORE_URIDCR client storage URI (for self-hosted DCR mode)RESOURCE_STORE_URIResource store URI for exported files (file://)PORTHTTP server port (overrides --port)BASE_URLBase URL for HTTP transport (used for OAuth/DCR endpoints and file links)LOG_LEVELLogging level
Google Sheets FAQ
How do I add Google Sheets to Claude Code?
Run this command in your terminal: claude mcp add mcp-sheets --env GOOGLE_CLIENT_ID='<GOOGLE_CLIENT_ID>' --env GOOGLE_CLIENT_SECRET='<GOOGLE_CLIENT_SECRET>' -- npx -y @mcp-z/mcp-sheets
Where this comes from
- Description: from the official MCP Registry entry.
- Install steps: from the official MCP Registry entry.