Google Sheets

io.github.mcp-z/mcp-sheets·v1.0.7·Documents & Spreadsheets

Quality Score

/100

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

Website →

§01 Install

Claude Desktop (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": "<your-google_client_secret>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<google_service_account_key_file>",
        "AUTH_MODE": "<auth_mode>",
        "HEADLESS": "false",
        "REDIRECT_URI": "<redirect_uri>",
        "RESOURCE_STORE_URI": "<resource_store_uri>",
        "PORT": "<port>",
        "BASE_URL": "<base_url>",
        "LOG_LEVEL": "<log_level>",
        "DCR_MODE": "self-hosted",
        "DCR_VERIFY_URL": "<dcr_verify_url>",
        "DCR_STORE_URI": "file://~/.mcp-z/mcp-sheets/dcr.json"
      }
    }
  }
}

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<google_client_id>",
        "GOOGLE_CLIENT_SECRET": "<your-google_client_secret>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<google_service_account_key_file>",
        "AUTH_MODE": "<auth_mode>",
        "HEADLESS": "false",
        "REDIRECT_URI": "<redirect_uri>",
        "RESOURCE_STORE_URI": "<resource_store_uri>",
        "PORT": "<port>",
        "BASE_URL": "<base_url>",
        "LOG_LEVEL": "<log_level>",
        "DCR_MODE": "self-hosted",
        "DCR_VERIFY_URL": "<dcr_verify_url>",
        "DCR_STORE_URI": "file://~/.mcp-z/mcp-sheets/dcr.json"
      }
    }
  }
}

Cline (cline_mcp_settings.json)

npx -y @mcp-z/mcp-sheets

§02 Environment variables

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

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)

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)

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

§03 MCP Quality Score · methodology

freshness

completeness

installability

documentation

stability

§04 Alternatives in Documents & Spreadsheets

ac.tandem/docs-mcp

Remote MCP server for Tandem docs, install guides, SDKs, workflows, and agent setup help.

ai.adramp/google-ads

Google Ads MCP server — manage campaigns, keywords, and metrics.

AutEng MCP - Markdown Publishing & Document Share Links

ai.auteng/docs

Publish markdown documents as public share links with mermaid diagram support. Built by AutEng.ai