CASE STUDY · automation · 2026

Apollo Bot

Telegram journaling assistant — daily check-ins, finance tracking, calm scoring, and weekly wiki sync.

personal Telegram bot that runs my daily life. It conducts a structured journal session each morning, extracts finance transactions, tracks emotional tone via a calm-score algorithm, and syncs the week's data into my Personal OS wiki. Backed by Claude (claude-sonnet-4-6) for extraction and synthesis. Webhook-based with a Supabase backend.

highlights

+Multi-session daily archive with empty-transcript anti-clobber guard
+Finance insight extractor: structural facts only → open_signals → promotes to wiki
+Calm tracker: mood scoring across session turns
+Weekly self-audit: diffs chat vs DB, pings on dropped rows

what was hard

Relative date cues: cue anchor must stay relative to real speaking moment, not session logical day; Duplicate signal dedup: day-clear rebuild pattern with pure-producing extractors