MCP_GoogleSheets
Verified Safeby santiagopereda
Overview
This server provides a secure bridge for AI assistants to interact with Google Sheets, enabling comprehensive spreadsheet management, data access, modification, and table-level automation workflows.
Installation
docker run --rm -i -v /path/to/your/service-account.json:/app/credentials.json:ro -e GOOGLE_APPLICATION_CREDENTIALS=/app/credentials.json googlesheets-mcp-server:latest python googlesheets_server.pyEnvironment Variables
- GOOGLE_APPLICATION_CREDENTIALS
- GOOGLE_CREDENTIALS_JSON
- SERVICE_ACCOUNT_EMAIL
- OAUTH_REDIRECT_URI
- DRIVE_FOLDER_ID
Security Notes
The server implements strong security practices including retrieving credentials from environment variables or mounted files (not hardcoded), running as a non-root user (`mcpuser`), and using read-only volume mounts (`:ro`) for credentials. It leverages standard Google API client libraries. There are no obvious signs of 'eval' or malicious patterns. A minor concern is that some table operations (e.g., `update_table_rows`, `delete_table_rows`) read the entire sheet into memory, process it, and then rewrite, which could introduce potential race conditions or performance issues with extremely large, concurrently updated sheets, although this is a common approach when more granular API methods are not available.
Similar Servers
mcp-google-sheets
Provides an AI assistant with tools to interact with Google Sheets and Google Drive for data manipulation and automation.
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
This server integrates Google Sheets functionality with Model Context Protocol clients, enabling AI models to programmatically read, write, and manage spreadsheet data and properties.
google-drive-mcp
Provides secure integration with Google Drive, Docs, Sheets, and Slides for Model Context Protocol (MCP) clients, enabling file management and content manipulation through a standardized interface.