Google Apps Script
This gives Claude the full Apps Script playbook: custom menus, triggers (onEdit, time-driven, form submit), dialogs with spinners, email batching, and API calls. The workflow is consistent (paste into Extensions > Apps Script, save, reload the sheet) and it handles the gotchas that break most scripts: private functions with underscores silently fail in dialogs, cell-by-cell reads are 70x slower than bulk getValues(), and you need flush() before returning or changes won't show. Covers both simple and installable triggers, quota limits, and the V8 runtime quirks. Use this when someone wants to automate Sheets workflows, build custom UI, or wire up external services to spreadsheet data.
- skills.sh installs
- 2K
- GitHub stars
- 1.1K
- last updated
- Aug 21, 2026
Install
$ npx -y skills add jezweb/claude-skills --skill google-apps-script --agent claude-codeInstalls into .claude/skills of the current project.
Files
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
- Email notifications from sheet data
- PDF export and distribution
Step 2: Generate the Script
Follow the structure template below. Every script needs a header comment, configuration constants at top, and onOpen() for menu setup.
Step 3: Provide Installation Instructions
All scripts install the same way:
- Open the Google Sheet
- Extensions > Apps Script
- Delete any existing code in the editor
- Paste the script
- Click Save
- Close the Apps Script tab
- Reload the spreadsheet (onOpen runs on page load)
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/jezweb/claude-skills
- Categories
- Backend & APIs, DevOps & CI/CD, Automation & Workflows, Office & Documents
- First seen
- Apr 16, 2026
More from jezweb/claude-skills
All 166- Icon Set Generator2K
- Fastapi2K
- Seo Local Business1.9K
- Responsiveness Check1.8K
- Vitest1.8K
- D1 Drizzle Schema1.7K
- Wordpress Content1.7K
- Elevenlabs Agents1.7K
- Project Health1.6K
- Hono Api Scaffolder1.6K
- Wordpress Setup1.6K
- Landing Page1.5K
- Design Review1.5K
- Mcp Builder1.4K
- Social Media Posts1.4K
- Cloudflare Worker Builder1.4K
- Ai Image Generator1.4K
- Shopify Products1.4K
- Github Release1.3K
- React Native1.3K
- React Patterns1.3K
- Resume Cover Letter1.3K
- Google Chat Messages1.3K
- Proposal Writer1.3K
Recommended
More Backend & APIs
physical-ai-infrastructure-setup-and-resilient-scalingnvidia/skillsUse when the user wants to set up, scale, validate, or harden NVIDIA physical AI infrastructure for synthetic data generation workflows across local MicroK8s or2Kskills.sh installs
engineering-advanced-skillsalirezarezvani/claude-skillsIndex of 37 advanced engineering agent skills for Claude Code, Codex, Gemini CLI, Cursor, OpenClaw. Use when browsing or choosing among the POWERFUL-tier engine2Kskills.sh installs
postgres-best-practicesneondatabase/postgres-skillsBest practices and guidelines for working with Postgres. Covers schema design, indexing strategies, query optimization, migrations, and common pitfalls. Use whe2Kskills.sh installs
cms-migrationpayloadcms/skillsUse when user wants to migrate content from another CMS (WordPress, Contentful, Strapi, Sanity, Webflow, etc.) to Payload CMS2Kskills.sh installs
skill-creatorapollographql/skillsGuide for creating effective skills for Apollo GraphQL and GraphQL development. Use this skill when: (1) users want to create a new skill, (2) users want to upd2Kskills.sh installs
agentcashmerit-systems/agentcash-skillsPay-per-call x402/MPP APIs (USDC on Base, Solana, Tempo). No API keys—wallet pays per request. If the task matches a SERVICES origin below, SKIP search and go s2Kskills.sh installs