Ending the "Seminar Drama": How I Automated Schedule Alerts for 6 Majors

1. The Classic Final-Year Struggle

At ITERA, you must attend 10 student seminars before you can register your own. The problem? Schedules usually spread through random WhatsApp rumors or last-minute texts, causing students to constantly miss them.

The data actually exists in department Google Sheets, but checking them manually is a tedious, all-day task. I realized it was time to make the data work for us, rather than the other way around.

2. Taming the Data Chaos

Syncing schedules across six different majors meant dealing with incredibly messy data. Every department had its own way of typing—resulting in typos, weird punctuation, and over 15 different date and time formats.

To fix this, I built a Smart Parser. It automatically cleans the chaos, standardizes the text, and even extracts student IDs hidden inside multi-row entries. It turns completely raw, messy inputs into clean, machine-ready data.

3. Zero Spam: The Secret to User Trust

Nobody likes a spammy bot. If an automation sends duplicate messages, people will just mute the group. To prevent this, I gave the system a "memory."

Every time the bot spots a schedule, it generates a unique digital fingerprint. Before sending a Telegram alert, it checks its memory:

• Already exists? Skip it.
• Brand new? Send the alert and save the fingerprint.

This guarantees students only get notified about new seminars or real schedule changes.

4. Built to Scale

I didn't want to rewrite the entire codebase every time a new major wanted to join the system. Instead, I used a Builder Pattern.

Now, if a new department wants in, I just update a tiny config file to tell the system where to look for names and titles. A script generates the rest of the workflow automatically, allowing the system to scale without extra heavy lifting.

5. From Spreadsheet to Digital Assistant

This automation doesn't just send texts; it acts as a personal digital assistant. When a new seminar is found, the system does two things:

1. Telegram Alert: Sends a clean message with the thesis title, supervisors, and an invite link.
2. Google Calendar: Automatically creates an event with all the necessary details.

The best part is the Morning Reminder. Every day at 5:30 AM, students get a daily digest of the seminars happening that day. No more "I forgot to check the group" excuses.

6. Tech for Real Life

This project proved that data science and automation aren't just for fancy labs. Sometimes, the biggest impact comes from solving the annoying, everyday administrative headaches right in front of us.

The bot now runs 24/7. With the scheduling drama handled by robots, students can finally focus on what matters: finishing their thesis and graduating.