MCP Server

Google Sheets MCP Server

Name: Google Sheets MCP Server
Author: io.github.mcp-z

io.github.mcp-z/mcp-sheets

Registry

What is the Google Sheets MCP server?

Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting

How to install Google Sheets

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

GOOGLE_CLIENT_ID
required
Google OAuth client ID (required for OAuth authentication modes)
GOOGLE_CLIENT_SECRET
secret
Google OAuth client secret (optional for public clients)
GOOGLE_SERVICE_ACCOUNT_KEY_FILE
Path to service account JSON key file (required for service-account auth mode)
AUTH_MODE
Authentication mode
HEADLESS
Disable browser auto-open, return auth URL instead (true/false)
REDIRECT_URI
OAuth redirect URI (optional, default: ephemeral loopback)
RESOURCE_STORE_URI
Resource store URI for exported files (file://)
PORT
HTTP server port (overrides --port)
BASE_URL
Base URL for HTTP transport (used for OAuth/DCR endpoints and file links)
LOG_LEVEL
Logging level
DCR_MODE
Dynamic Client Registration mode
DCR_VERIFY_URL
External verification endpoint URL (required for external DCR mode)
DCR_STORE_URI
DCR client storage URI (for self-hosted DCR mode)

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets",
        "-y",
        "--auth",
        "--headless",
        "--redirect-uri",
        "--service-account-key-file",
        "--resource-store-uri",
        "--base-url",
        "--log-level"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<YOUR_GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<YOUR_GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<YOUR_AUTH_MODE>",
        "HEADLESS": "<YOUR_HEADLESS>",
        "REDIRECT_URI": "<YOUR_REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<YOUR_RESOURCE_STORE_URI>",
        "PORT": "<YOUR_PORT>",
        "BASE_URL": "<YOUR_BASE_URL>",
        "LOG_LEVEL": "<YOUR_LOG_LEVEL>",
        "DCR_MODE": "<YOUR_DCR_MODE>",
        "DCR_VERIFY_URL": "<YOUR_DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<YOUR_DCR_STORE_URI>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets",
        "-y",
        "--auth",
        "--headless",
        "--redirect-uri",
        "--service-account-key-file",
        "--resource-store-uri",
        "--base-url",
        "--log-level"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<YOUR_GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<YOUR_GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<YOUR_AUTH_MODE>",
        "HEADLESS": "<YOUR_HEADLESS>",
        "REDIRECT_URI": "<YOUR_REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<YOUR_RESOURCE_STORE_URI>",
        "PORT": "<YOUR_PORT>",
        "BASE_URL": "<YOUR_BASE_URL>",
        "LOG_LEVEL": "<YOUR_LOG_LEVEL>",
        "DCR_MODE": "<YOUR_DCR_MODE>",
        "DCR_VERIFY_URL": "<YOUR_DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<YOUR_DCR_STORE_URI>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets",
        "-y",
        "--auth",
        "--headless",
        "--redirect-uri",
        "--service-account-key-file",
        "--resource-store-uri",
        "--base-url",
        "--log-level"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<YOUR_GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<YOUR_GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<YOUR_AUTH_MODE>",
        "HEADLESS": "<YOUR_HEADLESS>",
        "REDIRECT_URI": "<YOUR_REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<YOUR_RESOURCE_STORE_URI>",
        "PORT": "<YOUR_PORT>",
        "BASE_URL": "<YOUR_BASE_URL>",
        "LOG_LEVEL": "<YOUR_LOG_LEVEL>",
        "DCR_MODE": "<YOUR_DCR_MODE>",
        "DCR_VERIFY_URL": "<YOUR_DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<YOUR_DCR_STORE_URI>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "mcp-sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets",
        "-y",
        "--auth",
        "--headless",
        "--redirect-uri",
        "--service-account-key-file",
        "--resource-store-uri",
        "--base-url",
        "--log-level"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<YOUR_GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<YOUR_GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<YOUR_AUTH_MODE>",
        "HEADLESS": "<YOUR_HEADLESS>",
        "REDIRECT_URI": "<YOUR_REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<YOUR_RESOURCE_STORE_URI>",
        "PORT": "<YOUR_PORT>",
        "BASE_URL": "<YOUR_BASE_URL>",
        "LOG_LEVEL": "<YOUR_LOG_LEVEL>",
        "DCR_MODE": "<YOUR_DCR_MODE>",
        "DCR_VERIFY_URL": "<YOUR_DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<YOUR_DCR_STORE_URI>"
      }
    }
  }
}

Claude Code

claude mcp add mcp-sheets --env GOOGLE_CLIENT_ID=<YOUR_GOOGLE_CLIENT_ID> --env GOOGLE_CLIENT_SECRET=<YOUR_GOOGLE_CLIENT_SECRET> --env GOOGLE_SERVICE_ACCOUNT_KEY_FILE=<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY_FILE> --env AUTH_MODE=<YOUR_AUTH_MODE> --env HEADLESS=<YOUR_HEADLESS> --env REDIRECT_URI=<YOUR_REDIRECT_URI> --env RESOURCE_STORE_URI=<YOUR_RESOURCE_STORE_URI> --env PORT=<YOUR_PORT> --env BASE_URL=<YOUR_BASE_URL> --env LOG_LEVEL=<YOUR_LOG_LEVEL> --env DCR_MODE=<YOUR_DCR_MODE> --env DCR_VERIFY_URL=<YOUR_DCR_VERIFY_URL> --env DCR_STORE_URI=<YOUR_DCR_STORE_URI> -- npx -y @mcp-z/mcp-sheets -y --auth --headless --redirect-uri --service-account-key-file --resource-store-uri --base-url --log-level

Related MCP servers

Google Drive

Google Drive integration with file operations, folder navigation, search, and sharing

Gmail

Gmail integration with OAuth authentication, message search, batch operations, and Sheets export

Outlook

Outlook integration with OAuth, message search, batch operations, and calendar management

PDF Generator

MCP server for creative PDF generation with full emoji, Unicode, and offline support