google-sheets-mcp
Verified Safeby D-unn
Overview
Manages and automates Google Sheets data manipulation through a server-side application, primarily for AI agent interaction.
Installation
npm startEnvironment Variables
- GSHEETS_CREDENTIALS_PATH
- GSHEETS_OAUTH_PATH
Security Notes
The server uses Google OAuth 2.0 for authentication, which is standard. It stores the generated OAuth credentials (access and refresh tokens) in a local file (`.gsheets-server-credentials.json`) on disk. While common for local setups, this file contains sensitive tokens that could be compromised if the host system's file system is breached. The Google Cloud project client secrets (`gcp-oauth.keys.json`) are expected to be manually provided by the user and not committed to the repository, which is a good practice. No 'eval' or obvious obfuscation detected. Network risks are inherent to API interactions with Google services.
Similar Servers
mcp-google-sheets
Acts as an AI assistant's gateway to Google Sheets for automation and data manipulation.
mcp-gsheets
Integrate Google Sheets API for reading, writing, and managing spreadsheets directly from Model Context Protocol (MCP) clients.
gitlab-mcp-server
This server provides tools to interact with a self-hosted GitLab instance to fetch and manage project, issue, and wiki data.
google-sheets-mcp
This server enables AI systems to interact with Google Sheets, allowing them to read, write, and query spreadsheet data for tasks like data analysis, expense tracking, and cross-tool status synchronization.