MCP Google Apps Script Server

A server for seamless integration with Google Apps Script, enabling automation and extension of Google Workspace applications.

Let AI assistants build and manage Google Apps Script projects for you

🚀 Quick Start•💡 Use Cases•🛠️ Features•📚 Docs

// Tell your AI: "Create a function that fetches stock prices and updates my spreadsheet" // AI will create, deploy, and test the entire solution // Tell your AI: "Build an expense tracker that categorizes Gmail receipts" // AI handles OAuth, Gmail API, and spreadsheet integration // Tell your AI: "Make a custom menu in Sheets for data analysis tools" // AI creates the UI, functions, and deploys everything

curl -fsSL https://raw.githubusercontent.com/whichguy/mcp_gas/main/install.sh | bash -s -- --auto

git clone https://github.com/whichguy/mcp_gas.git && cd mcp_gas && ./install.sh

curl -fsSL https://raw.githubusercontent.com/whichguy/mcp_gas/main/install.sh | bash

./install.sh --dry-run # Preview changes without making them ./install.sh --interactive # Choose which IDEs to configure ./install.sh --auto # Non-interactive mode (for CI/CD) ./install.sh --force # Update existing configurations ./install.sh --help # Show detailed usage

# 1. Clone repository git clone https://github.com/whichguy/mcp_gas.git cd mcp_gas # 2. Install dependencies npm install # 3. Build the project npm run build # 4. Configure your IDE manually # Point to: /absolute/path/to/mcp_gas/dist/src/index.js

# Remove MCP GAS from all IDEs ./uninstall.sh # With cleanup options: ./uninstall.sh --cleanup-build # Also remove dist/ and node_modules/ ./uninstall.sh --cleanup-backups # Remove all backup files ./uninstall.sh --dry-run # Preview what would be removed

- VisitGoogle Cloud Console
- Create or select a project
- Search for "Google Apps Script API" and enable it

{ "mcpServers": { "gas": { "command": "node", "args": ["/absolute/path/to/mcp_gas/dist/src/index.js"], "env": {"NODE_ENV": "production"} } } }

{ "mcpServers": { "gas": { "command": "node", "args": ["/absolute/path/to/mcp_gas/dist/src/index.js"], "env": {"NODE_ENV": "production"} } } }

{ "context_servers": { "gas": { "command": { "path": "node", "args": ["/absolute/path/to/mcp_gas/dist/src/index.js"] } } } }

[mcp_servers.gas] command = "node" args = ["/absolute/path/to/mcp_gas/dist/src/index.js"] [[mcp_servers.gas.env]] NODE_ENV = "production"

- ls- List files
- cat- Read files
- write- Write files
- rm- Delete files
- mv- Move files
- cp- Copy files
- mkdir- Create folders

- grep- Search text
- find- Find files
- ripgrep- Fast search
- sed- Find & replace

- rsync- Stateless sync (pull/push with dryrun)
- git_feature- Feature branch management
- config- Manage sync folder

- deploy- Unified deployment management (promote/rollback/status/reset)

- project_create- New project
- project_set- Set current
- project_list- List all

- Smart tools(cat,write): Automatically handle CommonJS module wrapping
- Raw tools(raw_cat,raw_write): Preserve exact file content
- Choose based on whether you want automatic module management or full control

- Automation Projects: Gmail, Calendar, Drive, Sheets automation
- Custom Functions: Complex spreadsheet formulas and data processing
- API Integrations: Connecting Google Workspace to external services
- Rapid Prototyping: Quick proof-of-concepts and MVPs
- Learning GAS: Let AI teach by example

- Large Applications: Consider App Engine or Cloud Functions for complex apps
- Real-time Systems: GAS has execution time limits (6 minutes)
- Heavy Computing: Limited CPU/memory compared to dedicated servers
- Sensitive Data: Evaluate security requirements carefully

// Set up .git/config breadcrumb file first mcp__gas__write({ scriptId: "...", path: ".git/config", content: JSON.stringify({ repository: "https://github.com/...", localPath: "~/my-project" }) }) // Stateless sync: preview then apply mcp__gas__rsync({ operation: "pull", scriptId: "...", dryrun: true }) mcp__gas__rsync({ operation: "pull", scriptId: "..." }) // Standard git workflow works in sync folder cd ~/gas-repos/project-xxx git add . && git commit -m "Update" && git push

// Write modular code with CommonJS const utils = require('./utils'); const api = require('./api/client'); function processData() { const data = api.fetchData(); return utils.transform(data); } module.exports = { processData };

// Tell your AI assistant: "Create a Google Apps Script project that calculates Fibonacci numbers" // The AI will execute: // 1. Authenticate await mcp__gas__auth({ mode: "start" }); // 2. Create project const project = await mcp__gas__project_create({ title: "Fibonacci Calculator" }); // 3. Add code await mcp__gas__write({ scriptId: project.scriptId, path: "fibonacci", content:  function fibonacci(n) { if (n <= 1) return n; return fibonacci(n - 1) + fibonacci(n - 2); } function test() { Logger.log(fibonacci(10)); // 55 } module.exports = { fibonacci };  }); // 4. Execute const result = await mcp__gas__run({ scriptId: project.scriptId, js_statement: "require('fibonacci').fibonacci(10)" }); // Returns: 55

