google-apps-script
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 offetch,Utilities.sleep()instead ofsetTimeout, andSpreadsheetApp.flush()before returning from dialog-triggered functions
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
More from jezweb/claude-skills
tailwind-v4-shadcn
|
2.7Ktanstack-query
|
2.5Kshadcn-ui
Install and configure shadcn/ui components for React projects. Guides component selection, installation order, dependency management, customisation with semantic tokens, and common UI recipes (forms, data tables, navigation, modals). Use after tailwind-theme-builder has set up the theme infrastructure, when adding components, building forms, creating data tables, or setting up navigation.
2.5Ktailwind-theme-builder
Set up Tailwind v4 + shadcn/ui themed UI with dark mode. Install deps, configure CSS variables via @theme inline, wire dark mode toggle, verify. Use whenever the user mentions Tailwind v4, setting up Tailwind theming, shadcn/ui colours, dark mode, or troubleshooting colours not working, tw-animate-css errors, @theme inline conflicts, @apply breaking after upgrade, or v3 → v4 migration issues.
2.2Kfastapi
|
2.0Kcolor-palette
Generate complete, accessible colour palettes from a single brand hex. Produces 11-shade scale (50-950), semantic tokens, dark mode variants, Tailwind v4 CSS output, WCAG contrast checks. Use whenever the user supplies a brand hex and asks for a palette, mentions setting up a design system, wants Tailwind theme colours from a brand colour, or asks to check colour accessibility / contrast.
1.9K