monthly-health-and-structure

Audit Google Apps Script codebases, Sheets quotas, and Notion structure monthly.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/blucsigma05/tbm-apps-script --skill monthly-health-and-structure
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: monthly-health-and-structure
Source: https://github.com/blucsigma05/tbm-apps-script/tree/main/.claude/scheduled-tasks/monthly-health-and-structure
Command: npx skills add https://github.com/blucsigma05/tbm-apps-script --skill monthly-health-and-structure

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Monthly audits prevent silent failures and performance regressions by catching code, data, and documentation drift before it impacts the household finance dashboards and chore/education workflows.

Core Features & Use Cases

  • Architecture review for GAS code safety: counts functions per .gs file, detects duplicate function-name collisions across files, checks module ownership boundaries, and flags dead private functions.
  • Dependency and quota health checks: monitors execution quota usage, trigger counts and headroom, flags large sheet row counts nearing performance thresholds, and estimates CacheService usage (key count/bytes).
  • Notion structure governance: audits PM page tree and ordering, verifies the Active Versions DB matches deployed versions, finds orphaned pages, checks scheduled-task drift against local schedule inventory, and flags stale integration-map entries.

Quick Start

Run the monthly-health-and-structure skill to produce a dated Notion child-page audit and send push notifications with severity escalation when quotas or data sizes cross safety thresholds.

Frequently Asked Questions about monthly-health-and-structure

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

FAQPage Schema
How do I audit Google Apps Script code health and prevent silent failures?

To audit Google Apps Script code health and prevent silent failures, run a monthly consolidated check that counts functions per .gs file, detects duplicate function-name collisions across files, and flags dead private functions before they impact your workflows.

How do I monitor Google Sheets quota usage and trigger headroom for Apps Script?

To monitor Google Sheets quota usage and trigger headroom, you can run a monthly audit that checks execution quotas, validates trigger counts, flags large sheet row counts nearing performance thresholds, and escalates to system errors when configured safety limits are exceeded.

What is the best way to detect scheduled task drift and orphaned pages in Notion?

The best way to detect scheduled task drift and orphaned pages in Notion is to perform a monthly structure governance audit that checks the page tree, verifies scheduled tasks against local inventory, and flags stale integration-map entries.

Can I automate monthly code and data structure audits to send Pushover notifications?

Yes, you can automate monthly code and data structure audits to send Pushover notifications by applying the audit on the first day of the month, generating a dated Notion child page, and summarizing results with defined severity priorities.

When do I need to check Google Apps Script module ownership boundaries?

You need to check Google Apps Script module ownership boundaries during a monthly architecture review to catch code, data, and documentation drift before it impacts household finance dashboards and chore or education workflows.

Why does my Google Apps Script performance degrade when sheet row counts increase?

Your Google Apps Script performance degrades when sheet row counts increase because large datasets approach performance thresholds, which a monthly health audit can flag early by monitoring row growth and estimating CacheService usage to prevent regressions.