google-automation-mcp: Instructions file for Gemini CLI

Apps Script MCP

This extension provides tools to manage Google Apps Script projects.

Available Tools

• list_script_projects — List all accessible Apps Script projects
• get_script_project — Get project details including all files
• get_script_content — Get content of a specific file
• create_script_project — Create a new project (standalone or bound to Sheet/Doc/Form/Slides)
• update_script_content — Update files in a project
• delete_script_project — Delete a project (permanent, cannot be undone)
• run_script_function — Execute a function in a script
• create_deployment — Create a new deployment
• list_deployments — List all deployments
• update_deployment — Update deployment configuration
• delete_deployment — Delete a deployment
• list_versions — List all versions of a script
• create_version — Create an immutable version snapshot
• get_version — Get details of a specific version
• list_script_processes — View recent script executions
• get_script_metrics — Get execution analytics (active users, executions, failures)
• generate_trigger_code — Generate Apps Script code for triggers

Authentication

Before using these tools, the user must authenticate with Google:

1. Run gmcp auth in terminal (if browser available)
2. Or run gmcp auth --headless for remote/SSH environments

If not authenticated, use start_google_auth to begin the OAuth flow, then complete_google_auth with the redirect URL.

Bound Scripts

To create a script attached to a Google Sheet, Doc, Form, or Slides:

• Use create_script_project with the document ID as parent_id
• Extract the ID from the document URL (e.g., docs.google.com/spreadsheets/d/{ID}/edit)

Bound scripts can use onOpen, onEdit triggers and access document-specific APIs.

Triggers

The API cannot create triggers directly. Use generate_trigger_code to generate Apps Script code:

• time_minutes / time_hours / time_daily / time_weekly — Scheduled triggers
• on_open / on_edit — Simple triggers (just add the code)
• on_form_submit / on_change — Event triggers