// Read file contents (auto-unwraps CommonJS) mcp__gas__cat({ scriptId: "...", path: "utils/helper" }) // List files matching pattern mcp__gas__ls({ scriptId: "...", path: "utils/" }) // ⚡ RECOMMENDED: High-performance multi-pattern search with ripgrep mcp__gas__ripgrep({ scriptId: "...", pattern: "function.test", ignoreCase: true, context: 2 }) // Simple grep (use ripgrep for advanced searches) mcp__gas__grep({ scriptId: "...", pattern: "function.test", outputMode: "content" }) // Find files by name pattern mcp__gas__find({ scriptId: "...", name: ".test" }) // Find/replace with regex mcp__gas__sed({ scriptId: "...", pattern: "console\\.log", replacement: "Logger.log" }) // ⚡ Advanced ripgrep features (STRONGLY RECOMMENDED over grep) mcp__gas__ripgrep({ scriptId: "...", pattern: "TODO|FIXME|HACK", // Multi-pattern OR search ignoreCase: true, // Case-insensitive sort: "path", // Alphabetical sorting trim: true, // Clean whitespace context: 2, // Show 2 lines of context showStats: true // Performance statistics })

// Execute mathematical expressions mcp__gas__run({ scriptId: "...", js_statement: "Math.PI  2" }) // Call Google Apps Script services mcp__gas__run({ scriptId: "...", js_statement: "DriveApp.getRootFolder().getName()" }) // Execute project functions with CommonJS mcp__gas__run({ scriptId: "...", js_statement: "require('Calculator').fibonacci(10)" }) // Complex data operations mcp__gas__run({ scriptId: "...", js_statement:  const data = require('API').fetchData(); const sheet = SpreadsheetApp.create('Report'); sheet.getActiveSheet().getRange(1,1,data.length,3).setValues(data); return sheet.getId();  })

// Write module with automatic CommonJS wrapping mcp__gas__write({ scriptId: "...", path: "Calculator", content:  function add(a, b) { return a + b; } function multiply(a, b) { return a  b; } module.exports = { add, multiply };  }) // Use require() in other modules - automatic dependency resolution mcp__gas__write({ scriptId: "...", path: "Main", content:  const calc = require('Calculator'); const result = calc.add(5, calc.multiply(2, 3)); Logger.log(result); // Logs: 11  }) // Read shows clean user code (CommonJS wrapper removed) mcp__gas__cat({ scriptId: "...", path: "Calculator" }) // Returns user code without _main() wrapper

// Create .git/config breadcrumb file mcp__gas__write({ scriptId: "...", path: ".git/config", content: JSON.stringify({ repository: "https://github.com/owner/repo.git", localPath: "~/my-projects/gas-app" }) }) // Stateless sync: preview then apply mcp__gas__rsync({ operation: "pull", scriptId: "...", dryrun: true }) mcp__gas__rsync({ operation: "pull", scriptId: "..." }) // Manage sync folder configuration mcp__gas__config({ operation: "set", setting: "sync_folder", scriptId: "...", value: "~/my-projects/gas-app" })

# Enable debug logging DEBUG=mcp:* npm start # Test installation without changes ./install.sh --dry-run # Check configuration cat ~/.claude/claude_desktop_config.json | jq '.mcpServers.gas'

mcp_gas/ ├── src/ # TypeScript source code │ ├── tools/ # ~50 MCP tools │ ├── auth/ # OAuth authentication │ ├── api/ # Google Apps Script API client │ └── server/ # MCP server implementation ├── dist/ # Compiled JavaScript (after build) ├── test/ # Test suites ├── docs/ # Documentation ├── install.sh # Automated installer ├── uninstall.sh # Clean uninstaller ├── gas-config.json # Project configuration └── oauth-config.json # OAuth credentials (create this)

# Clone and install git clone https://github.com/whichguy/mcp_gas.git cd mcp_gas npm install # Development mode with watch npm run dev # Build for production npm run build

npm test # Run all tests npm run test:unit # Unit tests only npm run test:integration # Integration tests (requires auth) npm run test:system # System-level tests npm run test:security # Security validation

The MCP GAS Server uses a layered architecture:
- MCP Protocol Layer: Handles communication with AI assistants
- Tool Layer: ~50 specialized tools for GAS operations
- Authentication Layer: OAuth 2.0 PKCE flow with token management
- API Client Layer: Google Apps Script API v1 client with rate limiting
- File System Layer: Local caching and synchronization

- docs/REFERENCE.md- Complete reference for all 63 tools with capabilities, limitations, and compatibility matrix

- docs/CROSS_TOOL_REFERENCES.md- Strategy for cross-tool references and workflow chaining
- docs/SCHEMA_ENHANCEMENTS_SUMMARY.md- Progress tracking for schema improvements
- Architecture Guide- System design and internals
- Git Integration- Version control workflows
- API Documentation- TypeScript API reference
- Examples- Sample projects and use cases

We welcome contributions! SeeCONTRIBUTING.mdfor guidelines.

- 🐛Report bugs
- 💡Request features
- 📖Improve documentation
- 🔧Submit pull requests

- Model Context Protocolby Anthropic
- Google Apps Script API
- TypeScript, Node.js, and the amazing open-source community

Build and deploy full-stack Next.js apps with 98 tools for React, AWS, and MongoDB