English Français العربية

Google Sheets

Registre officiel Données et bases de données

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

Site web

Installation

Ajoutez ceci à la configuration MCP de votre client (Claude Desktop : claude_desktop_config.json ; Cursor : .cursor/mcp.json ; VS Code et les autres utilisent la même forme « mcpServers »).

NPM package @mcp-z/mcp-sheets
Claude Code 
claude mcp add google-sheets -e 'GOOGLE_CLIENT_ID=<GOOGLE_CLIENT_ID>' -e 'GOOGLE_CLIENT_SECRET=<your google_client_secret>' -e 'GOOGLE_SERVICE_ACCOUNT_KEY_FILE=<GOOGLE_SERVICE_ACCOUNT_KEY_FILE>' -e 'AUTH_MODE=<AUTH_MODE>' -e 'HEADLESS=false' -e 'REDIRECT_URI=<REDIRECT_URI>' -e 'RESOURCE_STORE_URI=<RESOURCE_STORE_URI>' -e 'PORT=<PORT>' -e 'BASE_URL=<BASE_URL>' -e 'LOG_LEVEL=<LOG_LEVEL>' -- npx -y @mcp-z/mcp-sheets@2.4.2 --auth --headless --redirect-uri --service-account-key-file --resource-store-uri --base-url --log-level
Configuration JSON (Claude Desktop, Cursor, VS Code) 
{
    "mcpServers": {
        "google-sheets": {
            "command": "npx",
            "args": [
                "-y",
                "@mcp-z/mcp-sheets@2.4.2",
                "--auth",
                "--headless",
                "--redirect-uri",
                "--service-account-key-file",
                "--resource-store-uri",
                "--base-url",
                "--log-level"
            ],
            "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>"
            }
        }
    }
}

Variables d'environnement

  • GOOGLE_CLIENT_ID obligatoire 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
NPM package @mcp-z/mcp-sheets
Claude Code 
claude mcp add google-sheets -e 'GOOGLE_CLIENT_ID=<GOOGLE_CLIENT_ID>' -e 'GOOGLE_CLIENT_SECRET=<your google_client_secret>' -e 'GOOGLE_SERVICE_ACCOUNT_KEY_FILE=<GOOGLE_SERVICE_ACCOUNT_KEY_FILE>' -e 'AUTH_MODE=<AUTH_MODE>' -e 'HEADLESS=false' -e 'REDIRECT_URI=<REDIRECT_URI>' -e 'DCR_MODE=self-hosted' -e 'DCR_VERIFY_URL=<DCR_VERIFY_URL>' -e 'DCR_STORE_URI=file://~/.mcp-z/mcp-sheets/dcr.json' -e 'RESOURCE_STORE_URI=<RESOURCE_STORE_URI>' -e 'PORT=<PORT>' -e 'BASE_URL=<BASE_URL>' -e 'LOG_LEVEL=<LOG_LEVEL>' -- npx -y @mcp-z/mcp-sheets@2.4.2 --port 9004 --auth --headless --redirect-uri --service-account-key-file --dcr-mode --dcr-verify-url --dcr-store-uri --resource-store-uri --base-url --log-level
Configuration JSON (Claude Desktop, Cursor, VS Code) 
{
    "mcpServers": {
        "google-sheets": {
            "command": "npx",
            "args": [
                "-y",
                "@mcp-z/mcp-sheets@2.4.2",
                "--port",
                "9004",
                "--auth",
                "--headless",
                "--redirect-uri",
                "--service-account-key-file",
                "--dcr-mode",
                "--dcr-verify-url",
                "--dcr-store-uri",
                "--resource-store-uri",
                "--base-url",
                "--log-level"
            ],
            "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>",
                "DCR_MODE": "self-hosted",
                "DCR_VERIFY_URL": "<DCR_VERIFY_URL>",
                "DCR_STORE_URI": "file://~/.mcp-z/mcp-sheets/dcr.json",
                "RESOURCE_STORE_URI": "<RESOURCE_STORE_URI>",
                "PORT": "<PORT>",
                "BASE_URL": "<BASE_URL>",
                "LOG_LEVEL": "<LOG_LEVEL>"
            }
        }
    }
}

Variables d'environnement

  • GOOGLE_CLIENT_ID obligatoire 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

Questions fréquentes

Qu'est-ce que Google Sheets ?

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

Comment installer Google Sheets ?

Il s'exécute sur votre machine. Dans Claude Code : claude mcp add google-sheets -e 'GOOGLE_CLIENT_ID=<GOOGLE_CLIENT_ID>' -e 'GOOGLE_CLIENT_SECRET=<your google_client_secret>' -e 'GOOGLE_SERVICE_ACCOUNT_KEY_FILE=<GOOGLE_SERVICE_ACCOUNT_KEY_FILE>' -e 'AUTH_MODE=<AUTH_MODE>' -e 'HEADLESS=false' -e 'REDIRECT_URI=<REDIRECT_URI>' -e 'RESOURCE_STORE_URI=<RESOURCE_STORE_URI>' -e 'PORT=<PORT>' -e 'BASE_URL=<BASE_URL>' -e 'LOG_LEVEL=<LOG_LEVEL>' -- npx -y @mcp-z/mcp-sheets@2.4.2 --auth --headless --redirect-uri --service-account-key-file --resource-store-uri --base-url --log-level. Pour les autres clients, collez la configuration JSON de cette page dans leurs réglages MCP.

Faut-il une clé API pour Google Sheets ?

Oui. Il attend GOOGLE_CLIENT_ID, GOOGLE_CLIENT_SECRET, à renseigner dans sa configuration.

Qui maintient Google Sheets ?

Il est publié par mcp-z. AI.tn le référence sans le maintenir ni le recommander.

Issu du registre MCP officiel. Être listé n'est pas une recommandation : vérifiez le code et les permissions d'un serveur avant de lui donner accès à vos données.