mcp-google-sheets

What it does

mcp-google-sheets is an MCP server that bridges Claude to Google Sheets and Drive APIs. It exposes 19 tools for creating, reading, updating, and organizing spreadsheets, covering CRUD operations, batch updates, sharing, and formatting. Claude can read and analyze data, create new spreadsheets, update cell ranges, and manage documents within Drive folders.

Who it's for

Data analysts, automation engineers, and teams building workflows where Claude needs to interact with spreadsheets—querying data for analysis, creating sheets on demand, or updating data programmatically.

Common use cases

• Read and query spreadsheet data for analysis or summarization
• Create new spreadsheets and populate them with computed or formatted data
• Update specific cell ranges or batch-update multiple cells in one operation
• List, organize, and manage spreadsheets within a Drive folder
• Share spreadsheets and manage permissions programmatically

Setup pitfalls

• Google Cloud Platform setup is required: create a project, enable the Sheets and Drive APIs, and configure credentials (Service Account recommended)
• Set environment variables: SERVICE_ACCOUNT_PATH (path to service account JSON) and DRIVE_FOLDER_ID (target Drive folder ID)
• All 19 tools load by default (~13K tokens); use --include-tools or ENABLED_TOOLS environment variable to reduce token usage
• Security alert: scanner detected 2 hardcoded secrets in the codebase; review and rotate credentials if deploying to shared environments