Google Apps Script MCP Server
About
[](https://mseep.ai/app/mohalmah-google-appscript-mcp-server) # Google Apps Script MCP Server [
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Google Apps Script MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
⚙️ Prerequisites
Before starting, ensure you have:
- Node.js (v18+ required, v20+ recommended) - Download here
- npm (included with Node.js)
- Google Account with access to Google Cloud Console
- Git (for cloning the repository)
2. Install Dependencies
npm install
4. Run OAuth Setup
npm run setup-oauth
📖 Detailed Setup Instructions
> If you haven't cloned the repository and installed dependencies yet, follow the Quick Start Guide first.
Step 2: Configure Environment Variables
Category
Tools
This MCP server provides 16 comprehensive tools for Google Apps Script management:
| Category | Tools | Purpose |
|----------|-------|---------|
| Project Management | create, get, get-content, update-content | Manage script projects and source code |
| Version Control | versions-create, versions-get, versions-list | Handle script versioning |
| Deployment | deployments-create, deployments-get, deployments-list, deployments-update, deployments-delete | Manage script deployments |
| Execution | scripts-run | Execute script functions |
| Monitoring | processes-list, get-metrics | Monitor execution and performance |
npm run list-tools
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"google apps script mcp server": {
"google-apps-script": {
"command": "<absolute_path_to_node_executable>",
"args": [
"<absolute_path_to_mcpServer.js>"
],
"env": {
"GOOGLE_APP_SCRIPT_API_CLIENT_ID": "your_client_id_here",
"GOOGLE_APP_SCRIPT_API_CLIENT_SECRET": "your_client_secret_here"
}
}
}
}
}McpServers
{
"google-apps-script": {
"command": "<absolute_path_to_node_executable>",
"args": [
"<absolute_path_to_mcpServer.js>"
],
"env": {
"GOOGLE_APP_SCRIPT_API_CLIENT_ID": "your_client_id_here",
"GOOGLE_APP_SCRIPT_API_CLIENT_SECRET": "your_client_secret_here"
}
}
}Author: mohalmah
License: MIT License
Repository: google-apps-script-mcp-server
Welcome to the Google Apps Script MCP (Model Context Protocol) Server! 🚀
This MCP server provides comprehensive integration with the Google Apps Script API, allowing you to manage script projects, deployments, versions, and executions through any MCP-compatible client like Claude Desktop, VS Code with Cline, or Postman.
📋 Table of Contents
- Overview
- Features
- Prerequisites
- Quick Start Guide
- Detailed Setup Instructions
- Available Tools
- Script Authorization
- MCP Client Configuration
- Troubleshooting
- Advanced Usage
🌟 Overview
This MCP server enables seamless interaction with Google Apps Script through:
- ✅ OAuth 2.0 Authentication - Secure token management with automatic refresh
- ✅ 16 Comprehensive Tools - Complete Google Apps Script API coverage
- ✅ MCP Protocol Compliance - Works with Claude Desktop, VS Code, and other MCP clients
- ✅ Secure Token Storage - OS-specific secure storage for refresh tokens
- ✅ Auto Token Refresh - Handles token expiration automatically
- ✅ Detailed Logging - Comprehensive error handling and debugging
🎥 Demo Video
Watch the Google Apps Script MCP Server in action - creating projects, managing deployments, and executing scripts through VS Code AI Agent.
🚀 Features
Core Capabilities
- Project Management: Create, retrieve, and update Google Apps Script projects - Deployment Management: Create, list, update, and delete script deployments - Version Control: Create and manage script versions - Content Management: Get and update script content and files - Process Monitoring: List and monitor script execution processes - Metrics Access: Retrieve script execution metrics and analytics - Script Execution: Run Google Apps Script functions remotelySecurity Features
- OAuth 2.0 Flow: Full Google OAuth implementation - Secure Token Storage: Refresh tokens stored in OS keychain/credential manager - Automatic Token Refresh: No manual token management required - Environment Variable Support: Secure credential configuration⚙️ Prerequisites
Before starting, ensure you have:
- Node.js (v18+ required, v20+ recommended) - Download here
- npm (included with Node.js)
- Google Account with access to Google Cloud Console
- Git (for cloning the repository)
🚀 Quick Start Guide
1. Clone the Repository
git clone https://github.com/mohalmah/google-apps-script-mcp-server.git
cd google-apps-script-mcp-server
2. Install Dependencies
npm install
3. Set Up Google Cloud OAuth
Follow the detailed OAuth setup guide below.4. Run OAuth Setup
npm run setup-oauth
5. Test the Server
npm start
1.1 MCP config for Node.js
Edit yourclaude_desktop_config.json file:
- Windows: %APPDATA%\Claude\claude_desktop_config.json
- macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
- Linux: ~/.config/Claude/claude_desktop_config.json
{
"mcpServers": {
"google-apps-script": {
"command": "node",
"args": ["/path/to/google-appscript-mcp-server/mcpServer.js"],
"env": {
"GOOGLE_APP_SCRIPT_API_CLIENT_ID": "your_client_id",
"GOOGLE_APP_SCRIPT_API_CLIENT_SECRET": "your_client_secret"
}
}
}
}
1.2 MCP config for Docker
Build the Docker image:docker build -t google-appscript-mcp:latest .
Edit your claude_desktop_config.json file:
{
"mcpServers": {
"google-apps-script": {
"command": "docker",
"args": [
"run",
"--rm",
"-i",
"-e", "GOOGLE_APP_SCRIPT_API_CLIENT_ID=your_client_id",
"-e", "GOOGLE_APP_SCRIPT_API_CLIENT_SECRET=your_client_secret",
"-v", "google-appscript-tokens:/home/app/.config/google-apps-script-mcp",
"google-appscript-mcp:latest"
]
}
}
}
📖 Detailed Setup Instructions
> If you haven't cloned the repository and installed dependencies yet, follow the Quick Start Guide first.
Step 1: Google Cloud Console Setup
1.1 Create or Select a Google Cloud Project
1. Go to Google Cloud Console
2. Click the project dropdown at the top
3. Click "New Project" or select an existing project
4. If creating new:
- Enter a project name (e.g., "Google Apps Script MCP")
- Note your Project ID (you'll need this)
- Click "Create"
1.2 Enable Required APIs
1. In the Google Cloud Console, navigate to APIs & Services → Library
2. Search for and enable the following APIs:
- Google Apps Script API (required)
- Google Drive API (recommended for file access)
- Google Cloud Resource Manager API (for project operations)
For Google Apps Script API:
1. Search "Google Apps Script API"
2. Click on the result
3. Click "Enable"
4. Wait for the API to be enabled (may take a few minutes)
1.3 Configure OAuth Consent Screen
1. Go to APIs & Services → OAuth consent screen
2. Choose External (unless you're in a Google Workspace organization)
3. Fill in the required information:
- App name: "Google Apps Script MCP Server"
- User support email: Your email address
- App logo: (optional)
- App domain: Leave blank for development
- Developer contact information: Your email address
4. Click "Save and Continue"
Configure Scopes (Optional but Recommended):
1. Click "Add or Remove Scopes"
2. Add these scopes:
- https://www.googleapis.com/auth/script.projects
- https://www.googleapis.com/auth/script.projects.readonly
- https://www.googleapis.com/auth/script.deployments
- https://www.googleapis.com/auth/script.deployments.readonly
- https://www.googleapis.com/auth/script.metrics
- https://www.googleapis.com/auth/script.processes
3. Click "Update"
Add Test Users (for External apps):
1. Click "Add Users"
2. Add your Gmail address as a test user
3. Click "Save and Continue"
1.4 Create OAuth 2.0 Credentials
1. Go to APIs & Services → Credentials
2. Click "+ CREATE CREDENTIALS" → "OAuth 2.0 Client IDs"
3. For Application Type, select "Web application"
4. Configure the client:
- Name: "Google Apps Script MCP Client"
- Authorized JavaScript origins: (leave empty for now)
- Authorized redirect URIs: Add exactly this URL:
http://localhost:3001/oauth/callback
5. Click "Create"
6. IMPORTANT: Copy your Client ID and Client Secret immediately
- Client ID looks like:
1234567890-abcdefghijklmnop.apps.googleusercontent.com- Client Secret looks like:
GOCSPX-abcdefghijklmnopqrstuvwxyz
Step 2: Configure Environment Variables
2.1 Create .env File
Create a .env file in your project root:
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
