Google Sheets MCP Server

Google Sheets is an MCP integration. Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting.

Packages and local setup

The published npm package is @mcp-z/mcp-sheets, version 2.4.2. Its declared MCP transport is stdio.

The package declares GOOGLE_CLIENT_ID (required): Google OAuth client ID (required for OAuth authentication modes); GOOGLE_CLIENT_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.

This package has launch arguments in its registry record. Use the maintainer’s configuration for those arguments rather than launching it with only the package name.

The published npm package is @mcp-z/mcp-sheets, version 2.4.2. Its declared MCP transport is streamable-http.

The package declares GOOGLE_CLIENT_ID (required): Google OAuth client ID (required for OAuth authentication modes); GOOGLE_CLIENT_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.

Before connecting

Check the maintainer’s instructions for account access, authentication and the supported client configuration. Once connected, inspect the tools your client receives and try a small task that matches the server’s stated purpose. The registry description does not include a verified, complete tool list.

Project and source

View the publisher’s registry entry · Project website. This profile uses version 2.4.2 from the registry. Registration identifies the publisher namespace; it does not establish that this is a first-party integration for every service it connects.

Browse related spreadsheets MCP servers for tools that cover the same kind of work.