GOOGLE_APPS_SCRIPT_CLIENT_ID — Google OAuth2 client id (refresh-token flow).
GOOGLE_APPS_SCRIPT_CLIENT_SECRET — Google OAuth2 client secret (refresh-token flow). Treat it as a secret.
GOOGLE_APPS_SCRIPT_REFRESH_TOKEN — Google OAuth2 refresh token, exchanged for access tokens automatically. Treat it as a secret.
GOOGLE_APPS_SCRIPT_ACCESS_TOKEN — Static OAuth2 access token (~1h lifetime) — alternative to the refresh-token trio, mostly for testing.
GOOGLE_APPS_SCRIPT_OAUTH_PORT — Fixed port for the loopback listener of the in-chat login (127.0.0.1 + PKCE). Set it when the client runs over SSH port forwarding; otherwise a free port is picked per login.
GOOGLE_APPS_SCRIPT_API_BASE — API root override.
GOOGLE_APPS_SCRIPT_TIMEOUT_MS — Per-request timeout in milliseconds.
GOOGLE_APPS_SCRIPT_MAX_RETRIES — Retries on transient errors (429 always; 5xx/network for reads).
Claude Code ไม่มีลิงก์ติดตั้งสำหรับคำสั่งแบบโลคัล ให้คัดลอกคำสั่งด้านล่างแล้วรันในเทอร์มินัล
A1 Google Apps Script MCP lets an AI app write and operate Google Apps Script in plain language. Create a script project, read and edit its code, snapshot versions, manage deployments, run functions and read the execution history.
It uses the Google Apps Script API with your Google account. It distinguishes the editable HEAD code from immutable versions and makes the limits of the Apps Script API explicit instead of implying that every scripting task is possible.
19 tools. Create standalone and bound projects, read and update code files, snapshot immutable versions, manage deployments, run functions, and inspect execution history and metrics.
Connects from the conversation. Say "connect Google Apps Script": the server walks you through the OAuth client, catches Google's redirect on 127.0.0.1 with PKCE and keeps the tokens itself — no config files, no restart.
Versions are immutable. A version snapshots HEAD and can never be edited or deleted; deployments point at versions, so you ship and roll back without changing a URL.
The manifest always survives. Merge mode keeps the appsscript manifest and every file you did not mention; replace mode refuses a file set without the manifest before any network traffic.
Keep your scriptId. The API cannot list projects and cannot delete them — the scriptId returned by create_project is the only handle.
Minimal Google scopes. Each operation names its own scope (script.projects, script.deployments, script.processes, script.metrics); request only what your tasks need.
Start with a read-only question:
Show me the files in my report script and which functions failed this week.
In the app: open Settings → MCP servers, select Add server, choose STDIO, enter the command npx -y mcp-google-apps-script@latest and environment variables GOOGLE_APPS_SCRIPT_CLIENT_ID, GOOGLE_APPS_SCRIPT_CLIENT_SECRET, GOOGLE_APPS_SCRIPT_REFRESH_TOKEN, then select Save and Restart.
The current official path is Settings → Extensions. For a custom desktop extension, open Advanced settings → Extension Developer → Install Extension…, select a .mcpb file and follow the prompts.
This repository currently publishes an npm stdio package and does not contain a .mcpb bundle. For Claude Desktop builds that still support local configuration, use the following JSON stdio configuration as a fallback:
In those builds, save it to ~/Library/Application Support/Claude/claude_desktop_config.json on macOS or %APPDATA%\Claude\claude_desktop_config.json on Windows.
Show this script's files and explain what each function does.
Which functions failed this week? Show the execution history for sendDigest.
How many users, executions and failures did this script have over the last 7 days?
Write and evolve code
Create a standalone project, or a script bound to a Doc, Sheet, Slides or Form.
Add a helper function to one file without touching the others.
Snapshot the current code as a version with a description before we refactor.
Ship, run and roll back
Deploy version 4 and show its entry points — web app URL or API-executable config.
Run sendDigest and show the result; if the script throws, show the stack trace.
Repoint the deployment back to version 3 without changing its URL.
How a project changes
create_project creates a project — standalone, or bound to a Doc, Sheet, Slides or Form. Keep the returned scriptId: the API cannot list projects.
Code lives at HEAD as files addressed by name without extension. update_project_content merges by default — it upserts the files you name and keeps the rest — and only replaces the entire set when asked; the appsscript manifest can never be deleted.
create_version snapshots HEAD as an immutable version — no edit, no delete, numbers only grow.
A deployment exposes a version as a web app or API executable. Updating a deployment repoints it at another version without changing its URL; the automatic @HEAD deployment cannot be deleted.
The API cannot delete a project either — that means deleting its Drive file, which this server does not cover. run_function requires an API-executable deployment, an OAuth client from the same Cloud project as the script and the script's own scopes on the token; Apps Script stops any execution after 6 minutes. The execution history shows status and timing but no error messages — those live in Cloud Logging or come from re-running the function.
What can change
Operation
What happens
Confirmation boundary
Read a project, its code, versions, runs or metrics
Reads data
No change
Create a project
Adds a standalone or bound script project
Changes Google Apps Script
Update project files
Overwrites code at HEAD; replace mode swaps the entire file set
Changes a project
Create a version
Adds an immutable snapshot that can never be removed
Changes a project
Create or update a deployment
Changes what a live URL or API endpoint serves
Changes a project's live behavior
Delete a deployment
Permanently breaks the deployment URL
Destructive
Run a function
Executes real code with real side effects
Destructive
Raw API request
Can call API methods without a dedicated tool
Potentially destructive
The AI client controls confirmation prompts. The server marks reads, writes and destructive tools so the client can distinguish an inspection from a live change.
Getting access
Google Apps Script requires OAuth 2.0; an API key is not enough. There are two ways in, and the first one needs no configuration files.
Connect from the chat (recommended)
Say "connect Google Apps Script" and the assistant runs the flow with you:
setup_instructions prints the checklist: create or select a Google Cloud project, enable Apps Script API, configure the consent screen and create a Desktop app OAuth client.
Download that client's JSON ("Download JSON") and give the assistant its path — set_client stores it owner-only. The secret never goes through the conversation.
start_login returns a Google consent link. Open it on this machine and approve; the code comes back to a one-shot listener on 127.0.0.1 (PKCE), never through the chat.
finish_login exchanges the code and saves the tokens to ~/.config/mcp-google-apps-script/credentials.json (mode 0600) and verifies them with a real Apps Script API call — so an API that is still switched off is caught right there.
The tokens are re-read on every call, so the connection works immediately — no restart of the AI app. auth_status shows what is connected, logout revokes and deletes it.
Environment variables (CI, unattended installs)
Create or select a Google Cloud project and enable Google Apps Script API.
Configure the OAuth consent screen and create a Desktop app OAuth client.
Authorize the Google account that owns the scripts. The OAuth 2.0 Playground can obtain the refresh token when Use your own OAuth credentials is enabled.
For inspection-only use, replace the first two with the read-only variants script.projects.readonly and script.deployments.readonly; list_processes and get_project_metrics still need script.processes and script.metrics, which have no narrower form. run_function needs none of these scopes — instead the token must carry every scope the target script itself uses, and the OAuth client must belong to the same Cloud project as the script.
Testing-mode OAuth refresh tokens can expire after seven days. Publish the OAuth app, or use an Internal app in a Workspace domain, when you need long-lived access. Treat the client secret and refresh token as passwords.
The setup_instructions tool returns this same checklist and works even before credentials are configured.
Configuration
Every variable is optional — with none of them the server connects from the chat.
Variable
Required
Description
GOOGLE_APPS_SCRIPT_CLIENT_ID
No*
OAuth client ID.
GOOGLE_APPS_SCRIPT_CLIENT_SECRET
No*
OAuth client secret.
GOOGLE_APPS_SCRIPT_REFRESH_TOKEN
No*
OAuth refresh token.
GOOGLE_APPS_SCRIPT_ACCESS_TOKEN
No*
Short-lived alternative to the OAuth trio.
GOOGLE_APPS_SCRIPT_OAUTH_PORT
No
Fixed loopback port for the in-chat login; useful over SSH port forwarding.
GOOGLE_APPS_SCRIPT_API_BASE
No
Google Apps Script API base URL override.
GOOGLE_APPS_SCRIPT_TIMEOUT_MS
No
Per-request timeout; default 60000 ms.
GOOGLE_APPS_SCRIPT_MAX_RETRIES
No
Temporary-error retries; default 3.
* Provide either the OAuth trio or an access token.
Data, limits and background work
Requests go to Google Apps Script. The local server refreshes Google OAuth tokens and calls the Apps Script API. Its anonymous telemetry contains an installation ID, package version, AI client and platform versions, and tool names — never OAuth tokens, script sources, tool arguments or prompts. Set ASKADS_TELEMETRY=0 to opt out.
Writes are never replayed blindly. On 429, the server uses backoff; reads also retry after network and 5xx errors, while writes are not replayed after an uncertain failure — a duplicated create_version piles up immutable versions, and a duplicated run_function executes side effects twice. After an ambiguous failure, check list_versions or the execution history instead of re-sending.
There is no background polling. The server runs only when called, and a function executes only when you ask for it. Scripts keep their own Apps Script triggers on Google's side; if your AI app supports scheduled tasks, it can also check the execution history periodically.
