CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

google-apps-script

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. Use whenever the user wants to automate a Google Sheet, build a Sheets menu / sidebar / dialog, hit a Sheets row from email or a webhook, schedule a Sheets workflow, or asks 'how do I script this in Sheets'.

Quality

87%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

78%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

Highly actionable body content: complete executable examples covering the common Apps Script cases, focused on real gotchas rather than concepts Claude already knows. The main weakness is structure — everything is inlined in one long file where recipes, quota tables, and the dialog template belong in one-level-deep reference files.

Suggestions

Split the Modal Progress Dialog template, the Recipes section, and the Quotas and Limits table into reference files (e.g. references/recipes.md, references/quotas.md, references/dialogs.md) with clearly signaled links from SKILL.md, keeping SKILL.md as a lean overview.

Trim redundant content: the server-side/free-tier intro sentence and the 500 KB limit, which is stated in both the quota table and the Properties Service section.

Embed validation checkpoints in the main workflow (e.g. an explicit 'verify the script runs' step after install) instead of relying solely on the end-of-file Deployment Checklist and 'test on a copy' note.

DimensionReasoningScore

Conciseness

Efficient and focused on genuinely non-obvious gotchas (underscore-private functions, 70x batch difference, flush-before-return, undocumented PDF export params, quotas) with minimal prose around code. Not 5: minor trimmable content — the 'Scripts run server-side on Google's infrastructure with a generous free tier' intro, and the 500 KB limit stated in both the quota table and the Properties Service section.

4 / 5

Actionability

Fully executable copy-paste-ready code throughout (onOpen template, progress dialog, sidebar, triggers, email, PDF export, API calls with muteHttpExceptions, batch email with quota check) with concrete install instructions. Matches the top anchor: common cases are covered with complete, runnable examples.

5 / 5

Workflow Clarity

Clear 4-step sequence (understand, generate, install, authorize) plus a debugging section, an Error Prevention table, and a Deployment Checklist. Not 5: validation ('test on a copy', checklist) sits at the end rather than embedded as checkpoints in the workflow itself. The batch-operation cap at 3 does not apply because batch recipes do carry validation (quota check, per-row try/catch, per-row status marking).

4 / 5

Progressive Disclosure

Well-sectioned with clear headers, but entirely monolithic at ~540 lines with no bundle files — the modal progress dialog template, recipes, and quota tables clearly belong in separate reference files. Matches anchor 3 ('content that should be separate is inline'); structure is too good for 2, but the absence of any file splitting and the length keep it below 4.

3 / 5

Total

16

/

20

Passed

Description

92%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong description: concrete capability list, explicit 'Use whenever...' trigger clause with natural user phrasing, and a clearly distinct Apps Script/Sheets niche. The only weakness is modest synonym coverage (e.g. 'macros', '.gs') in the trigger terms.

DimensionReasoningScore

Specificity

Lists multiple specific concrete actions — 'Custom menus, triggers (onEdit / time-driven / form submit), dialogs, sidebars, email batches, PDF export, external API' — with comprehensive coverage of the skill's domain. Not 4: there are no meaningful gaps in the action list.

5 / 5

Completeness

Explicitly answers both 'what' ('Build Google Apps Script automation for Sheets and Workspace...') and 'when' with concrete trigger phrases ('Use whenever the user wants to automate a Google Sheet...'). Not 4: the 'when' clause is explicit and specific rather than vague.

5 / 5

Trigger Term Quality

Good natural trigger phrases ('automate a Google Sheet', 'build a Sheets menu / sidebar / dialog', 'schedule a Sheets workflow', "asks 'how do I script this in Sheets'"). Not 5: missing common synonyms and extensions users might say, e.g. 'macros', '.gs', or 'Apps Script editor'.

4 / 5

Distinctiveness Conflict Risk

Clear niche (Apps Script for Sheets/Workspace) with distinct triggers anchored to Sheets scripting. Not 4: 'PDF export' and 'external API' create only minimal overlap risk since they are framed within Sheets automation.

5 / 5

Total

19

/

20

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

skill_md_line_count

SKILL.md is long (542 lines); consider splitting into references/ and linking

Warning

Total

15

/

16

Passed

Repository

jezweb/claude-skills

Path

plugins/integrations/skills/google-apps-script/SKILL.md

Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.