An automated Telegram dispatch bot built with Google Apps Script to notify fellowship leaders about incoming new members and log entries directly to Google Sheets.
New member follow up at Word Study originally required someone to check submitted forms and manually forward information to team leaders. This created delays whenever someone forgot to check. The goal was to automate notifications directly to Telegram and keep an audit log without managing dedicated servers.
Google Apps Script connects new member form submissions directly to the Telegram API, dispatching instant notifications to team coordinators.
Deduplication checks verify incoming submissions to prevent repeated alerts from multiple form entries or network retries.
A running audit log in Google Sheets automatically records every dispatch timestamp, giving team leaders a clear history of member notifications.
Automating a repetitive task with lightweight scripts removed an everyday operational bottleneck without introducing server maintenance overhead.
New member alerts now dispatch to Telegram automatically, and the team maintains a reliable log of all submissions with zero server upkeep.
A distraction-free portfolio space built for an independent author to showcase her written works and build a direct community with her readers and fanbase.