Google Apps Script MCP server
{
"mcpServers": {
"a1-x-tech-google-apps-script": {
"command": "npx",
"args": [
"-y",
"mcp-google-apps-script@latest"
],
"env": {
"GOOGLE_APPS_SCRIPT_CLIENT_ID": "<google_apps_script_client_id>",
"GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "<google_apps_script_client_secret>",
"GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "<google_apps_script_refresh_token>"
}
}
}
}{
"mcpServers": {
"a1-x-tech-google-apps-script": {
"command": "npx",
"args": [
"-y",
"mcp-google-apps-script@latest"
],
"env": {
"GOOGLE_APPS_SCRIPT_CLIENT_ID": "<google_apps_script_client_id>",
"GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "<google_apps_script_client_secret>",
"GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "<google_apps_script_refresh_token>"
}
}
}
}{
"mcpServers": {
"a1-x-tech-google-apps-script": {
"command": "npx",
"args": [
"-y",
"mcp-google-apps-script@latest"
],
"env": {
"GOOGLE_APPS_SCRIPT_CLIENT_ID": "<google_apps_script_client_id>",
"GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "<google_apps_script_client_secret>",
"GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "<google_apps_script_refresh_token>"
}
}
}
}{
"servers": {
"a1-x-tech-google-apps-script": {
"command": "npx",
"args": [
"-y",
"mcp-google-apps-script@latest"
],
"env": {
"GOOGLE_APPS_SCRIPT_CLIENT_ID": "${input:google_apps_script_client_id}",
"GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "${input:google_apps_script_client_secret}",
"GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "${input:google_apps_script_refresh_token}"
}
}
},
"inputs": [
{
"id": "google_apps_script_client_id",
"type": "promptString",
"description": "Google apps script client id",
"password": true
},
{
"id": "google_apps_script_client_secret",
"type": "promptString",
"description": "Google apps script client secret",
"password": true
},
{
"id": "google_apps_script_refresh_token",
"type": "promptString",
"description": "Google apps script refresh token",
"password": true
}
]
}{
"mcpServers": {
"a1-x-tech-google-apps-script": {
"command": "npx",
"args": [
"-y",
"mcp-google-apps-script@latest"
],
"env": {
"GOOGLE_APPS_SCRIPT_CLIENT_ID": "<google_apps_script_client_id>",
"GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "<google_apps_script_client_secret>",
"GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "<google_apps_script_refresh_token>"
}
}
}
}file .mcp.json (in your project root)file claude_desktop_config.jsonfile ~/.cursor/mcp.jsonfile .vscode/mcp.jsonfile ~/.codeium/windsurf/mcp_config.jsoninstall npx -y mcp-google-apps-scriptversion 0.1.0
What it does
An MCP server that lets you create, read, edit and deploy Google Apps Script projects using the Google Apps Script API. Designed for developers who want to manage script code, versions, deployments and execution history through an AI assistant.
- Create a new standalone or bound Google Apps Script project and write initial code
- Read the source code of existing script files and view recent function execution history to debug failures
- Update code in HEAD, create immutable version snapshots, and manage deployments without affecting other files
Tools this server exposes
| Tool | Does |
|---|---|
| create_project | Create a new standalone or bound Google Apps Script project |
| read_project | Get project metadata and list all files in the project |
| read_code | Read the source code of a specific file |
| write_code | Update code in HEAD with merge or replace mode |
| create_version | Snapshot the current HEAD code as an immutable version |
| read_versions | List all versions of a project |
| create_deployment | Create a deployment pointing to a specific version |
| read_deployments | List all deployments of a project |
| remove_deployment | Delete a deployment |
| run_function | Execute a function in the script project |
| read_execution_history | View the execution history and results of script functions |
| read_metrics | Get execution metrics and performance data |
| list_projects | List Google Apps Script projects |
Before you enable it
An MCP server runs with whatever access you give it. Start with a development account rather than production, and check which tools the server exposes before you let an agent call them unattended.