google-apps-script_skill

Overview

This skill is a comprehensive guide for Google Apps Script development that covers built-in services, triggers, authorization, error handling, and performance optimization. It consolidates practical patterns and ready-to-use techniques for automating Sheets, Docs, Gmail, Drive, Calendar, Forms, and Slides using the V8 JavaScript runtime. Use it to design reliable automations, add-ons, and integrations with external APIs while minimizing quotas and runtime errors.

How this skill works

The skill inspects and documents each core service (SpreadsheetApp, DocumentApp, GmailApp, DriveApp, CalendarApp, FormApp, SlidesApp) and explains triggers, OAuth scopes, and runtime behaviors. It provides code patterns for batch operations, caching, properties storage, UrlFetchApp calls, and retry/error-recovery strategies. It also describes validation, testing workflows, and diagnostics (Logger, breakpoints, audit logging) to make deployments predictable and maintainable.

When to use it

• Automating Google Sheets tasks: reading, writing, formatting, and custom functions
• Generating or modifying Google Docs and Slides programmatically
• Managing Gmail (send, search, label) and Drive files or sharing permissions
• Automating Calendar events and creating time- or event-based triggers
• Building Workspace add-ons, handling OAuth scopes, and deployment configuration
• Calling external APIs with UrlFetchApp and storing transient/persistent data (CacheService, PropertiesService)

Best practices

• Batch operations: read/write ranges and files in bulk; avoid cell-by-cell loops
• Use CacheService for short-term caching and PropertiesService for persistent config/state
• Wrap external calls and critical logic in try/catch and implement retries with exponential backoff
• Minimize OAuth scopes in appscript.json and request only what you need
• Respect execution limits (6-minute runtime) by splitting large jobs across triggers or processing in chunks
• Validate objects and ranges before use to prevent null/reference errors

Example use cases

• Scheduled weekly report: aggregate Sheet data, write summary, and email stakeholders
• Drive sync: move and re-share files based on folder rules and metadata
• Gmail automation: auto-label and respond to specific messages with templated replies
• Calendar batch updater: create or update recurring events from a data feed
• Add-on pattern: custom UI + trigger to enrich Sheets with external API data