Google Sheets

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

stdio v1.0.7

Connection Configuration

Add this to your AI agent's MCP config file to connect.

Run in your terminal:

claude mcp add io.github.mcp-z--mcp-sheets -- npx

Transport

stdio

Authentication

None

Version

v1.0.7

Server Name

io.github.mcp-z/mcp-sheets

Last Updated

Jan 10, 2026

How to install and connect this MCP server.

Environment variables you must provide when running this server.

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