Apps Script MCP
This server provides AI agents with secure access to Google Workspace APIs through 50 curated tools, without requiring a GCP project, OAuth consent screen, or client secrets setup.
Key Features
Simplified auth via Google's
claspCLI — no GCP setup neededAI agents never handle credentials directly (security boundary enforced)
Multi-user support via
user_google_emailparameter for credential isolationEvery tool call is logged for audit purposes
Gmail — Search messages, retrieve by ID, send emails (plain/HTML, CC/BCC), list labels, modify labels (archive, star, trash, etc.)
Google Drive — Search files/folders, list folder contents, get file content, create/delete/trash files and folders, share files, and manage permissions
Google Sheets — List spreadsheets, read/write/append cell values, create new spreadsheets, get metadata (sheet names, properties)
Google Calendar — List calendars, get/create/update/delete events (including all-day events with attendees)
Google Docs — Search documents, get content, create new docs, modify text (insert or find-and-replace), append text
Apps Script (17 tools) — Full lifecycle management:
List, get, create, update, and delete script projects
Execute functions in deployed scripts
Manage deployments (create, list, update, delete) and versions (create, list, get)
Monitor execution processes and retrieve daily/weekly metrics
Generate trigger code for time-based and event-driven triggers (on-edit, on-open, on-form-submit, etc.)
Authentication — Start and complete the Google OAuth flow directly via MCP tools
Uses Google OAuth authentication to provide secure access to Apps Script projects and related development tools.
Provides tools to create, manage, edit, and execute Apps Script projects, including script deployment and execution monitoring.
Integrates with Google Cloud projects to manage API permissions and OAuth credentials required for script execution and deployment.
Interacts with the Google Drive API to list and manage script projects stored within the user's account.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Apps Script MCPlist my script projects and show me the files in 'Email Automation'"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Google Automation MCP
Google Workspace APIs for AI agents — no GCP project required.
Uses clasp for authentication. No GCP console, no OAuth consent screen, no client secrets. Just authenticate and go.
Quick Start
uvx google-automation-mcp # Run server
uvx google-automation-mcp auth # Authenticate (one-time browser sign-in)That's it. No GCP project setup. Tokens auto-refresh after initial auth.
Tip: Use the short alias
gmcpafter installing.
Why No GCP Project?
Traditional Google API setup requires:
Create GCP project
Enable APIs
Configure OAuth consent screen
Add test users
Create OAuth credentials
Download client_secret.json
This MCP uses clasp (Google's official Apps Script CLI) which handles OAuth without a GCP project. Same Google authentication, zero configuration.
Security: AI Never Sees Credentials
Direct API | This MCP | |
Credentials | AI handles tokens directly | AI never sees tokens |
API access | Any endpoint | 50 curated tools only |
Audit | Build your own | Every tool call logged |
The MCP acts as a security boundary. Your AI agent calls tools; the MCP handles authentication internally.
MCP Client Configuration
Claude Desktop (One-Click Install):
Download google-automation-mcp.dxt and open it. Claude Desktop will install automatically.
Claude Code (~/.mcp.json):
{
"mcpServers": {
"google": {
"type": "stdio",
"command": "uvx",
"args": ["google-automation-mcp"]
}
}
}Claude Desktop (Manual) (claude_desktop_config.json):
{
"mcpServers": {
"google": {
"command": "uvx",
"args": ["google-automation-mcp"]
}
}
}Gemini CLI:
gemini extensions install github:sam-ent/google-automation-mcpAvailable Tools (50)
Gmail (5)
search_gmail_messages · get_gmail_message · send_gmail_message · list_gmail_labels · modify_gmail_labels
Drive (10)
search_drive_files · list_drive_items · get_drive_file_content · create_drive_file · create_drive_folder · delete_drive_file · trash_drive_file · share_drive_file · list_drive_permissions · remove_drive_permission
Sheets (6)
list_spreadsheets · get_sheet_values · update_sheet_values · append_sheet_values · create_spreadsheet · get_spreadsheet_metadata
Calendar (5)
list_calendars · get_events · create_event · update_event · delete_event
Docs (5)
get_doc_content · search_docs · create_doc · modify_doc_text · append_doc_text
Apps Script (17)
list_script_projects · get_script_project · get_script_content · create_script_project · update_script_content · delete_script_project · run_script_function · create_deployment · list_deployments · update_deployment · delete_deployment · list_versions · create_version · get_version · list_script_processes · get_script_metrics · generate_trigger_code
Auth (2)
start_google_auth · complete_google_auth
Multi-User Support
All tools accept user_google_email for per-user credential isolation:
search_gmail_messages(user_google_email="alice@example.com", query="is:unread")
search_gmail_messages(user_google_email="bob@example.com", query="is:unread")Credentials stored separately: ~/.secrets/google-automation-mcp/credentials/{email}.json
Apps Script: Extending Google Workspace
Apps Script tools let you deploy code that runs inside Google apps — things REST APIs cannot do:
Capability | Example |
Custom spreadsheet functions |
|
Real-time triggers |
|
Custom menus | Add menu items to Sheets/Docs |
Webhooks |
|
# Create a bound script with custom function
create_script_project(title="Validator", parent_id="SPREADSHEET_ID")
update_script_content(script_id="...", files=[{
"name": "Code",
"type": "SERVER_JS",
"source": "function VALIDATE_EMAIL(e) { return /^[^@]+@[^@]+\\.[^@]+$/.test(e); }"
}])Limitations
run_script_function requires one-time setup per script: Open script at script.google.com → Project Settings → Change GCP project → Deploy as API Executable. Once configured, functions can be called repeatedly. All other tools work without this setup.
API quotas: Google enforces rate limits.
Production: OAuth 2.1
For multi-user deployments requiring your own OAuth credentials:
export GOOGLE_OAUTH_CLIENT_ID='...'
export GOOGLE_OAUTH_CLIENT_SECRET='...'
gmcp auth --oauth21CLI Reference
Short alias: gmcp (or full name: google-automation-mcp)
gmcp # Run server
gmcp setup # Interactive setup wizard
gmcp auth # Authenticate with clasp
gmcp auth --oauth21 # OAuth 2.1 for production
gmcp status # Check auth status
gmcp version # Show versionDevelopment
git clone https://github.com/sam-ent/google-automation-mcp.git
cd google-automation-mcp
uv sync
uv run pytest tests/ -v # 45 testsAcknowledgments
Built on google_workspace_mcp by Taylor Wilsdon (MIT License).
License
MIT
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
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/sam-ent/appscript-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server