Skip to main content
Glama

Google Apps Script MCP

English | Русский

npm CI Glama License: MIT

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.

  • 13 tools. Create standalone and bound projects, read and update code files, snapshot immutable versions, manage deployments, run functions, and inspect execution history and metrics.

  • 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.

Connect the server · Explore use cases · Open technical documentation


See it work in a minute

You: Show the code and the recent runs of my report script.

Assistant: Shows every file with its source and the execution history — which functions ran, when, and which failed. Nothing changes.

You: Add a formatDate helper to the Utils file and keep everything else as is.

Assistant: Shows the proposed source and confirms that merge mode leaves the other files untouched, then asks for confirmation before writing.

You: Confirm.

Assistant: Writes the file to HEAD. It does not create a version, redeploy or run anything unless you ask separately.

Related MCP server: Apps Script MCP

Contents

Quick start

You need Node.js 20+, a Google account and OAuth credentials from a Google Cloud project with the Google Apps Script API enabled.

  1. Prepare Google OAuth access.

  2. Add the server to your AI app.

  3. Ask the read-only question above.

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.

From the command line:

codex mcp add google-apps-script \
  --env GOOGLE_APPS_SCRIPT_CLIENT_ID=your_client_id \
  --env GOOGLE_APPS_SCRIPT_CLIENT_SECRET=your_client_secret \
  --env GOOGLE_APPS_SCRIPT_REFRESH_TOKEN=your_refresh_token \
  -- npx -y mcp-google-apps-script@latest
codex mcp list

Codex MCP documentation

claude mcp add \
  --env GOOGLE_APPS_SCRIPT_CLIENT_ID=your_client_id \
  --env GOOGLE_APPS_SCRIPT_CLIENT_SECRET=your_client_secret \
  --env GOOGLE_APPS_SCRIPT_REFRESH_TOKEN=your_refresh_token \
  --transport stdio --scope user google-apps-script \
  -- npx -y mcp-google-apps-script@latest
claude mcp list

Claude Code MCP documentation

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:

{
  "mcpServers": {
    "google-apps-script": {
      "command": "npx",
      "args": ["-y", "mcp-google-apps-script@latest"],
      "env": {
        "GOOGLE_APPS_SCRIPT_CLIENT_ID": "your_client_id",
        "GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "your_client_secret",
        "GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "your_refresh_token"
      }
    }
  }
}

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.

Claude Desktop MCP documentation

Add this to ~/.cursor/mcp.json on macOS/Linux or %USERPROFILE%\.cursor\mcp.json on Windows:

{
  "mcpServers": {
    "google-apps-script": {
      "type": "stdio",
      "command": "npx",
      "args": ["-y", "mcp-google-apps-script@latest"],
      "env": {
        "GOOGLE_APPS_SCRIPT_CLIENT_ID": "your_client_id",
        "GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "your_client_secret",
        "GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "your_refresh_token"
      }
    }
  }
}

Cursor MCP documentation

Run MCP: Open User Configuration and add:

{
  "servers": {
    "google-apps-script": {
      "type": "stdio",
      "command": "npx",
      "args": ["-y", "mcp-google-apps-script@latest"],
      "env": {
        "GOOGLE_APPS_SCRIPT_CLIENT_ID": "${input:apps_script_client_id}",
        "GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "${input:apps_script_client_secret}",
        "GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "${input:apps_script_refresh_token}"
      }
    }
  },
  "inputs": [
    { "type": "promptString", "id": "apps_script_client_id", "description": "Google OAuth client ID" },
    { "type": "promptString", "id": "apps_script_client_secret", "description": "Google OAuth client secret", "password": true },
    { "type": "promptString", "id": "apps_script_refresh_token", "description": "Google OAuth refresh token", "password": true }
  ]
}

Check it with MCP: List Servers.

VS Code MCP documentation

What you can ask it to do

Inspect a project and its runs

  • 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

  1. create_project creates a project — standalone, or bound to a Doc, Sheet, Slides or Form. Keep the returned scriptId: the API cannot list projects.

  2. 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.

  3. create_version snapshots HEAD as an immutable version — no edit, no delete, numbers only grow.

  4. 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

The Google Apps Script API requires OAuth 2.0; an API key is not enough.

  1. Create or select a Google Cloud project and enable Google Apps Script API.

  2. Turn on the per-account toggle at script.google.com/home/usersettings — without it every call fails with 403.

  3. Configure the OAuth consent screen and create a Desktop app OAuth client.

  4. 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.

  5. Request the scopes for the tools you plan to use:

    https://www.googleapis.com/auth/script.projects
    https://www.googleapis.com/auth/script.deployments
    https://www.googleapis.com/auth/script.processes
    https://www.googleapis.com/auth/script.metrics

    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

