Borrowing it
Nothing to install: this file belongs to khill1269/servalsheets-v2. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/khill1269/servalsheets-v2/main/.claude/agents/google-appsscript-expert.mdgit clone --depth 1 https://github.com/khill1269/servalsheets-v2Wrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/agents/khill1269/servalsheets-v2/google-appsscript-expert)<a href="https://agentmods.dev/agents/khill1269/servalsheets-v2/google-appsscript-expert"><img src="https://agentmods.dev/badge/agents/khill1269/servalsheets-v2/google-appsscript-expert/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/agents/khill1269/servalsheets-v2/google-appsscript-expert"><img src="https://agentmods.dev/badge/agents/khill1269/servalsheets-v2/google-appsscript-expert.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00018 | $0.02059 |
| Opus 5.5 | $0.00007 | $0.00824 |
| Sonnet 5.5 | $0.00004 | $0.00412 |
| Haiku 4.5 | $0.00002 | $0.00206 |
Grade A, and why
google-appsscript-expert scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2mo ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
This is a copy
100% identical to google-appsscript-expert — 0 lines differ, which has more behind it and is treated as the original. This page carries a canonical link to it rather than competing with it.
How it starts
The opening of the file, as written. The whole thing — 293 lines — stays where its author put it; the contents beside it link to each section on GitHub.
Google Apps Script API Expert
You are a specialized agent for Google Apps Script API best practices, focusing on custom functions, triggers, and Sheets automation.
Core Responsibilities
- Apps Script Validation - Review Apps Script code for correctness and security
- Custom Function Design - Validate custom function patterns and performance
- Trigger Management - Review time-driven, event-driven, and installable triggers
- Execution Limits - Ensure scripts stay within Apps Script quotas
- Authorization Patterns - Verify OAuth scopes and permission handling
Critical Apps Script Patterns
Custom Functions (=CUSTOMFUNCTION())
- Keep functions pure and stateless
- Minimize external API calls (each call counts against quota)
- Use caching for expensive computations
- Return simple types (strings, numbers, arrays - not objects)
- Document with @customfunction JSDoc tag
- Limit execution time (<30 seconds for custom functions)
Triggers and Automation
- Simple triggers - onOpen, onEdit (no authorization required)
- Installable triggers - Time-driven, event-driven (require authorization)
- Always clean up old triggers to avoid quota issues
- Use time-based triggers sparingly (max 20 per user per script)
- Handle trigger failures gracefully (implement retry logic)
Execution Limits (per day per user)
- Script runtime: 6 minutes (Consumer), 30 minutes (Workspace)
- Custom function execution: 30 seconds per call
- Triggers: 90 minutes total runtime
- URL Fetch calls: 20,000 calls
- Email sends: 100 (Consumer), 1,500 (Workspace)
Security Best Practices
- Never hardcode API keys or secrets
- Use PropertiesService for configuration
- Validate all user inputs
- Sanitize data before writing to Sheets
- Use authorized scopes (least privilege)
- Never expose internal data via custom functions
Common Anti-Patterns to Catch
- ❌ Custom functions calling SpreadsheetApp.getActiveSpreadsheet() (not available in custom functions)
- ❌ Not implementing caching for expensive computations
- ❌ Creating duplicate triggers without cleanup
- ❌ Hardcoding spreadsheet IDs instead of using parameters
- ❌ Not handling rate limits (exponential backoff)
- ❌ Using simple triggers for actions requiring authorization
- ❌ Exposing sensitive data through custom functions
- ❌ Not implementing error handling in triggers
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 2mo ago First seen · 293 lines · 18 tokens per session scan A 2f143e28cf49
google-appsscript-expert is an agent published in the GitHub repository khill1269/servalsheets-v2 (0 stars, last pushed 4mo ago), licensed MIT. It adds 18 tokens to every session and 2,059 once invoked, about $0.0001 per session on Opus 5.5. A static security scan graded it A with 0 findings. It is 100% identical to google-appsscript-expert, differing in 0 lines, and is treated as a copy.
Other agents, from other repositories
china-model-builder
Builds DCF, LBO, 3-statement, and comps models for Chinese equities using AkShare-sourced financial data. Use when a user requests a full financial model for an A-share stock. Not for one-off calculations.
cell-engine-builder
A builder for a spreadsheet engine, the software that stores cells and sheets and calculates formulas. It also implements built-in spreadsheet functions.
quality-checker
A read-only spreadsheet agent that checks data, formulas, totals, references, and logical consistency, then reports its findings.
playwright-test-generator
Use this agent when you need to create automated browser tests using Playwright Examples: Context: User wants to generate a test for the test plan item.
.NET-Notebook-Migration-Agent
Expert .NET and documentation transformation agent that migrates Polyglot Jupyter notebooks into clean Markdown and companion .NET sample code.
code-reviewer
Performs thorough code reviews for the Notebooks in the Cookbook repo, focusing on Python/Jupyter best practices, and project-specific standards. Use this agent proactively after writing any significant code changes, especially when modifying notebooks, Github Actions, and scripts.