google-sheets-mcp
Verified Safeby domdomegg
Overview
The server allows AI systems to perform read, write, and query operations on Google Sheets spreadsheets, facilitating data automation, analysis, and entry workflows.
Installation
GOOGLE_CLIENT_ID='<your-client-id>' GOOGLE_CLIENT_SECRET='<your-client-secret>' MCP_TRANSPORT=http npm startEnvironment Variables
- GOOGLE_CLIENT_ID
- GOOGLE_CLIENT_SECRET
- MCP_TRANSPORT
- GOOGLE_ACCESS_TOKEN
- PORT
- MCP_BASE_URL
Security Notes
The server functions as an OAuth proxy, transparently handling Google authentication and API calls. It uses Zod for robust input and output validation (via `strictSchemaWithAliases`), mitigating risks from malformed requests. A notable security feature is the proactive token validation cache (`isTokenValid`), which checks Google access token validity before processing MCP requests. This ensures that only valid tokens are used for Google API calls and allows MCP clients to properly handle expired tokens by triggering a refresh. No hardcoded secrets, `eval` usage, or obfuscation were found in the provided source code. All sensitive credentials (`GOOGLE_CLIENT_ID`, `GOOGLE_CLIENT_SECRET`, `GOOGLE_ACCESS_TOKEN`) are loaded from environment variables.
Similar Servers
excel-mcp-server
This server allows AI agents to manipulate Excel files (create, read, update, format, chart, pivot, validate) without requiring Microsoft Excel to be installed.
mcp-google-sheets
Acts as an AI assistant's gateway to Google Sheets for automation and data manipulation.
spreadsheet-read-mcp
An LLM-friendly API server for analyzing and editing spreadsheet files, enabling 'discover → profile → extract' workflows, 'what-if' scenarios, and VBA inspection without dumping entire files into LLM context.
mcp-gsheets
A Model Context Protocol (MCP) server for Google Sheets API integration, enabling reading, writing, and managing Google Sheets documents directly from MCP clients like Claude Code, Claude Desktop, or Cursor.