EOW Bot — Team Weekly Digest Automation

What it does

Each week, team members submit a structured status update directly in Telegram — no spreadsheets and no manual follow-up. Submissions are edited with AI for clarity, written to a live dashboard and consolidated into a digest for senior leaders, including an automatically generated PowerPoint summary for stakeholder presentations.

Built for reliability, not just features

Much of the engineering work is deliberately invisible: file locking prevents race conditions during concurrent writes; retry logic handles unreliable external APIs; and a local pending-write queue ensures that a submission is never silently lost when the back end is temporarily unavailable. The scheduler also excludes colleagues who are on holiday or have already submitted. When the hosting server failed during an outage, I migrated the bot to a new server without losing data in transit.

A security review also identified a leaked service-account credential in the deployment pipeline. I rotated the key and introduced safeguards to prevent a recurrence.