Google Sheets

Lets an assistant work with Google Sheets through OAuth, including spreadsheet management, batch operations and formatting.

What you can do

This server connects an assistant to Google Sheets. According to its description it covers OAuth-based authentication, spreadsheet management, batch operations and formatting. Configuration options suggest it can run with OAuth client credentials or a service account key file, and can operate in different authentication and dynamic client registration modes. It runs as a local stdio process rather than a hosted endpoint.

When to use it

Use it when you want an assistant to read, create, update or format Google Sheets content, or to apply batch changes across a spreadsheet, from a desktop MCP client. It suits workflows where spreadsheet data is the working surface rather than a general database.

Requirements

Runs locally as a stdio process, typically via npx from the npm package @mcp-z/mcp-sheets, so Node.js is needed. Google authentication is configured through environment variables: GOOGLE_CLIENT_ID is required for OAuth modes, GOOGLE_CLIENT_SECRET is optional for public clients, and GOOGLE_SERVICE_ACCOUNT_KEY_FILE is required for service-account mode. Other settings include AUTH_MODE, BASE_URL, DCR_MODE, DCR_STORE_URI, DCR_VERIFY_URL, HEADLESS, LOG_LEVEL, PORT, REDIRECT_URI and RESOURCE_STORE_URI