mcp-google-sheets

What it does

mcp-google-sheets is an MCP server that bridges Claude (or any MCP-compatible client) to the Google Sheets and Google Drive APIs. It exposes 19 tools for spreadsheet operations—creating, reading, updating, and sharing sheets, plus batch operations and formatting—letting Claude interact with your Google account's spreadsheets directly.

Who it's for

Backend engineers and product teams automating data workflows with AI. Specifically, anyone building Claude-driven systems that need to read or write Google Sheets: customer data imports, report generation, data QA, or collaborative analysis pipelines where AI augments human spreadsheet work.

Common use cases

• Generate and populate spreadsheets from Claude analysis or external API responses
• Query live sheet data and ask Claude to analyze or summarize it
• Automate data entry, validation, or transformation in bulk
• Build AI-powered report generators that output directly to Sheets
• Set up collaborative workflows where Claude pre-fills templates or formatting

Setup pitfalls

• Google Cloud setup is non-trivial. You must create a GCP project, enable the Sheets and Drive APIs, and provision either a Service Account (recommended) or set up OAuth 2.0. The README details both paths, but neither is a two-minute setup.
• Secrets in the service account key. Our scanner found 2 secrets in the repo. The service account JSON file (SERVICE_ACCOUNT_PATH) is a credential that must be protected like a password—keep it out of version control and restrict filesystem access to the MCP process.
• Environment variables are required. At minimum, set SERVICE_ACCOUNT_PATH (path to your key file) and DRIVE_FOLDER_ID (the Google Drive folder where sheets are created). Missing or mistyped values cause authentication failures at startup.
• 19 tools consume ~13K tokens. Tool filtering via --include-tools or ENABLED_TOOLS is recommended if you only need a subset to reduce context overhead.