Variable

Required

Description

GOOGLE_APPS_SCRIPT_CLIENT_ID

Yes*

OAuth client ID.

GOOGLE_APPS_SCRIPT_CLIENT_SECRET

Yes*

OAuth client secret.

GOOGLE_APPS_SCRIPT_REFRESH_TOKEN

Yes*

OAuth refresh token.

GOOGLE_APPS_SCRIPT_ACCESS_TOKEN

Yes*

Short-lived alternative to the OAuth trio.

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.

Technical documentation

Support

Found a bug or need a scenario? Create an issue or write in Telegram.

Available Tools

13 tools
create_projectCreate a script projectA

Creates an Apps Script project and returns it (scriptId, title, createTime). Without parent_id the project is standalone (its scriptId doubles as its Drive file id); with parent_id — the Drive id of a Google Doc, Sheet, Slides or Form — the project is created bound to that container and can use its container-specific APIs (e.g. SpreadsheetApp.getActive()). A new project holds only a default manifest and an empty Code file: add real code with update_project_content next. IMPORTANT: the API cannot list or delete projects — keep the returned scriptId, it is the only handle. Requires the script.projects scope, the Apps Script API toggle at script.google.com/home/usersettings, and — for bound projects — access to the parent file.

ParametersJSON Schema
NameRequiredDescriptionDefault
titleYesThe project title shown in the Apps Script editor.
parent_idNoDrive file id of a Google Doc, Sheet, Slides or Form to bind the project to; omit for a standalone project.

TDQS

A4.6/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Beyond the annotations (readOnlyHint=false, openWorldHint=true), the description discloses critical behavior: the API cannot list or delete projects, so the returned scriptId is the only handle; the initial project contains only a default manifest and empty Code file; and it requires specific scopes/API toggle plus parent-file access for bound projects. This is exactly the kind of non-obvious operational context an agent needs.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is longer than minimal but every sentence earns its place: core action, mode distinction, project state, irreversible handle warning, and prerequisites. The 'IMPORTANT' warning is well placed and the progression from behavior to requirements is logical. Slightly verbose, but not wasteful; a 4 reflects the density over brevity tradeoff.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Despite lacking an output schema, the description names the return fields (scriptId, title, createTime). With full parameter schema coverage, annotations present, and this rich behavioral text covering side effects, permissions, and post-creation state, nothing an agent needs to call this tool correctly is missing. Bound-project requirements and the workaround for missing list/delete endpoints are especially valuable.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the baseline is 3. The description adds substantial meaning for parent_id, explaining that omitting it creates a standalone project whose scriptId doubles as the Drive file id, while providing it binds the project and enables container-specific APIs with a concrete example (SpreadsheetApp.getActive()). This goes beyond the schema's terse 'Drive file id...' and justifies a 4.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb and resource: 'Creates an Apps Script project and returns it (scriptId, title, createTime).' This unambiguously distinguishes create_project from sibling read/update tools like get_project and update_project_content, especially with the explicit chaining instruction 'add real code with update_project_content next.' The scope is precise and immediately usable.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives clear context for both modes: standalone versus bound via parent_id, including the exact Drive file types and the container-specific API benefit. It also directs the next step to update_project_content, which implies the creation-only role. It stops short of explicitly listing exclusion cases (e.g., 'do not use for X'), so it earns a 4 rather than a 5.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

create_versionCreate a versionA

Snapshots the project's current HEAD content as a new immutable version and returns it (versionNumber, description, createTime). Versions cannot be edited or deleted, and version numbers only grow — every call creates a NEW version, so do not re-send after an ambiguous failure without checking list_versions first. Creating a version does not change what runs anywhere: point a deployment at the new versionNumber via manage_deployments (action=create or update) to ship it.

