mcp-gsheets
Verified Safeby freema
Overview
Integrate Google Sheets API for reading, writing, and managing spreadsheets directly from Model Context Protocol (MCP) clients.
Installation
npx -y mcp-gsheets@latestEnvironment Variables
- GOOGLE_PROJECT_ID
- GOOGLE_APPLICATION_CREDENTIALS
- GOOGLE_SERVICE_ACCOUNT_KEY
- GOOGLE_PRIVATE_KEY
- GOOGLE_CLIENT_EMAIL
Security Notes
The server handles sensitive Google service account credentials through environment variables, which is a standard and secure practice. It includes explicit validation for these credentials (JSON parsing, regex for private key/email). The use of `execSync` for `npm run build` and `nvm current` in the `setup-mcp-config.js` script is noted but occurs during an interactive, local setup process and not during the server's runtime operation. The server communicates via stdio, limiting direct network exposure.
Similar Servers
tmcp
Build Model Context Protocol (MCP) servers for AI agents to interact with external tools and data sources, enabling LLMs to access context and perform actions.
google-drive-mcp
Provides an MCP server for secure integration and file management with Google Drive, Docs, Sheets, and Slides for AI clients.
google-sheets-mcp
Manages and automates Google Sheets data manipulation through a server-side application, primarily for AI agent interaction.
Google-Workspace-MCP
Seamlessly integrates Google Drive, Sheets, and Docs with Claude AI and other AI agents through the Model Context Protocol (MCP) for automation.