skills.rest
blucsigma05
blucsigma05COMMUNITY
Explore all skills by this author →
GitHub

monday-drift-sweep

Audit TBM Apps Script codebase and Google Sheets for ES5 compliance, Safe-wrapper wiring, sheet growth, and trigger headroom.

Updated Aug 27, 2026
Search Tags:#Google Apps Script#scheduled audit#ES5 enforcement#Safe wrapper validation#sheet growth monitoring#trigger headroom#Notion reporting
One-click install
npx skills add https://github.com/blucsigma05/tbm-apps-script --skill monday-drift-sweep
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: monday-drift-sweep
Source: https://github.com/blucsigma05/tbm-apps-script/tree/main/.claude/scheduled-tasks/monday-drift-sweep
Command: npx skills add https://github.com/blucsigma05/tbm-apps-script --skill monday-drift-sweep

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Prevents gradual quality and operational drift across the TBM codebase and Google Sheets by consolidating audit checks into a single weekly report.

Core Features & Use Cases

  • Full Codebase Audit for Safety/Compatibility: Scans all HTML for ES5 violations, verifies Safe wrappers have matching failure handlers, and checks for orphan google.script.run.<fn>Safe() calls against the code router/whitelist.
  • Sheet Growth Monitor with Runaway Detection: Executes test runs to extract growth metrics, tracks week-over-week growth for KH_* and data output tabs, and flags tabs growing too fast or nearing GAS slowness thresholds.
  • Trigger Audit with Headroom Alerts: Queries trigger counts to compute remaining headroom (limit 20) and escalates when headroom is critically low or saturated.
  • Actionable Consolidated Notifications + Notion Logging: Sends one consolidated Pushover summary with priority/escalation rules and appends results to a Notion “Monday Drift Reports” child page.

Quick Start

Ask to run the Monday drift sweep report for this week and return any ES5 violations, orphan Safe wiring, runaway/near-limit sheet growth, and trigger headroom in a single consolidated output.

Frequently Asked Questions about monday-drift-sweep

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I audit Google Apps Script codebase for ES5 compliance and Safe wrapper wiring?▼

To audit Google Apps Script for ES5 compliance, scan HTML files for incompatible patterns and verify Safe wrapper calls have matching withFailureHandler proximity rules. This detects orphan google.script.run Safe calls and ensures code router whitelist adherence.

What is the best way to monitor Google Sheets growth anomalies and prevent GAS slowness?▼

Monitoring Google Sheets growth anomalies requires executing test runs to extract growth metrics and tracking week-over-week growth for data tabs. This flags tabs growing too fast or nearing Google Apps Script slowness thresholds before performance degrades.

How do I check Google Apps Script trigger headroom and remaining limits?▼

Checking Google Apps Script trigger headroom involves querying current trigger counts and computing remaining capacity against the 20 trigger limit. This alerts you when headroom is critically low or saturated, preventing silent automation failures.

Can I consolidate Apps Script code health and sheet growth alerts into a single weekly report?▼

You can consolidate Apps Script code health and sheet growth alerts by running a scheduled Monday hygiene sweep. This merges ES5 violations, runaway sheet growth, and trigger headroom signals into one actionable Pushover notification and Notion log entry.

Does this scheduled audit work without external dependencies or API keys?▼

This scheduled audit runs entirely within the Google Apps Script environment without external dependencies. It scans the existing TBM codebase and Google Sheets directly, requiring only configured Pushover and Notion endpoints for notifications and logging.

Related Skills

Explore More Software Engineering Skills→
masharrattmasharratt
14

google-sheets-api-coordinator

Coordinate Google Sheets API calls with rate limiting and quota tracking.

Community
Intermediate
oteroweboteroweb

context-cleanup-steward

Reconcile repo docs, code, routes, Notion tickets, Drive context, and Stitch references.

Community
Advanced
temple-slopetemple-slope

recipe-create-events-from-sheet

Read Google Sheets rows and create Google Calendar events with summary, start time, duration, and attendees.

Community
Intermediate
tanapachatanapacha

kiddo-learning

Deploy a serverless LMS using Google Apps Script and Google Sheets.

Community
Advanced