When USER_GOOGLE_EMAIL environment variable is set, include it in the MCP
server instructions so that AI clients know which email to use for
Google Workspace tools without asking the user.
This improves the experience for desktop apps that handle OAuth externally
and pass credentials via GOOGLE_MCP_CREDENTIALS_DIR + USER_GOOGLE_EMAIL.
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
Extends format_sheet_range with new parameters:
- wrap_strategy: WRAP, CLIP, OVERFLOW_CELL
- horizontal_alignment: LEFT, CENTER, RIGHT
- vertical_alignment: TOP, MIDDLE, BOTTOM
- bold: boolean for bold text
- italic: boolean for italic text
- font_size: integer for font size in points
All parameters work alongside existing color and number format options.
Includes 21 unit tests covering all new functionality.
Added to extended tier in tool_tiers.yaml.
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
Fixes#327
- Use absolute path (~/.workspace-mcp/attachments/) instead of relative
./tmp/attachments to avoid polluting working directories
- Make storage directory configurable via WORKSPACE_ATTACHMENT_DIR env var
- Return file path from save_attachment() instead of UUID for direct
filesystem access (useful in stdio mode where HTTP URLs are unavailable)
- Preserve original filenames with UUID suffix for uniqueness
- Use format="full" instead of format="metadata" when fetching attachment
info, as metadata format doesn't include attachmentId in parts
- Add multi-level filename matching: exact attachmentId → size-based
fallback → single-attachment fallback (handles ephemeral IDs)
Add batch_update_form to the Complete tier in tool_tiers.yaml and
document it in both README files as requested in PR review.
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
The `extended` key under `calendar` was missing proper indentation,
causing YAML parsing errors when loading tools with `--tool-tier complete`.
Fixes#398
The list_gmail_filters, create_gmail_filter, and delete_gmail_filter
tools were implemented in gmail_tools.py but not exposed in the
tool_tiers.yaml configuration, causing them to be filtered out when
using the tier-based tool loading system.
Also added get_gmail_attachment_content which was similarly missing.
Changes:
- Added get_gmail_attachment_content to extended tier
- Added list_gmail_filters to extended tier
- Added create_gmail_filter to extended tier
- Added delete_gmail_filter to extended tier
- Removed duplicate get_gmail_attachment_content entry
- Add 'leo' tier as standalone (non-cumulative) tier
- Configure leo tier with curated tools for gmail, drive, docs, slides
- Updated tool_tier_loader to support standalone tiers
- Removed deprecated tools from leo tier (format_text_style, create_list, remove_list_formatting)
Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
Google Docs styling tools:
- format_text_style: Rich text formatting (bold, italic, underline, colors, fonts)
- format_paragraph_style: Paragraph formatting (alignment, spacing, indentation)
- apply_heading_style: Apply H1-H6 heading styles using namedStyleType
- create_list: Convert paragraphs to bullet/numbered lists with visual indentation
- remove_list_formatting: Remove list formatting from paragraphs
Google Drive import tool:
- import_to_google_doc: Import files (MD, DOCX, TXT, HTML, RTF, ODT) as native
Google Docs with automatic format conversion by Google Drive
Security:
- SSRF protection for file_url parameter (blocks localhost and private IPs)
All tools include input validation, error handling, and comprehensive docstrings.
New tools added:
- delete_script_project: Full CRUD support for script projects
- list_versions: List all versions of a script
- create_version: Create immutable version snapshots
- get_version: Get details of a specific version
- get_script_metrics: Get execution analytics (active users, executions, failures)
- generate_trigger_code: Generate Apps Script code for time-based and event triggers
Changes:
- Updated auth/scopes.py with script.metrics scope and drive.file for delete
- Updated core/tool_tiers.yaml with new tools in core and extended tiers
- Updated gappsscript/README.md with new features documentation
- Added 8 new unit tests (18 total)
This brings total Apps Script tools from 11 to 17, covering the complete REST API.
- Implement query_freebusy tool to query free/busy information for calendars
- Add support for time range queries with RFC3339 format
- Support multiple calendar queries in a single request
- Include optional parameters for group and calendar expansion limits
- Add tool to core tier in tool_tiers.yaml for essential availability checking
- Follow existing patterns for authentication, error handling, and logging
- Adds --read-only CLI flag to restrict OAuth scopes to read-only permissions
- Implements dynamic tool filtering to disable tools requiring write permissions when in read-only mode
- Updates auth/scopes.py to manage read-only scope mappings
- Enhances @require_google_service and handle_http_errors decorators to propagate scope metadata
- Updates documentation in README.md
