Google Workspace Automation Builder MCP Server

A Model Context Protocol (MCP) server that helps you automate Google Workspace tasks, generate Apps Script code, and build workflows with AI assistance.

Features

Current Tools

1. read_sheet - Read data from Google Sheets
2. write_sheet - Write data to Google Sheets
3. generate_apps_script - Generate Apps Script code from natural language descriptions
4. create_webhook_sender - Generate code to send sheet data to webhooks (Zapier, Make, etc.)

Planned Features

• Deploy Apps Script projects directly to Google
• Create and manage time-based triggers
• AI-powered workflow generation with Claude
• Template library for common patterns
• Multi-sheet operations
• Advanced error handling and logging

Installation

1. Clone or navigate to this directory
2. Install dependencies:

npm install

3. Copy the environment file and add your credentials:

cp .env.example .env

4. Build the project:

npm run build

Configuration

Setting up Google Workspace API

1. Go to Google Cloud Console
2. Create a new project or select existing one
3. Enable Google Sheets API and Google Apps Script API
4. Create OAuth 2.0 credentials
5. Add credentials to .env file

Setting up Anthropic API (Optional)

1. Go to Anthropic Console
2. Generate an API key
3. Add to .env file as ANTHROPIC_API_KEY

Using with Claude Desktop

Add this server to your Claude Desktop configuration:

MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "google-workspace": {
      "command": "node",
      "args": [
        "/Users/lindsayellis/Desktop/google-workspace-mcp/dist/index.js"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "your_client_id",
        "GOOGLE_CLIENT_SECRET": "your_client_secret",
        "GOOGLE_REFRESH_TOKEN": "your_refresh_token",
        "ANTHROPIC_API_KEY": "your_anthropic_key"
      }
    }
  }
}

After adding the configuration, restart Claude Desktop.

Usage Examples

Generate a webhook sender script

Ask Claude:

Use the create_webhook_sender tool to generate a script that sends all data from my sheet to this Zapier webhook: https://hooks.zapier.com/hooks/catch/xxxxx/xxxxx/

Generate custom Apps Script

Ask Claude:

Use generate_apps_script to create a script that:
- Runs every Monday at 9am
- Processes column A with AI
- Writes results to column B
- Sends a summary email

Read sheet data

Ask Claude:

Use read_sheet to get data from spreadsheet ID "1ABC...XYZ" range "Sheet1!A1:D10"

Development

Run in development mode with auto-reload:

npm run dev

Build for production:

npm run build

Project Structure

google-workspace-mcp/
├── src/
│   └── index.ts          # Main MCP server
├── dist/                 # Compiled JavaScript
├── .env                  # Your credentials (not committed)
├── .env.example          # Template for credentials
├── package.json
├── tsconfig.json
└── README.md

Troubleshooting

Server not appearing in Claude Desktop:

1. Check that the path in claude_desktop_config.json is correct
2. Make sure you've run npm run build
3. Restart Claude Desktop completely
4. Check logs: tail -f ~/Library/Logs/Claude/mcp*.log

Authentication errors:

1. Verify your Google Cloud credentials
2. Make sure APIs are enabled
3. Check that OAuth consent screen is configured

Next Steps

1. Set up Google OAuth authentication
2. Implement Claude API integration for script generation
3. Add Apps Script deployment functionality
4. Create template library
5. Add more advanced tools

Contributing

Feel free to add new tools and features! The MCP SDK makes it easy to extend.

License

ISC