Google Apps Script MCP
An MCP server that enables AI agents to interact with the Google Apps Script API. It allows users to manage script projects, read and edit code files, create immutable versions, manage deployments, run functions, and inspect execution history and metrics. It handles OAuth connection via PKCE directly from the conversation without requiring config files.
Package and access
Local package with source-attributed installation metadata. Koskamo does not execute packages during review.
What you can do with it
- Create standalone and bound script projects
- Read and update code files in a project
- Snapshot immutable versions and manage deployments
- Run functions and inspect execution history
Source and maintenance
- Maintenance checked
Packages and installation
Source-provided package data. Koskamo has not executed or live-probed this package.
mcp-google-apps-script 1.1.1
{
"version": "1.1.1",
"transport": "stdio",
"identifier": "mcp-google-apps-script",
"registryType": "npm",
"registryBaseUrl": "https://registry.npmjs.org",
"environmentVariables": [
{
"name": "GOOGLE_APPS_SCRIPT_CLIENT_ID",
"description": "Google OAuth2 client id (refresh-token flow)."
},
{
"name": "GOOGLE_APPS_SCRIPT_CLIENT_SECRET",
"description": "Google OAuth2 client secret (refresh-token flow). Treat it as a secret."
},
{
"name": "GOOGLE_APPS_SCRIPT_REFRESH_TOKEN",
"description": "Google OAuth2 refresh token, exchanged for access tokens automatically. Treat it as a secret."
},
{
"name": "GOOGLE_APPS_SCRIPT_ACCESS_TOKEN",
"description": "Static OAuth2 access token (~1h lifetime) — alternative to the refresh-token trio, mostly for testing."
},
{
"name": "GOOGLE_APPS_SCRIPT_OAUTH_PORT",
"description": "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."
},
{
"name": "GOOGLE_APPS_SCRIPT_API_BASE",
"default": "https://script.googleapis.com",
"description": "API root override."
},
{
"name": "GOOGLE_APPS_SCRIPT_TIMEOUT_MS",
"default": "60000",
"description": "Per-request timeout in milliseconds."
},
{
"name": "GOOGLE_APPS_SCRIPT_MAX_RETRIES",
"default": "3",
"description": "Retries on transient errors (429 always; 5xx/network for reads)."
}
]
}Tools
Reported by the attributed source; not independently observed by Koskamo.
Connect from your client
Each snippet configures the same source-provided package; replace placeholders before use.
Cursor
{
"mcpServers": {
"google-apps-script-mcp": {
"command": "npx",
"args": [
"-y",
"mcp-google-apps-script@1.1.1"
],
"env": {
"GOOGLE_APPS_SCRIPT_CLIENT_ID": "<YOUR_GOOGLE_APPS_SCRIPT_CLIENT_ID>",
"GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "<YOUR_GOOGLE_APPS_SCRIPT_CLIENT_SECRET>",
"GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "<YOUR_GOOGLE_APPS_SCRIPT_REFRESH_TOKEN>",
"GOOGLE_APPS_SCRIPT_ACCESS_TOKEN": "<YOUR_GOOGLE_APPS_SCRIPT_ACCESS_TOKEN>",
"GOOGLE_APPS_SCRIPT_OAUTH_PORT": "<YOUR_GOOGLE_APPS_SCRIPT_OAUTH_PORT>",
"GOOGLE_APPS_SCRIPT_API_BASE": "<YOUR_GOOGLE_APPS_SCRIPT_API_BASE>",
"GOOGLE_APPS_SCRIPT_TIMEOUT_MS": "<YOUR_GOOGLE_APPS_SCRIPT_TIMEOUT_MS>",
"GOOGLE_APPS_SCRIPT_MAX_RETRIES": "<YOUR_GOOGLE_APPS_SCRIPT_MAX_RETRIES>"
}
}
}
}Cline
{
"mcpServers": {
"google-apps-script-mcp": {
"command": "npx",
"args": [
"-y",
"mcp-google-apps-script@1.1.1"
],
"env": {
"GOOGLE_APPS_SCRIPT_CLIENT_ID": "<YOUR_GOOGLE_APPS_SCRIPT_CLIENT_ID>",
"GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "<YOUR_GOOGLE_APPS_SCRIPT_CLIENT_SECRET>",
"GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "<YOUR_GOOGLE_APPS_SCRIPT_REFRESH_TOKEN>",
"GOOGLE_APPS_SCRIPT_ACCESS_TOKEN": "<YOUR_GOOGLE_APPS_SCRIPT_ACCESS_TOKEN>",
"GOOGLE_APPS_SCRIPT_OAUTH_PORT": "<YOUR_GOOGLE_APPS_SCRIPT_OAUTH_PORT>",
"GOOGLE_APPS_SCRIPT_API_BASE": "<YOUR_GOOGLE_APPS_SCRIPT_API_BASE>",
"GOOGLE_APPS_SCRIPT_TIMEOUT_MS": "<YOUR_GOOGLE_APPS_SCRIPT_TIMEOUT_MS>",
"GOOGLE_APPS_SCRIPT_MAX_RETRIES": "<YOUR_GOOGLE_APPS_SCRIPT_MAX_RETRIES>"
}
}
}
}VS Code
{
"servers": {
"google-apps-script-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"mcp-google-apps-script@1.1.1"
],
"env": {
"GOOGLE_APPS_SCRIPT_CLIENT_ID": "<YOUR_GOOGLE_APPS_SCRIPT_CLIENT_ID>",
"GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "<YOUR_GOOGLE_APPS_SCRIPT_CLIENT_SECRET>",
"GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "<YOUR_GOOGLE_APPS_SCRIPT_REFRESH_TOKEN>",
"GOOGLE_APPS_SCRIPT_ACCESS_TOKEN": "<YOUR_GOOGLE_APPS_SCRIPT_ACCESS_TOKEN>",
"GOOGLE_APPS_SCRIPT_OAUTH_PORT": "<YOUR_GOOGLE_APPS_SCRIPT_OAUTH_PORT>",
"GOOGLE_APPS_SCRIPT_API_BASE": "<YOUR_GOOGLE_APPS_SCRIPT_API_BASE>",
"GOOGLE_APPS_SCRIPT_TIMEOUT_MS": "<YOUR_GOOGLE_APPS_SCRIPT_TIMEOUT_MS>",
"GOOGLE_APPS_SCRIPT_MAX_RETRIES": "<YOUR_GOOGLE_APPS_SCRIPT_MAX_RETRIES>"
}
}
}
}Claude Desktop
{
"mcpServers": {
"google-apps-script-mcp": {
"command": "npx",
"args": [
"-y",
"mcp-google-apps-script@1.1.1"
],
"env": {
"GOOGLE_APPS_SCRIPT_CLIENT_ID": "<YOUR_GOOGLE_APPS_SCRIPT_CLIENT_ID>",
"GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "<YOUR_GOOGLE_APPS_SCRIPT_CLIENT_SECRET>",
"GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "<YOUR_GOOGLE_APPS_SCRIPT_REFRESH_TOKEN>",
"GOOGLE_APPS_SCRIPT_ACCESS_TOKEN": "<YOUR_GOOGLE_APPS_SCRIPT_ACCESS_TOKEN>",
"GOOGLE_APPS_SCRIPT_OAUTH_PORT": "<YOUR_GOOGLE_APPS_SCRIPT_OAUTH_PORT>",
"GOOGLE_APPS_SCRIPT_API_BASE": "<YOUR_GOOGLE_APPS_SCRIPT_API_BASE>",
"GOOGLE_APPS_SCRIPT_TIMEOUT_MS": "<YOUR_GOOGLE_APPS_SCRIPT_TIMEOUT_MS>",
"GOOGLE_APPS_SCRIPT_MAX_RETRIES": "<YOUR_GOOGLE_APPS_SCRIPT_MAX_RETRIES>"
}
}
}
}Let your agent find its tools
Find servers like Google Apps Script MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.