mcp-google-sheets
Verified Safeby xing5
Overview
Acts as an AI assistant's gateway to Google Sheets for automation and data manipulation.
Installation
uvx mcp-google-sheets@latestEnvironment Variables
- SERVICE_ACCOUNT_PATH
- DRIVE_FOLDER_ID
- CREDENTIALS_CONFIG
- CREDENTIALS_PATH
- TOKEN_PATH
- GOOGLE_APPLICATION_CREDENTIALS
- HOST
- PORT
- FASTMCP_HOST
- FASTMCP_PORT
Security Notes
The server uses standard Google API client libraries for authentication and API interaction. It relies on environment variables for sensitive configurations like credential paths, folder IDs, or base64-encoded credential content, avoiding hardcoded secrets. The default binding to '0.0.0.0' means it listens on all interfaces, requiring proper host-level firewalling. The broad Google Sheets and Drive API scopes are necessary for its functionality, and the README clearly advises users on appropriate permissions for service accounts, indicating that the primary security responsibility lies with the user's Google Cloud credential management.
Similar Servers
google_workspace_mcp
Provides comprehensive natural language control over Google Workspace services (Gmail, Calendar, Drive, Docs, Sheets, Slides, Forms, Tasks, Chat, and Custom Search) for AI assistants and developer tools.
gcloud-mcp
Enables AI assistants to interact with Google Cloud using natural language and automate cloud operations via the gcloud CLI.
google-docs-mcp
Provides a comprehensive Model Context Protocol (MCP) server that enables AI assistants to programmatically interact with Google Docs (reading, writing, formatting, structuring) and manage Google Drive files (discovery, folder management, file operations, document creation).
mcp-gsheets
Integrate Google Sheets API for reading, writing, and managing spreadsheets directly from Model Context Protocol (MCP) clients.