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
Acts as an AI assistant's gateway to Google Sheets for automation and data manipulation.
spreadsheet-mcp
Analyze and edit spreadsheet files programmatically, designed for token-efficient interaction by LLM agents, focusing on structured data access, modification, formula analysis, and optional VBA inspection.
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.
google-sheets-mcp
Manages Google Sheets data programmatically via a server-side application, leveraging the Google Sheets API for various data manipulation tasks.