Google Apps Script
Enables comprehensive management of Google Apps Script projects, including project creation, file operations, and web app deployments. It features a security-first design with encrypted property management and automated security auditing for GAS envi
What is Google Apps Script?
Google Apps Script is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to enables comprehensive management of google apps script projects, including project creation, file operations, and web app deployments. it features a security-first design with encrypted property manag...
Enables comprehensive management of Google Apps Script projects, including project creation, file operations, and web app deployments. It features a security-first design with encrypted property management and automated security auditing for GAS envi
This server falls under the Cloud Services category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Enables comprehensive management of Google Apps Script proje
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx google-apps-script-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Google Apps Script
The Google Apps Script MCP Server connects AI assistants to the Google Apps Script API, enabling full lifecycle management of GAS projects directly from your AI client. It supports creating and updating script projects, managing source files, creating versioned deployments, executing functions remotely, and monitoring execution health — all with a security-first design that uses OAuth 2.0 and encrypted property management. Developers who automate Google Workspace workflows (Sheets, Drive, Docs) can use this server to let Claude write, deploy, and debug their automation scripts without leaving the chat.
Prerequisites
- Node.js 18 or higher installed
- A Google Cloud project with the Apps Script API enabled
- OAuth 2.0 credentials (client ID and secret) from Google Cloud Console
- An MCP-compatible client such as Claude Desktop or Claude Code
- Git installed to clone the repository
Clone the repository
Clone the server source from GitHub and enter the project directory.
git clone https://github.com/mohalmah/google-appscript-mcp-server.git
cd google-appscript-mcp-serverInstall dependencies
Install the required Node.js packages using npm.
npm installEnable the Apps Script API in Google Cloud
In the Google Cloud Console, navigate to APIs & Services > Library, search for 'Apps Script API', and enable it. Then create OAuth 2.0 credentials (type: Desktop app) and download the client secret JSON.
Create the .env file
Create a .env file in the project root with your OAuth credentials. The LOG_LEVEL and NODE_ENV fields are optional.
GOOGLE_APP_SCRIPT_API_CLIENT_ID=your_client_id_here
GOOGLE_APP_SCRIPT_API_CLIENT_SECRET=your_client_secret_here
LOG_LEVEL=info
NODE_ENV=productionRun the OAuth setup
Run the interactive OAuth setup script. It will open a browser window for you to authorize access to your Google account, then save the resulting tokens locally.
npm run setup-oauthConfigure your MCP client
Add the server to your MCP client configuration file. Use the absolute path to the cloned repository.
{
"mcpServers": {
"google-apps-script": {
"command": "node",
"args": ["/absolute/path/to/google-appscript-mcp-server/dist/index.js"]
}
}
}Start the server and verify
Start the server to verify it connects successfully. Once running, restart your MCP client so it picks up the new server.
npm startGoogle Apps Script Examples
Client configuration
Example claude_desktop_config.json entry for the Google Apps Script MCP Server running from the cloned repository.
{
"mcpServers": {
"google-apps-script": {
"command": "node",
"args": ["/Users/yourname/google-appscript-mcp-server/dist/index.js"]
}
}
}Prompts to try
Example prompts to use once the server is connected to your AI assistant.
- "Create a new Google Apps Script project called 'Weekly Report Automation' in my Drive folder with ID 1234567890"
- "List all deployments for script ID 1ABCdef456GHI and show me which version each one is running"
- "Execute the function sendWeeklyReport in script 1ABCdef456GHI and show me the result"
- "Show me recent execution logs for my Apps Script project and highlight any errors"
- "Deploy version 3 of script 1ABCdef456GHI as a web app with execute-as-me access"Troubleshooting Google Apps Script
OAuth setup fails with 'redirect_uri_mismatch' error
In Google Cloud Console under your OAuth credential, add 'http://localhost' and 'http://localhost:3000' to the list of authorized redirect URIs, then re-run npm run setup-oauth.
Script execution returns 403 even after OAuth completes
Scripts that use Google services (SpreadsheetApp, DriveApp, etc.) must be manually opened and authorized in the Apps Script editor at least once before they can be executed via the API. Open the script at script.google.com and run it once to trigger the authorization prompt.
Server starts but MCP client shows 'no tools available'
Ensure you used the absolute path to the compiled dist/index.js file in your config, and that you ran 'npm install' before 'npm start'. Check that the .env file exists in the same directory as the server. Restart your MCP client after making config changes.
Frequently Asked Questions about Google Apps Script
What is Google Apps Script?
Google Apps Script is a Model Context Protocol (MCP) server that enables comprehensive management of google apps script projects, including project creation, file operations, and web app deployments. it features a security-first design with encrypted property management and automated security auditing for gas envi It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Google Apps Script?
Follow the installation instructions on the Google Apps Script GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Google Apps Script?
Google Apps Script works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Google Apps Script free to use?
Yes, Google Apps Script is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
Google Apps Script Alternatives — Similar Cloud Services Servers
Looking for alternatives to Google Apps Script? Here are other popular cloud services servers you can use with Claude, Cursor, and VS Code.
Open WebUI
★ 138.2kUser-friendly AI Interface (Supports Ollama, OpenAI API, ...)
Anything LLM
★ 60.4kThe all-in-one AI productivity accelerator. On device and privacy first with no annoying setup or configuration.
LocalAI
★ 46.4kLocalAI is the open-source AI engine. Run any model - LLMs, vision, voice, image, video - on any hardware. No GPU required.
Nacos
★ 33.0kan easy-to-use dynamic service discovery, configuration and service management platform for building AI cloud native applications.
Xiaozhi ESP32
★ 26.7k本项目为xiaozhi-esp32提供后端服务，帮助您快速搭建ESP32设备控制服务器。Backend service for xiaozhi-esp32, helps you quickly build an ESP32 device control server.
Gateway
★ 11.8kA blazing fast AI Gateway with integrated guardrails. Route to 1,600+ LLMs, 50+ AI Guardrails with 1 fast & friendly API.
Browse More Cloud Services MCP Servers
Explore all cloud services servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Google Apps Script in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Google Apps Script?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.