Uses Google OAuth authentication to provide secure access to Apps Script projects and related development tools.
Provides tools to create, manage, edit, and execute Apps Script projects, including script deployment and execution monitoring.
Integrates with Google Cloud projects to manage API permissions and OAuth credentials required for script execution and deployment.
Interacts with the Google Drive API to list and manage script projects stored within the user's account.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Apps Script MCPlist my script projects and show me the files in 'Email Automation'"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Apps Script MCP
MCP server for Google Apps Script - create, manage, and execute Apps Script projects through natural language.
Features
Project Management: List, create, read, and update Apps Script projects
Code Editing: View and modify script files (JavaScript, HTML, JSON)
Execution: Run script functions with parameters
Deployments: Create, list, update, and delete deployments
Monitoring: View recent script executions and their status
Installation
Prerequisites
1. Google Cloud Project Setup
Before using the MCP server, configure your Google Cloud project:
Enable Required APIs
Enable these APIs in your Google Cloud Console:
Create OAuth Credentials
Click "Create Credentials" > "OAuth client ID"
Select "Desktop application" as the application type
Download the JSON file
Save Credentials
Save the downloaded JSON file to one of these locations:
~/.appscript-mcp/client_secret.json(recommended)./client_secret.json(current directory)~/.secrets/client_secret.json
Or set the environment variable:
Configure OAuth Consent Screen
Go to OAuth consent screen
Add yourself as a test user (required for unverified apps)
2. Configure MCP Client
Claude Desktop
Add to ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows):
Claude Code
Add to ~/.mcp.json:
Authentication
On first use, authenticate with Google:
Ask the assistant to "authenticate with Google" or use
start_google_authOpen the provided URL in your browser
Sign in and authorize the application
Copy the redirect URL (the page will not load - that's expected)
Provide the redirect URL to
complete_google_auth
Credentials are cached in ~/.appscript-mcp/token.pickle for future sessions.
Available Tools
Authentication
Tool | Description |
| Start OAuth flow, returns authorization URL |
| Complete OAuth with redirect URL |
Project Management
Tool | Description |
| List all accessible Apps Script projects |
| Get project details including all files |
| Get content of a specific file |
| Create a new project |
| Update files in a project |
Execution
Tool | Description |
| Execute a function in a script |
Deployments
Tool | Description |
| Create a new deployment |
| List all deployments |
| Update deployment configuration |
| Delete a deployment |
Monitoring
Tool | Description |
| View recent script executions |
Usage Examples
List Projects
Create a Project
Add Code to a Project
Execute a Function
Deploy
Limitations
run_script_function Requires API Executable Deployment
The run_script_function tool requires manual configuration in the Apps Script editor:
Open the script in the Apps Script editor
Go to Project Settings (gear icon)
Under "Google Cloud Platform (GCP) Project", click "Change project"
Enter your GCP project number
Click "Deploy" > "New deployment"
Select type: "API Executable"
Set "Who has access" to "Anyone" or "Anyone with Google account"
Click "Deploy"
All other tools work without this manual step.
API Quotas
Google enforces rate limits on the Apps Script API. If running many operations, you may encounter quota errors. See Apps Script Quotas for details.
Development
Run Tests
Run Server Directly
License
MIT License - see LICENSE file