Task
In the organization, event reminders got lost in group chats. Nobody read them, the right people did not get the information, and not everyone came to events.
Solution
I connected a Django backend to a Telegram bot. Events and roles are created in the admin panel, and the bot sends reminders only to the right groups and at a set time before the start. The content manager edits the texts and schedule without asking a developer.
What was done
- Connected a Django backend to a Telegram reminder bot
- Added reminders sent by role to the right groups
- Set up reminders a set time before each event
- Moved events, roles and texts into the admin panel for the content manager
- Wrote the documentation
Result
Reminders no longer get lost in group chats and reach the right people by role. The client now manages events in the admin panel without a developer.
Developer's note
What was hard
The main difficulty was reliably importing schedules from unstructured Excel files. Department managers frequently submitted spreadsheets with inconsistent formatting, merged cells, typos in role titles, and empty rows between days. I had to build a strict validator using openpyxl, normalize dates, and map raw column headers against the database role directory so that a single corrupted cell would not halt the entire month import and would clearly highlight the exact error in the admin panel.
Another challenge involved Celery delivery queues and strict Telegram API rate limits. When dispatching hundreds of reminders simultaneously, the bot hit the platform limit of thirty messages per second, while some employees had blocked the bot or changed their usernames. I configured batch sending with dynamic throttling, handled user-blocked exceptions by flagging inactive accounts in the database, and routed retries into dedicated queues so background workers never stalled.
What came easy
Designing the database schema with Django ORM and customizing the Jazzmin admin interface came together quickly and smoothly. Connecting events, company profiles, and role-based permissions with automatic list filtering took just one evening, giving administrators a clean management workspace from day one.
Onboarding new employees directly inside the Telegram conversation using python-telegram-bot was also straightforward. The step-by-step registration flow with company branch selection and name confirmation mapped cleanly onto a simple state machine, leaving administrators with only a single click to approve the assigned role in the web panel without manual back-and-forth messaging.
Technologies
PythonDjangoTelegram Bot API