Danil Sidorov
RU EN DE
Telegram

Telegram bot for event reminders

A web app with a Telegram bot that sends reminders about upcoming events based on user roles

Чат-боты / Автоматизация

Live interactive demo stand

An exact copy of the project interface and business logic with demo data. All actions run in real time.

График из Excel сам превращается в напоминания по ролям

StackPython, Django, python-telegram-bot, Celery, Redis, pandas

Safe perimeter (NDA): production logic on test data

What to test in the stand:
  1. Загрузите расписание корпоративных событий из файла Excel
  2. Зарегистрируйте тестового сотрудника под выбранной ролью
  3. Запустите Celery Beat задачу и получите целевое напоминание в чате
https://notify-bot.app/admin/users/event/
Live Stand
☰Началоadmin

Мероприятия

НачалоНастройки телеграм ботаМероприятия
IDЗаголовокТекстДата событияКомпания
У
Бот уведомленийбот

Turnkey implementation

Need a similar system for your business processes?

I will develop the architecture, fault-tolerant backend, and fast interface. Protected by NDA, clean transferable code, and transparent milestones.

  1. Free timeline and budget estimate within one day
  2. Contract and invoice
  3. Warranty and post-launch support

On weekdays usually within a couple of hours

I will reply personally, no aggressive sales pitch

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

Danil Sidorov
Danil Sidorov Project developer

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

Tell me about your task

Telegram