TRIGGER_REGISTRY — every Apps Script time-trigger across all projects
Generated 2026-04-28 PM · in response to Apr 28 teardown: "Trigger chaos = uncontrolled automation = trust collapse."
Rule: before installing ANY new email/time-trigger, this registry must show every existing one. Delete duplicates. Confirm 48h clean. THEN add the new one.
Status as of generation: evidence of duplicate firing observed Apr 26-27 (5+ MIS Trade Action duplicates, 6 BOS emails in 60min, Architect V11 own Power Hour duplicates). Not safe to add new triggers until cleaned.
Known triggers (inferred — needs Sam validation in each Apps Script editor)
To populate this registry exhaustively, open each script's Apps Script editor → Triggers (clock icon, left sidebar) → list every row.
MIS — 1r9vWL1Ds... (bound to MIS_v7.1_gsheet)
Per MIS/src/emailDailySnapshot.js and observed inbox behavior:
| Function | Schedule (intended) | Schedule (observed) | Status |
|---|---|---|---|
| Morning Brief send | Mon-Fri 9:53 AM | Mon-Fri 9:53 AM (sometimes also 9:54, 12:25, 5:28) | ⚠ duplicates |
| Trade Action / Playbook send | Mon-Fri 2:05 PM | Apr 27: fired 2:08, 3:37, 4:04, 4:57, 5:18 PM (5 dupes) | 🚨 broken |
| Power Hour send | Mon-Fri 3:00 PM | Apr 27: 3:02 + 7:36 PM. Apr 28: 9:50 AM + 12:35 PM (early Sheet 3) | 🚨 broken |
| Sunday Week-Ahead | Sun ~6:05 PM | Sun 6:05 PM ✓ | ✓ working |
PROCESS_QUICK_CAPTURE (orphan) |
Apr 26 — Sam reported "Script function not found" error | n/a — orphan trigger from prior setup | 🪦 retire |
Architect V11 — 1MU_NiSnoVy... (separate sandbox sheet)
Per audit of Architect V11 (Microservices Edition) sheet:
| Function | Schedule | Status |
|---|---|---|
| Power Hour send (own engine) | Apr 27: 12:49, 12:56, 3:12 PM (already 3 fires) · Apr 28: 9:50 AM + 12:35 PM | 🚨 firing duplicates of MIS production's emails |
BOS v1 — 1_cgriwCQ... (bound to Monthly Obligations / HookStreet OS)
| Function | Schedule (intended) | Schedule (observed) | Status |
|---|---|---|---|
| Operations Summary | Sun 7:05 AM | ✓ working | ✓ |
| Daily Snapshot | Mon-Fri 7:40 AM | Apr 26: fired 8:34 + 8:35 PM (2 in 1 min on Sun) | 🚨 dedup needed |
| Weekly Review | Sun 7:53 AM | Apr 26: fired 9:22 + 9:35 PM (dupes) | 🚨 dedup needed |
| Quick Capture form processor | every 5 min | observed firing | ✓ working |
| BOS Daily Snapshot duplicates | 00:37, 00:43, 04:22, 04:48 AM (4 times daily) | per docs/MIS_AUDIT_2026-04-26.md |
🚨 needs retirement |
BOS v2 — 1ROnmAAhtTYE... (bound to Monthly Obligations v2)
| Function | Schedule | Status |
|---|---|---|
| Hookstreet OS — WEEKLY (Monthly Overview) | Sun ~7:54 AM | Apr 26: fired 8:55, 9:23, 9:36 PM (3 dupes) |
DASHBOARD_REFRESH |
manual / Sam-clicks | n/a |
CM Invoice — 1t4DzAQQ... (OLD FINAL) and 106wdSg6lMTsq... (NEW v2)
| Function | Schedule | Status |
|---|---|---|
_dailyArDigest_ (Daily AR Digest) |
Daily 8 AM | NOT YET INSTALLED on either sheet |
_weeklySaturdaySummary_ (Weekly Summary) |
Sat 8 PM | NOT YET INSTALLED |
onEdit (live trigger, not time) |
per cell edit | always available |
onOpen (live trigger, not time) |
per sheet open | always available |
Voice Intake — hookstreet-voice-intake (separate repo, not yet deployed)
| Function | Schedule (intended) | Status |
|---|---|---|
| Gmail intake processor | every 5 min, scans [INTAKE-V1] label |
NOT YET DEPLOYED |
Cleanup plan (Sam approval required before any deletion)
Phase A — Document (this file). ✓ done.
Phase B — Sam runs Apps Script trigger inventory. For each script project:
1. Open Apps Script editor (links below)
2. Click clock icon (Triggers) in left sidebar
3. Screenshot or copy/paste every row
4. Send to Claude
Phase C — Diff actual vs intended. Claude compares Sam's screenshots against this registry. Flags duplicates + orphans.
Phase D — Approve deletes. Sam reviews + approves each delete.
Phase E — Execute. Inside each script editor: Delete All Project Triggers button (custom function in code) OR delete one-by-one in UI.
Phase F — Reinstall clean. Run Create Default Triggers (custom function). Verify 48h.
Phase G — Update this registry. Status flips to ✓ working.
Apps Script editor links (for Phase B)
| Project | Editor URL |
|---|---|
| MIS | https://script.google.com/d/1r9vWL1DsqSloDL8OteFNekkDZihFw_5jtTBSJ0UjbEigwRxGlILtUzbI/edit |
| Architect V11 | (open the sheet 1MU_NiSnoVy_SSf3Cldli9YfuQ-cckcntjlcCqefNKRw → Extensions → Apps Script) |
| BOS v1 | https://script.google.com/d/1_cgriwCQ.../edit (full ID in CLAUDE.md ACTIVE SYSTEMS) |
| BOS v2 | https://script.google.com/d/1ROnmAAhtTYE.../edit |
| CM Invoice OLD (FINAL) | https://script.google.com/d/1t4DzAQQvGd9U5phFoQdXzRyperrSZwrICRFFDQjbVi3MKdQ5PEy4xk-V/edit |
| CM Invoice NEW (v2) | https://script.google.com/d/106wdSg6lMTsqBaGBtH93j_D0AbSrjUtKuRM2WzdjKE7tq5Vqbe1ZQPAp/edit |
Until cleanup completes — RULE
🛑 No new email automations install until this registry is filled in with Sam's screenshots and duplicates are deleted. That includes:
- Daily AR Digest in CM Invoice
- Weekly Saturday Summary in CM Invoice
- News brief automation
- Voice intake deployment
- Any new MIS/BOS scheduled function
The teardown was specific: "Before any new feature, trigger discipline should be fixed. No new reports. No new dashboards. No new AI flows."
Phase B inventory complete — 2026-05-03 · 1:30 PM EDT (Session 22)
Sam screenshotted all 8 script projects. Result is FAR cleaner than the Apr 28 inferred state. Only one project has actual problems.
Verified live triggers (from Sam's screenshots)
| Project | Trigger count | State | Notes |
|---|---|---|---|
BOS v1 (1_cgriwCQ) |
7 | ✅ All 0% error | Matches CREATE_DEFAULT_TRIGGERS() exactly: PROCESS_QUICK_CAPTURE (time + onSubmit), DAILY_SEND, OPERATIONS_SUMMARY_SEND, MILDRED_START_BUILD, MONTHLY_SEND, WEEKLY_SEND |
BOS v2 (1ROnmAAhtTYE) |
6 | 🚨 2 failing 100% | DAILY_SEND failing every fire, PROCESS_QUICK_CAPTURE Time-based failing every fire. Need execution stack traces to decide kill vs fix. |
Quick Capture (1v2i7D7o) |
2 | ✅ 0% error | sendReportNow (time-based, nightly 12:24 AM) + checkBatchSize (onSubmit). Works. |
MIS production (1r9vWL1Ds) |
7 | ✅ All 0% error | Earlier Apr 27 5x Trade Action duplicate spam appears self-resolved (no rogue trigger present today). |
Operating OS v1 (1h_DCul) |
0 | ✅ Silent | Bound script with code but no scheduled fires |
HS Unified (1gWmXugY) |
0 | ✅ Silent | Same |
Daily Tracker (1NiGxw0) |
0 | ✅ Silent | Same |
Artist Travel (1B-6Htby) |
0 | ✅ Silent | Same |
Command Center Rebuilt (18WtehG4) |
0 | ✅ Silent | New Apr 26, no triggers attached |
| Architect V11 (own sheet's script) | 0 | ✅ Silent | The earlier (May 3 11:30 AM) MIS-MAP draft flagged this as the source of weekend Power Hour emails — appears to have been cleaned already. |
Confirmed redundancies (small, contained)
- PROCESS_QUICK_CAPTURE in BOTH BOS v1 (working) and BOS v2 (failing 100%) — kill v2's once we see the error stack.
- MILDRED_START_BUILD in BOTH BOS v1 (7:23 AM, working) and BOS v2 (7:34 AM, working) — does Mildred get one daily briefing or two? Open question. If two, kill one. If two emails are deliberate (different content), document why.
MIS production weekend-firing flag (cosmetic, low priority)
3 of MIS's 7 triggers have NO weekday gate: misRunOpenSnapshot945, misSendMorningBrief, misRunMiddayRefresh1200 — all fired Sun May 3 morning despite markets being closed. Other 4 (misSendPlaybook205, misSendPowerHour300, misRunEODArchive545, misSendSundayWeekAhead) correctly skipped Saturday. Decision: add if (day === 0 || day === 6) return; to the 3 weekend-firing functions OR accept silent weekend fires.
Remaining diagnostic step (BLOCKING for v2 cleanup)
🔴 Need: BOS v2 failed-execution stack traces. Open https://script.google.com/u/0/home/projects/1ROnmAAhtTYEXfNoSnmrtBQdUwymGqejdxoXJHemYuqeKv4pIvz_3R34s/executions → filter Status = Failed → screenshot top 2.
Once that's in hand: 10-min code change to either fix or delete the failing v2 triggers + decide MILDRED_START_BUILD duplicate.
ZW_OS_GOOGLE_FIX_v2 (1YwwDx)
No script. Excel-imported sheet. Recommend: move to a Drive/MIS-archive/ or Drive/legacy-sheets/ folder. No risk of firing anything.
Last updated: 2026-05-03 · 1:30 PM EDT · Phase B complete · Status: BOS v2 errors pending; remainder verified clean