Skip to main content

apps-script-mcp

An MCP server that lets Claude write and run Google Apps Script in your Google account, with no Google Cloud Console setup.

It works through a small "bridge" script that you deploy once as a web app in your own account. The local server calls it with a secret key, and the bridge runs as you.

Setup

Requires uv.

  1. Create a new project at https://script.google.com and paste in bridge/Code.gs.
  2. Click + next to Services and add Drive API.
  3. In Project Settings, tick Show "appsscript.json" manifest file in editor, then paste in bridge/appsscript.json.
  4. Run the setup function, approve all permissions, and copy the key from the execution log.
  5. Click Deploy > New deployment > Web app, with Execute as: Me and Who has access: Anyone. Copy the /exec URL.
  6. Add the server to your MCP client:
{
  "mcpServers": {
    "apps-script": {
      "command": "uv",
      "args": ["run", "--directory", "/path/to/apps-script-mcp", "apps-script-mcp"],
      "env": {
        "APPS_SCRIPT_BRIDGE_URL": "https://script.google.com/macros/s/.../exec",
        "APPS_SCRIPT_BRIDGE_KEY": "your key"
      }
    }
  }
}

Ask Claude to call bridge_status to check that it works.

Tools

Tool What it does
bridge_status Checks the bridge and the account it runs as
run_code Runs a snippet as you and returns its result and logs
list_projects Lists standalone script projects in your Drive
create_project Creates a standalone project
get_project Reads all files of a project
write_file Creates or replaces one file
delete_file Deletes one file
run_function Runs a function from a project's saved code

Security

Anyone with both the URL and the key can do everything the manifest scopes allow, including reading your mail and files. Treat the key like a password.

  • Remove scopes you do not need from appsscript.json.
  • Run rotateKey in the bridge editor to replace the key.
  • Archive the deployment to turn the bridge off.

Limits

  • Only standalone projects can be edited, not scripts bound to a Sheet, Doc or Form.
  • run_function runs inside the bridge, so there is no active document and the project's own libraries, properties and triggers are unavailable.
  • There is no deploy tool; publish from the Apps Script editor.
  • Each call stops after 6 minutes.

Development

uv sync
uv run pytest

License

MIT

Metadata

Release files for apps-script-mcp 0.1.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for apps-script-mcp 0.1.0
File Size Uploaded Provenance Actions
apps_script_mcp-0.1.0.tar.gz 137.0 kB Without provenance Details for apps_script_mcp-0.1.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for apps-script-mcp 0.1.0
File Interpreter ABI Platform Actions
apps_script_mcp-0.1.0-py3-none-any.whl Python 3 none any Details for apps_script_mcp-0.1.0-py3-none-any.whl

Total release size: 144.5 kB

Release files / apps_script_mcp-0.1.0.tar.gz

Download URL apps_script_mcp-0.1.0.tar.gz
Size 137.0 kB
Tags Source
SHA-256 checksum
How to use checksums
8d1d5bdcdbc4d828f1a1c3ac0c327790364120f15160933e018b0dd0638321e5
BLAKE2b-256 checksum
How to use checksums
095304159768108f2b70aa5ce4c616800dbd889bd36cd149ee63b69eea654d53
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via uv/0.13.9 {"installer":{"name":"uv","version":"0.13.9","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"26.04","id":"resolute","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

Release files / apps_script_mcp-0.1.0-py3-none-any.whl

Download URL apps_script_mcp-0.1.0-py3-none-any.whl
Size 7.5 kB
Tags Python 3
SHA-256 checksum
How to use checksums
7fd90a8b5213b0407cd3154ba13051ccfafa1d7ae529771cd8ae51589c902d1d
BLAKE2b-256 checksum
How to use checksums
0f499945e03a566fb8ff5fd667838f1e7b157625987f5271bee984e1c874f7ce
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via uv/0.13.9 {"installer":{"name":"uv","version":"0.13.9","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"26.04","id":"resolute","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

Security for apps-script-mcp 0.1.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

0.1.0 This release

2 release files No provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page