This workflow automates the process of managing student class schedules and sending timely reminders via email or SMS. It helps educational institutions streamline communication, reduce manual effort, and ensure students are well-informed about their classes.

Here’s how it works:

1. Trigger: The workflow starts with a daily schedule check via a cron trigger.

2. Schedule Retrieval: It reads the class schedule from an Excel sheet stored on Microsoft Excel, capturing all upcoming classes.

3. Filtering: It filters classes scheduled for today and prepares for future evening sessions.

4. Student Data: It reads student contact details, including emails and phone numbers.

5. Reminder Creation: For each relevant class, it creates personalized reminder messages for students enrolled in those classes.

6. Calendar Sync: It updates Google Calendar with the class schedule for easy access.

7. Notification Dispatch: Depending on the student’s preferred contact method, it sends reminders via email or SMS, formatted with clear and engaging HTML templates.

8. Logging: It logs all sent reminders into an Excel sheet for tracking.

This automation is perfect for educational institutions looking to enhance communication efficiency, improve student punctuality, and automate routine scheduling and notification tasks.