SRT Monitor
Match monitoring, Slack alerts, operational reports, and self-diagnostics on Google Sheets + Apps Script.
- Problem
- Operators needed continuous visibility into scheduled matches, assignment state, and decoder health without opening dozens of sheets or missing Slack noise.
- Solution
- A modular Apps Script suite (19 deployable files) that cycles monitors, surfaces log viewers, helpdesk UI, decoder finder, and independent permissioned menus. Formula-owned columns stay untouched; secrets stay server-side.
- Tech
- Google Apps Script V8 · Google Sheets · HtmlService single-file UIs · Slack · static pre-deploy checks
- Impact
- One coherent operational surface for monitoring, alerting, and reporting. Versioned bundles, rollback tags, and runbooks so the system can be handed over safely. TODO: quantitative uptime / alert volume once approved for public use.