ParametersJSON Schema
NameRequiredDescriptionDefault
script_idYesThe script project id — from the Apps Script editor URL (script.google.com/home/projects/<scriptId>/edit) or from create_project output. For standalone projects it doubles as the Drive file id.
descriptionNoHuman-readable changelog line for this version (shown in the editor's version list).

TDQS

A4.7/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations indicate non-idempotent, non-read-only, open-world behavior, and the description adds crucial context: versions are immutable, every call creates a NEW version, version numbers only grow, and creating a version does not change what runs anywhere. This goes well beyond the structured annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Three dense sentences, front-loaded with the core action and return value, followed by essential warnings and deployment guidance. Every sentence earns its place without wasted words.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With no output schema, the description appropriately enumerates the return fields. It also covers immutability, non-idempotency, retry guidance, and the follow-up deployment action, leaving no significant gap for an agent to misuse the tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the parameters script_id and description are already fully documented. The description's mention of the return fields relates to output rather than parameter meaning, so it adds no additional parameter semantics.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states a specific verb and resource: 'Snapshots the project's current HEAD content as a new immutable version and returns it.' It also clarifies that versions cannot be edited or deleted, clearly distinguishing this from read-only sibling tools like list_versions or get_version.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It explicitly tells the agent not to re-send after an ambiguous failure without checking list_versions first, and explains that shipping the version requires manage_deployments. This gives concrete when-to-use, when-not-to-use, and alternative-tool guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_projectGet project metadataA
Read-onlyIdempotent

Returns the project's metadata: title, scriptId, parentId (present only for bound projects), creator, lastModifyUser, createTime and updateTime. No code is included — use get_project_content for the files. Useful to verify a scriptId exists and check whether the project is standalone or bound.

ParametersJSON Schema
NameRequiredDescriptionDefault
script_idYesThe script project id — from the Apps Script editor URL (script.google.com/home/projects/<scriptId>/edit) or from create_project output. For standalone projects it doubles as the Drive file id.

TDQS

A4.3/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint, openWorldHint, idempotentHint, and destructiveHint=false, so the safety profile is established. The description adds useful behavioral context by stating that parentId appears only for bound projects and that no code content is included, which helps the agent set expectations beyond the schema.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Three sentences deliver the return fields, the key exclusion, the sibling alternative, and the primary use cases. Every sentence earns its place, with the most important information front-loaded.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a single-parameter read-only metadata tool, the description covers what is returned, what is not returned, when to use it, and what to use instead. Annotations handle the safety and idempotency context, and the input schema fully defines the parameter. Nothing critical is missing.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100% and the script_id property is already well-documented with format and source guidance. The tool description adds minimal parameter semantics beyond the schema, so the baseline score of 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states a precise verb ('Returns') and resource ('project's metadata'), enumerates the exact fields returned, and explicitly differentiates itself from get_project_content by noting no code is included. This makes the tool's purpose unmistakable and distinct from its siblings.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It provides clear context for when to use this tool: to verify a scriptId exists and to check whether a project is standalone or bound. It also names an alternative (get_project_content) for when file contents are needed. It doesn't enumerate every condition for all siblings, but the guidance is sufficient for the main decision points.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_project_contentGet project filesA
Read-onlyIdempotent

Returns the project's full file set: files[] with name (no extension), type (SERVER_JS = .gs code, HTML, JSON = the "appsscript" manifest), source, and per-file update info. By default HEAD (the latest saved code) is returned; version_number returns the content of that immutable version instead. Call this before update_project_content: replace mode needs the full new set including the manifest, and merge mode addresses files by these exact names.

ParametersJSON Schema
NameRequiredDescriptionDefault
script_idYesThe script project id — from the Apps Script editor URL (script.google.com/home/projects/<scriptId>/edit) or from create_project output. For standalone projects it doubles as the Drive file id.
version_numberNoRead the content of this immutable version instead of HEAD.

TDQS

A4.7/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already cover readOnly, idempotent, and non-destructive behavior, so the description's burden is lower. It adds valuable behavioral context: HEAD is the latest saved code, version_number returns immutable version content, and the file names returned are the exact identifiers used by update_project_content. This goes beyond the annotations without contradicting them.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is three sentences with no filler. It front-loads the return value, then explains version behavior, then gives the critical usage note about update_project_content. Every sentence earns its place and the length is appropriate for the tool's complexity.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a read-only file retrieval tool, the description is complete: it names the return fields, explains the version parameter, and states the relationship to the update workflow. There is no output schema, so the description carries the burden of explaining the response shape, and it does so clearly. Missing details like pagination or error cases are not significant for this tool's scope.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema already describes both parameters thoroughly (100% coverage), so the baseline is 3. The description adds extra meaning by linking version_number to immutable versions and by noting that returned file names are the exact ones needed for update_project_content. This supplements the schema's parameter descriptions with workflow-level significance.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states exactly what the tool does: returns the project's full file set with specific fields (files[], name, type, source, per-file update info). It also distinguishes HEAD vs version_number behavior, making the purpose unambiguous. The title 'Get project files' is expanded into concrete details that differentiate it from sibling tools like get_project.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly says to call this before update_project_content and explains why: replace mode needs the full new set including the manifest, and merge mode addresses files by these exact names. It also clarifies when to use version_number versus the default HEAD, giving the agent actionable routing guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_project_metricsGet execution metricsA
Read-onlyIdempotent

Returns execution metrics for the project: activeUsers, totalExecutions and failedExecutions as time series ({ value, startTime, endTime }; value is absent when zero). granularity daily covers the last 7 days, weekly aggregates by week. deployment_id narrows the numbers to one deployment. A rising failedExecutions count is the cue to call list_processes with statuses=[FAILED] for the concrete failures. Requires the script.metrics scope.

ParametersJSON Schema
NameRequiredDescriptionDefault
script_idYesThe script project id — from the Apps Script editor URL (script.google.com/home/projects/<scriptId>/edit) or from create_project output. For standalone projects it doubles as the Drive file id.
granularityYesdaily = last 7 days per day; weekly = per week.
deployment_idNoOnly count executions of this deployment.

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Beyond the readOnlyHint and idempotentHint annotations, the description adds important behavioral details: each metric is a time series, value is absent when zero, daily covers the last 7 days, and the script.metrics scope is required. It does not contradict the annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is dense but every sentence earns its place: purpose, response shape, granularity semantics, deployment behavior, failure-handling cue, and required scope. The main purpose is front-loaded, making it easy to scan.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a read-only tool with three parameters and no output schema, the description supplies the response format, edge-case behavior for zero values, parameter effects, required permissions, and a concrete follow-up action. An agent has enough information to invoke it correctly and interpret results.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema already has 100% parameter description coverage, so the baseline is 3. The description lightly reinforces the meaning of granularity and deployment_id, but does not add substantial semantic detail beyond what the schema already provides.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with 'Returns execution metrics for the project' and names the specific metrics (activeUsers, totalExecutions, failedExecutions) plus the time-series shape. This clearly distinguishes it from siblings like list_processes and get_project by focusing on aggregate execution metrics.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explains when to use each granularity, what deployment_id does, and explicitly says that a rising failedExecutions count is the cue to call list_processes with statuses=[FAILED]. This gives the agent an explicit conditional alternative, not just a vague purpose.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_versionGet a versionA
Read-onlyIdempotent

Fetches one immutable version by its number: versionNumber, description and createTime. For the code of that version call get_project_content with version_number instead — this endpoint returns metadata only.

ParametersJSON Schema
NameRequiredDescriptionDefault
script_idYesThe script project id — from the Apps Script editor URL (script.google.com/home/projects/<scriptId>/edit) or from create_project output. For standalone projects it doubles as the Drive file id.
version_numberYesThe version number from create_version or list_versions.

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already cover the read-only, idempotent, non-destructive safety profile. The description adds meaningful behavioral context by stating versions are immutable and that the endpoint returns metadata only, not code. This goes beyond the annotations without contradicting them.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two sentences with zero filler. The primary function is front-loaded, and the routing to the sibling tool is a single clear clause. Every sentence earns its place.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a simple metadata retrieval tool with complete schema documentation and strong annotations, the description adequately covers purpose, return fields, and the key alternative. It does not specify an output schema, but listing the returned fields directly compensates for that. Minor gap: no mention of error conditions, but this is not critical for such a simple read operation.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the input schema fully documents script_id and version_number. The description does not add parameter-level detail, but it does not need to because the schema carries the burden. Baseline 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb ('Fetches') and resource ('one immutable version by its number'), and explicitly lists the returned fields (versionNumber, description, createTime). It also distinguishes itself from get_project_content by clarifying this endpoint returns metadata only, so an agent can clearly tell them apart.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly names the alternative tool (get_project_content) and gives the exact condition for choosing it: when you need the code of that version instead of metadata. This is a clear when-and-when-not directive with no inference required.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_processesList execution processesA
Read-onlyIdempotent

Lists execution processes (the execution history): each entry carries projectName, functionName, processType (WEBAPP, EXECUTION_API, TIME_DRIVEN, TRIGGER, SIMPLE_TRIGGER, ADD_ON, EDITOR, MENU, BATCH_TASK), processStatus (COMPLETED, FAILED, TIMED_OUT, RUNNING, PAUSED, CANCELED, DELAYED, UNKNOWN), userAccessLevel, startTime and duration. With script_id only that script's executions are listed; without it, ALL executions started by the authorizing user across their scripts. To hunt errors, filter statuses=["FAILED","TIMED_OUT"] — but note the API returns no error messages or logs here, only the fact and time of failure: get the message by re-running via run_function, or from the Apps Script dashboard / Cloud Logging. start_time/end_time (RFC3339 UTC) bound the process start; paginate with page_token. Requires the script.processes scope.

ParametersJSON Schema
NameRequiredDescriptionDefault
typesNoOnly these launch types (EXECUTION_API = run_function calls, TIME_DRIVEN = clock triggers).
end_timeNoOnly processes started before this RFC3339 UTC timestamp.
statusesNoOnly these process states, e.g. ["FAILED","TIMED_OUT"] for error hunting.
page_sizeNoProcesses per page (1..50; API default 50).
script_idNoLimit to this script's executions; omit for all of the caller's executions.
page_tokenNonextPageToken from the previous page.
start_timeNoOnly processes started at or after this RFC3339 UTC timestamp.
deployment_idNoOnly processes of this deployment.
function_nameNoOnly processes that ran this function.

TDQS

A4.9/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Beyond the readOnlyHint and idempotentHint annotations, the description discloses important behavioral details: the API returns only failure facts and times, not error messages; with script_id it scopes to one script, without it the scope is all executions by the authorizing user; and it requires the script.processes scope. This is exactly the kind of context that helps an agent anticipate results and avoid misuse.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is dense but every sentence serves a purpose: it states the resource, enumerates return fields, explains scoping behavior, gives error-hunting guidance, covers time/pagination, and notes auth scope. Information is front-loaded and logically organized.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a listing tool with no output schema, the description is notably complete: it specifies return fields, scoping rules, filtering semantics, pagination, failure behavior, and required OAuth scope. An agent has enough context to call this tool correctly and interpret its results.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is already 100%, so the baseline is 3. The description adds meaningful semantics beyond the schema: it explains the script_id omission behavior, that start_time/end_time bound process start time, that page_token paginates, and how statuses relate to error hunting. This is a real value-add over the schema alone.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states a specific verb and resource: 'Lists execution processes (the execution history)', and enumerates the exact fields returned. This clearly distinguishes it from sibling tools like list_versions, which list versions rather than execution history.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly covers when to use this tool, such as filtering 'statuses=["FAILED","TIMED_OUT"]' to hunt errors, and explains a key limitation: no error messages or logs are returned. It names alternatives like run_function and the Apps Script dashboard/Cloud Logging for retrieving actual error messages, giving clear routing guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_versionsList versionsA
Read-onlyIdempotent

Lists the project's immutable versions (versionNumber, description, createTime), newest first. Paginate with page_token from nextPageToken. Use it to pick a versionNumber for manage_deployments or to read old code via get_project_content with version_number.

ParametersJSON Schema
NameRequiredDescriptionDefault
page_sizeNoVersions per page (1..50; API default 50).
script_idYesThe script project id — from the Apps Script editor URL (script.google.com/home/projects/<scriptId>/edit) or from create_project output. For standalone projects it doubles as the Drive file id.
page_tokenNonextPageToken from the previous page.

TDQS

A4.5/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Discloses behavior beyond the annotations: versions are immutable, returned newest first, and pagination uses page_token from nextPageToken. This adds practical detail about ordering and iteration that annotations alone do not convey.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Three sentences, each earning its place: core listing behavior, pagination, and downstream usage. Key details are front-loaded and there is no filler.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a list tool with strong annotations and full schema coverage, the description is complete. It identifies the returned fields, ordering, pagination continuation mechanism, and downstream uses, covering what an agent needs to call the tool correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so parameters are already well documented. The description reinforces page_token usage and mentions versionNumber as an output consumers use, but does not significantly add meaning beyond the schema's parameter descriptions.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb and resource: 'Lists the project's immutable versions... newest first.' It clearly identifies the action, target, and ordering, making it easy to distinguish from sibling tools like get_version and create_version.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides clear usage context by explaining when to use this tool, such as picking a versionNumber for manage_deployments or reading old code via get_project_content. However, it does not explicitly mention when not to use it or name get_version as the single-version alternative.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

manage_deploymentsManage deploymentsA
Destructive

Manages the project's deployments — the published entry points (web app, API executable, add-on) that make code callable from outside the editor. action=create deploys version_number (omit it to deploy HEAD — updates live with every save; fine for testing, risky for production) with an optional description. action=list shows all deployments including the automatic @HEAD one (paginate with page_token from nextPageToken); get needs deployment_id and returns entryPoints[] — the web app URL (webApp.url) and the API-executable config run_function depends on. action=update repoints an existing deployment at another version_number and/or changes its description (this is how you ship or roll back without changing the URL; the current config is read first and merged, so omitted fields are preserved); delete removes it permanently and breaks its URL/integrations (the @HEAD deployment cannot be deleted). WHAT a deployment exposes (web app vs API executable, who can access) comes from the appsscript manifest at the deployed version — set it via update_project_content before creating the version. Requires the script.deployments scope.

ParametersJSON Schema
NameRequiredDescriptionDefault
actionYesWhat to do with the deployments.
page_sizeNolist: deployments per page (1..50; API default 50).
script_idYesThe script project id — from the Apps Script editor URL (script.google.com/home/projects/<scriptId>/edit) or from create_project output. For standalone projects it doubles as the Drive file id.
page_tokenNolist: nextPageToken from the previous page.
descriptionNocreate/update: human-readable deployment description.
deployment_idNoget/update/delete: the deployment to target.
version_numberNocreate/update: the immutable version to deploy; omit on create to deploy HEAD.

TDQS

A4.9/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint=false and destructiveHint=true, but the description adds critical behavior beyond that: delete permanently breaks URLs/integrations, update merges config so omitted fields are preserved, HEAD deploys update live with every save, and the automatic @HEAD deployent cannot be deleted. There is no contradiction with annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is dense but every sentence earns its place: domain definition, action-by-action semantics, edge cases, prerequisite, and scope. It is front-loaded with purpose and avoids redundant restatements of the schema.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a five-action tool with no output schema, this description covers action selection, parameter semantics, destructive consequences, undeletable edge case, cross-tool prerequisite, and required OAuth scope. An agent can correctly invoke any action without needing to look up additional context.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the baseline is already strong. The description adds action-param binding: version_number can be omitted to deploy HEAD, page_token comes from nextPageToken, get requires deployment_id, update uses version_number and/or description with merge semantics. It doesn't add much for script_id or page_size, but the schema adequately covers those.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Description clearly defines deployments as published entry points (web app, API executable, add-on) and then maps every action—create, list, get, update, delete—to a specific behavior and target. It distinguishes this tool from sibling tools like create_version and run_function by scoping it to the deployment lifecycle.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It gives explicit when-to-use guidance per action: create to deploy a version or HEAD, list to see all deployments with pagination, get to fetch entryPoints, update to ship/rollback while preserving URL, delete to permanently remove. It also states when-not-to: @HEAD cannot be deleted, and HEAD is risky for production. The prerequisite via update_project_content and required scope are also stated.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

raw_requestRaw Google Apps Script API callA
Destructive

Escape hatch to call any Google Apps Script API v1 path directly, for requests the typed tools don't cover — e.g. GET "v1/projects//content?versionNumber=3", or a PUT to "v1/projects//content" with a hand-built files body. The path may carry a query string; repeated filter params can be encoded there (e.g. "v1/processes?userProcessFilter.statuses=FAILED&userProcessFilter.statuses=TIMED_OUT"). The Bearer token is added automatically and paths resolving to a foreign origin are rejected; the method defaults to GET. Remember: PUT v1/projects//content replaces the ENTIRE file set — prefer update_project_content, whose merge mode protects the other files.

ParametersJSON Schema
NameRequiredDescriptionDefault
bodyNoJSON request body (POST/PUT only).
pathYesAPI path relative to https://script.googleapis.com, e.g. "v1/projects/<scriptId>/deployments".
methodNoHTTP method (the Apps Script API uses only these four). Defaults to GET.

TDQS

A4.8/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already signal destructiveHint=true and openWorldHint=true, and the description adds valuable behavioral context: the Bearer token is added automatically, foreign-origin paths are rejected, the method defaults to GET, and PUT content replaces the entire file set. This complements the annotations without contradicting them.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is five sentences long, and every sentence earns its place: purpose, examples, query-string handling, auth/origin/method behavior, and the destructive PUT warning. It is front-loaded with the escape-hatch purpose and contains no filler.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a raw API escape hatch with no output schema, the description sufficiently covers usage, authentication, origin safety, method default, and destructive behavior. It does not mention response format or error handling, but these are reasonably implied for a direct API pass-through and the risky PUT case is explicitly flagged.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the baseline is 3. The description goes beyond the schema by explaining that paths may carry query strings, repeated filter params can be encoded there, and giving concrete path/body examples. It doesn't deeply document the body shape, but the examples compensate adequately.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb and resource: 'call any Google Apps Script API v1 path directly' and frames itself as an 'escape hatch' for 'requests the typed tools don't cover'. This clearly differentiates it from typed siblings, and concrete examples (GET content, PUT content) remove any ambiguity about what the tool does.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It explicitly states when to use the tool: when typed tools don't cover a request. It also provides a when-not by naming update_project_content as the preferred alternative for PUT content, because its merge mode protects other files. Query-string usage and the GET default are also explained.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

run_functionRun a script functionA
Destructive

Runs a named function in the script and returns { done, result } — or, when the script itself throws, { done, script_error: { type, message, stack } } with the Apps Script stack trace (this is a script bug, not a transport error; do not blindly retry, the function may have side effects). HARD PREREQUISITES the API enforces: (1) the script must have an API-executable deployment (Deploy > New deployment > API executable, or a manifest with executionApi); (2) this server's OAuth client must belong to the SAME Google Cloud project as the script (script editor > Project Settings > change the GCP project number); (3) the OAuth token must carry every scope the script itself uses (listed in the editor under Project Settings > Show "appsscript.json") — otherwise the call fails with 403 PERMISSION_DENIED or 404. parameters are positional and must be JSON-serializable (no Apps Script objects like Document or Range). dev_mode=true runs the latest saved code instead of the deployed version — owner only. Executions time out after 6 minutes on the Apps Script side.

ParametersJSON Schema
NameRequiredDescriptionDefault
dev_modeNoRun the latest saved code instead of the deployed version (script owner only; default false).
script_idYesThe script project id — from the Apps Script editor URL (script.google.com/home/projects/<scriptId>/edit) or from create_project output. For standalone projects it doubles as the Drive file id.
parametersNoPositional arguments, JSON-serializable primitives/arrays/objects only.
function_nameYesThe name of the function to run, without parentheses.

TDQS

A4.4/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

The description goes well beyond the annotations by explaining the script_error return shape, distinguishing script bugs from transport errors, warning against blind retries due to possible side effects, spelling out OAuth/GCP prerequisites, and disclosing the timeout. The destructiveHint annotation is consistent with the side-effect warning.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is long but every sentence carries important operational information. It is front-loaded with the core action and return type, though the dense paragraph structure and heavy parentheticals make it slightly harder to scan.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a remote-execution tool with no output schema, the description is exceptionally complete: it covers return shapes, error taxonomy, side effects, prerequisites, permission failures, parameter constraints, dev_mode semantics, and timeout. An agent has enough information to call this correctly and diagnose failures.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the description only needs to add marginal meaning. It mostly restates what the schema already says about parameters being positional, JSON-serializable, and dev_mode being owner-only, rather than introducing new parameter-level details.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb and resource: 'Runs a named function in the script' and clarifies the return contract ({ done, result } or { done, script_error }). This clearly differentiates run_function from the project-management and setup-related sibling tools.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives clear operational context: hard prerequisites, dev_mode owner-only behavior, positional JSON-serializable parameters, and the 6-minute timeout. It does not explicitly name alternatives or state when not to use this tool, but the context is strong enough to guide correct selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

setup_instructionsSetup instructionsA
Read-onlyIdempotent

Returns the setup checklist for this server as structured JSON: how to enable the Apps Script API (the per-account toggle at script.google.com/home/usersettings AND the Cloud-project API), which OAuth scope each tool needs (so the operator can mint a minimal-scope refresh token), the extra prerequisites of run_function (API-executable deployment, same-Cloud-project OAuth client, the script's own scopes), and the API's known limits. Works without credentials — call it first when any tool fails with 403 PERMISSION_DENIED or when setting the server up.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A4.8/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint=true, idempotentHint=true, and destructiveHint=false. The description adds valuable behavioral context beyond those flags: it is safe to call without credentials, it returns structured JSON, and it exposes known API limits. Nothing about the tool's observable behavior is hidden or contradicted.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single dense sentence that front-loads the core purpose and then enumerates the checklist contents and usage trigger. It is longer than the minimal alternative but every clause carries distinct information about setup prerequisites, scopes, and API limits. A slight structural split into two sentences would improve readability, but no content is wasted.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given zero parameters, rich annotations, and no output schema, the description is fully complete: it tells the agent what the tool returns, the specific setup facts the checklist covers, that no credentials are needed, and exactly when to invoke it. An agent can confidently decide to call this tool and understand what it will receive.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool takes zero parameters, so the parameter baseline is 4. The description goes further by explaining the content of the returned checklist and the conditions under which the tool should be invoked, which compensates for the absence of an output schema. There is nothing more parameter semantics could add with an empty input schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description immediately states the tool 'Returns the setup checklist for this server as structured JSON' — a specific verb, resource, and output format. It enumerates exactly what the checklist covers (Apps Script API enablement, OAuth scopes, run_function prerequisites, API limits), and its purpose is clearly distinct from all sibling tools, which operate on projects, versions, functions, or raw requests.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives explicit when-to-use guidance: 'call it first when any tool fails with 403 PERMISSION_DENIED or when setting the server up.' It also notes 'Works without credentials,' which tells the agent this tool is safe to invoke in unauthenticated or failure contexts. This fully routes the agent to the correct first step.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

update_project_contentUpdate project filesA
DestructiveIdempotent

Writes code files to the project's HEAD (deployed versions are untouched until you create a version + deployment). Two modes. mode="merge" (default, safer): the current content is read first, the given files are added or overwritten BY NAME, delete_files removes named files, everything else is preserved — not atomic, a concurrent edit between read and write is lost. mode="replace": the given files become the ENTIRE project; any file not in the list is deleted, and the list must include the "appsscript" manifest (type json) or the call is rejected before hitting the API. File names carry no extension ("Code", not "Code.gs"); the manifest cannot be deleted. Returns the resulting file set. This write is never retried after a 5xx or timeout — check with get_project_content before re-sending.

ParametersJSON Schema
NameRequiredDescriptionDefault
modeNomerge (default): upsert the given files, keep the rest; replace: the given files become the whole project (manifest "appsscript" required).
filesYesThe files to write (merge: upserted by name; replace: the entire new file set).
script_idYesThe script project id — from the Apps Script editor URL (script.google.com/home/projects/<scriptId>/edit) or from create_project output. For standalone projects it doubles as the Drive file id.
delete_filesNomerge only: file names to remove (no extension). The "appsscript" manifest cannot be deleted.

TDQS

A4.9/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already indicate destructive and non-read-only behavior, but the description goes much further: it explains the read-modify-write race in merge mode, the total deletion semantics of replace mode, the mandatory appsscript manifest, rejection before API call if missing, and the lack of automatic retries after 5xx/timeout. It also discloses the naming convention and the fact that the manifest cannot be deleted. No contradiction with annotations exists.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is dense but every sentence adds essential information: the main effect, the two modes, merge semantics, replace semantics, naming/manifest constraints, return value, and retry behavior. It is front-loaded with the primary purpose and avoids filler or repetition.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a mutating tool with no output schema, this description covers all critical aspects: the operation, mode behavior, preconditions, constraints, return value, and failure handling. Even though the schema documents each parameter well, the description supplies the missing behavioral context needed to call the tool safely and correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the baseline is 3. The description nevertheless adds operational meaning beyond the schema: it clarifies that files are upserted BY NAME, that delete_files only applies to merge mode, that the manifest is required in replace mode, and that names carry no extension. These are useful execution details directly tied to parameters.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb and resource: 'Writes code files to the project's HEAD.' It also clearly differentiates from deployment-related siblings by noting deployed versions remain untouched until a version and deployment are created. The two modes are named and their effects are distinguishable, so an agent knows exactly what operation this tool performs.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides concrete usage context for both modes: merge is the default and safer option, replace makes the files the entire project. It also references the appropriate sibling tool for recovery ('check with get_project_content before re-sending') and explains when deployed content changes, connecting to create_version/deployment workflow. This gives explicit when-to-use and when-not-to-use guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.

  1. 13 tool updatesv0.1.0
    • First observedcreate_project
    • First observedcreate_version
    • First observedget_project
    • First observedget_project_content
    • First observedget_project_metrics
    • First observedget_version
    • First observedlist_processes
    • First observedlist_versions
    • First observedmanage_deployments
    • First observedraw_request
    • First observedrun_function
    • First observedsetup_instructions
    • First observedupdate_project_content

TDQS

A4.6/5.0
Disambiguation5/5

Each tool maps to a distinct resource-action pair: projects, content, versions, deployments, metrics, executions, and setup. The few adjacent tools (get_version vs. get_project_content with version_number) are clearly separated by metadata-vs-code descriptions.

Naming Consistency4/5

Most names follow a clear verb_noun pattern: create_project, get_project_content, list_versions, run_function, list_processes. Minor deviations are raw_request and setup_instructions, which do not use the verb-first convention, but they do not undermine overall readability.

Tool Count5/5

Thirteen tools is well-scoped for the Apps Script lifecycle: project creation, content management, versioning, deployments, execution, and observability. Each tool earns its place, and the escape-hatch raw_request covers edge cases without bloating the surface.

Completeness5/5

The surface covers the full feasible lifecycle: create/get projects, read/update content, snapshot/list/read versions, manage deployments, run functions, and inspect execution history. Gaps like project deletion or listing are enforced by the upstream API and are mitigated by raw_request and setup_instructions.

Maintenance

ActivityMaintained
ResponsivenessSyncing

Related MCP Connectors

Related MCP Servers

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/A1-x-Tech/mcp-google-apps-script'

If you have feedback or need assistance with the MCP directory API, please join our Discord server