README.md
Enterprise-Grade MCP Server for Google Sheets & Apps Script
🚀 Enterprise-Grade MCP Server for Google Sheets & Apps Script 🚀
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.
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
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 servicesConfiguration
claude_desktop_config.json
{"mcpServers": {"gas-mcp-server": {"command": "npx", "args": ["-y", "@devfinprojects/gas-mcp-server"], "env": {"GOOGLE_API_KEY": "your_key_here"}}}}Try 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.