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, Custom Search) through MCP clients and AI assistants.
gcloud-mcp
Enables AI assistants to interact with the Google Cloud environment using the gcloud CLI for natural language cloud management and workflow automation.
google-docs-mcp
Allows AI assistants to programmatically interact with Google Docs, Sheets, and Drive for document management, editing, formatting, and file organization.
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.