mcp-gsheets
Verified Safeby freema
Overview
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.
Installation
npx -y mcp-gsheets@latestEnvironment Variables
- GOOGLE_PROJECT_ID
- GOOGLE_APPLICATION_CREDENTIALS
- GOOGLE_SERVICE_ACCOUNT_KEY
- GOOGLE_PRIVATE_KEY
- GOOGLE_CLIENT_EMAIL
Security Notes
The server demonstrates strong security practices, including explicit reliance on environment variables for sensitive Google Cloud credentials (avoiding hardcoding), comprehensive input validation using Zod and custom helpers, and robust error handling. No 'eval' or obfuscation was found. The interaction with Google Sheets API occurs over HTTPS, and local execution uses stdio, limiting direct network exposure. The `parseJsonInput` utility uses `JSON.parse`, which is safe for its intended use case of parsing configuration objects.
Similar Servers
tmcp
A server implementation for the Model Context Protocol (MCP) to enable LLMs to access external context and tools.
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.
google-drive-mcp
Provides an MCP server for secure integration and file management with Google Drive, Docs, Sheets, and Slides for AI clients.
google-sheets-mcp
Manages Google Sheets data programmatically via a server-side application, leveraging the Google Sheets API for various data manipulation tasks.