google-apps-script

Installation
Summary

Server-side automation for Google Sheets and Workspace apps with custom menus, triggers, dialogs, and email integration.

  • Generates Apps Script code that installs via Extensions > Apps Script; supports custom menus, dialogs, sidebars, and automated triggers (on edit, time-driven, form submit)
  • Handles email notifications, PDF exports, and external API integration with built-in error handling and batch operation patterns
  • Requires one-time OAuth authorization per user; scripts run on Google's infrastructure with a generous free tier
  • Critical performance rule: use batch getValues()/setValues() for bulk reads/writes instead of cell-by-cell operations (70x faster)
  • V8 runtime only; use UrlFetchApp.fetch() instead of fetch, Utilities.sleep() instead of setTimeout, and SpreadsheetApp.flush() before returning from dialog-triggered functions
SKILL.md

Google Apps Script

Build automation scripts for Google Sheets and Workspace apps. Scripts run server-side on Google's infrastructure with a generous free tier.

What You Produce

  • Apps Script code pasted into Extensions > Apps Script
  • Custom menus, dialogs, sidebars
  • Automated triggers (on edit, time-driven, form submit)
  • Email notifications, PDF exports, API integrations

Workflow

Step 1: Understand the Automation

Ask what the user wants automated. Common scenarios:

  • Custom menu with actions (report generation, data processing)
  • Auto-triggered behaviour (on edit, on form submit, scheduled)
  • Sidebar app for data entry
Related skills
Installs
990
GitHub Stars
776
First Seen
Feb 18, 2026