Automated Telegram alerting system that eliminated redundant manual new-member dispatches and instituted a timestamped Google Sheets audit log.
New-member follow-up at Word Study was entirely manual — someone had to check for new members and personally dispatch that information to the right person. The goal was to remove that redundant step without adding complexity.
Connected incoming member data to Telegram via Google Apps Script, so the team is notified automatically the moment a new member comes in.
Iterated across nine versions (v2.1 through the v6.5 Gold Master), resolving race conditions and adding validation to prevent duplicate alerts.
Every trigger is logged to Google Sheets, giving a running, timestamped record of exactly when the bot fired and what it sent.
The Dispatch Bot replaced a manual, easy-to-drop task with an automatic one — a small, reliable piece of infrastructure rather than a flashy feature.
New-member follow-up no longer depends on someone remembering to check and manually forward information — the alert fires on its own, and every instance is logged for reference. The team's follow-up bottleneck measurably eased as a result, even though the underlying problem it solved was never a crisis — just a redundant task that quietly ate time until it was automated away.
A minimalist, distraction-free publishing site built around disciplined typography and lightweight front-end execution for an independent author.