io.github.mcp-z/mcp-sheets

Official

Google Sheets

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

Manage Google Sheets with spreadsheet operations and batch formatting.

Install

Configuration

Environment variables

GOOGLE_CLIENT_IDrequired

Google OAuth client ID (required for OAuth authentication modes)

GOOGLE_CLIENT_SECRETsecret

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_MODEdefault loopback-oauth

Authentication mode

HEADLESSdefault false

Disable browser auto-open, return auth URL instead (true/false)

REDIRECT_URI

OAuth redirect URI (optional, default: ephemeral loopback)

RESOURCE_STORE_URIdefault file://~/.mcp-z/mcp-sheets/files

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_LEVELdefault info

Logging level

DCR_MODEdefault self-hosted

Dynamic Client Registration mode

DCR_VERIFY_URL

External verification endpoint URL (required for external DCR mode)

DCR_STORE_URIdefault file://~/.mcp-z/mcp-sheets/dcr.json

DCR client storage URI (for self-hosted DCR mode)

Arguments

-y

--auth

--headless

--redirect-uri

--service-account-key-file

--resource-store-uri

--base-url

--log-level

--portdefault 9004

--dcr-mode

--dcr-verify-url

--dcr-store-uri

claude_desktop_config.json

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets@1.0.7",
        "--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": "loopback-oauth",
        "HEADLESS": "false",
        "REDIRECT_URI": "<YOUR_REDIRECT_URI>",
        "RESOURCE_STORE_URI": "file://~/.mcp-z/mcp-sheets/files",
        "PORT": "<YOUR_PORT>",
        "BASE_URL": "<YOUR_BASE_URL>",
        "LOG_LEVEL": "info"
      }
    }
  }
}