1
Add it to Claude Code
claude mcp add -e "GOOGLE_API_KEY=${GOOGLE_API_KEY}" gas-mcp-server -- npx -y @devfinprojects/gas-mcp-serverRequired:
GOOGLE_API_KEY2
Make your agent remember this setup
gas-mcp-server's config, env vars, and the gotchas you hit — recalled in every future Claude Code, Cursor, and Codex session.
npx conare@latestFree · one command · indexes the sessions already on disk. Set up in the browser instead →
What it does
- Integration with Google Sheets and Apps Script
- Over 100 specialized tools for automation and data analysis
- Self-healing architecture with circuit breaker patterns
- Enterprise-grade security and complete observability
- Production-ready JSON-RPC communication
Tools 3
read_sheetReads data from a specified Google Sheet rangewrite_sheetWrites data to a specified Google Sheet rangeexecute_scriptExecutes a Google Apps Script functionEnvironment Variables
GOOGLE_API_KEYrequiredAPI key for accessing Google Cloud servicesTry it
→Read the data from the 'Sales' sheet in my spreadsheet and summarize the monthly revenue trends.
→Update the 'Inventory' sheet by adding a new row with the latest stock levels for product ID 123.
→Execute the 'generateReport' function in my Apps Script project and save the output to a new sheet.
→Find all rows in the 'Tasks' sheet where the status is 'Pending' and assign them to the team lead.
Original README from devfinprojects/GAS_MCPSERVER_ADAVANCED
<strong>
🚀 Enterprise-Grade MCP Server for Google Sheets & Apps Script 🚀
<em>A production-ready Model Context Protocol server that provides intelligent integration between autonomous AI agents and Google Sheets/Apps Script with 100+ tools, enterprise security, self-healing capabilities, and complete observability.</em>
flowchart LR
subgraph "🤖 AI Agents"
A[MCP Client]
end
subgraph "🔷 MCP Server"
B[Tool Registry]
C[Rate Limiter]
D[Context Engine]
E[Security Layer]
end
subgraph "📊 Google APIs"
F[Sheets API]
G[Apps Script]
H[Drive API]
end
A -->|JSON-RPC| B
B --> C --> D --> E --> F
E --> G
E --> H
style A fill:#1a1a2e,stroke:#00d9ff,color:#fff
style B fill:#16213e,stroke:#a855f7,color:#fff
style C fill:#0f3460,stroke:#22c55e,color:#fff
style D fill:#1a1a2e,stroke:#f59e0b,color:#fff
style E fill:#0f0f23,stroke:#ef4444,color:#fff
style F fill:#1e3a5f,stroke:#3b82f6,color:#fff
style G fill:#1e3a5f,stroke:#3b82f6,color:#fff
style H fill:#1e3a5f,stroke:#3b82f6,color:#fff
| ⭐ Star us on GitHub | 📖 Read the Docs