google-sheets-mcp
Verified Safeby D-unn
Overview
Manages Google Sheets data programmatically via a server-side application, leveraging the Google Sheets API for various data manipulation tasks.
Installation
npx google-sheets-mcpEnvironment Variables
- GSHEETS_CREDENTIALS_PATH
- GSHEETS_OAUTH_PATH
Security Notes
The server uses Google OAuth2 for authentication via `@google-cloud/local-auth` and stores credentials locally in `.gsheets-server-credentials.json`. The user is responsible for securing this file and the `gcp-oauth.keys.json` file which contains their Google Cloud project client credentials. The code includes checks for the existence of `gcp-oauth.keys.json` and handles authentication errors. No 'eval' or other dynamic code execution is present, and no obvious obfuscation or malicious patterns were found. Network interactions are with the Google Sheets API, a trusted service.
Similar Servers
excel-mcp-server
This server allows AI agents to manipulate Excel files (create, read, update, format, chart, pivot, validate) without requiring Microsoft Excel to be installed.
mcp-google-sheets
Acts as an AI assistant's gateway to Google Sheets for automation and data manipulation.
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.
runautomation-mcpserver
A comprehensive Playwright-based Model Context Protocol (MCP) server designed for AI assistants to perform web testing, browser automation, and quality assurance tasks through natural language commands.