Build Google Apps Script automation for Sheets and Workspace. Custom menus, triggers (onEdit / time-driven / form submit), dialogs, sidebars, email batches, PDF export, external API.
SkillScore100Maintained
Automatic
◆Coding pack
Last verified 8/14/2026
What it changes
Passed 24 of 24 test cases with the skill, and 21 of 24 without it.
Without skill88%
With skill100%
Checks it passed that the model alone missed
recommends using ScriptApp.newTrigger() to create an installable trigger
calls SpreadsheetApp.flush() before returning from the row archiving function
calls SpreadsheetApp.flush() inside the server function invoked by the modal progress dialog
3 fixed21 passed either way0 still failing0 broke
Pass-rate lift
+13 pp
Tokens
+275%
Agent turns
0%
Response time
-9%
Model gemini-3.6-flashMeasured 8/14/2026v124 of 24 cases passed with skill
Tokens, turns and time describe resource use, not a dollar price.
See it in action
One of 3 test cases the skill fixed. Same model, same prompt, with and without the skill.
1 of 3
Prompt
I need a Google Apps Script for my spreadsheet that moves rows marked 'Done' from my active task list to an archive tab. Please provide the complete script structured with header comments, top-level settings, a top menu entry to trigger it manually, fast bulk data handling, and clear installation instructions for pasting the code and handling first-run authorization.
What was checked, without and with the skill
Checked
Without skill
With skill
calls SpreadsheetApp.flush() before returning from the row archiving function
Missed
Passed
case-01 · gemini-3.6-flash · 8/14/2026 · answers are capped and redacted
What's inside
The instructions your model reads when the skill loads.
SKILL.md535 linessingle file
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)
Step 4: First-Time Authorisation
Each user gets a Google OAuth consent screen on first run. For unverified scripts (most internal scripts), users must click: