Class scheduling & reminders with Google Calendar, email & SMS notifications

This automated n8n workflow checks daily class schedules, syncs upcoming classes to Google Calendar, and sends reminder notifications to students via email or SMS. Perfect for educational institutions to keep students informed about their daily classes and schedule changes.

What This Workflow Does: - Automatically checks class schedules every day - Identifies today's classes and upcoming sessions - Syncs class information to Google Calendar - Sends personalized reminders to enrolled students - Tracks reminder delivery status and logs activities - Handles both email and SMS notification preferences

Main Components Daily Schedule Check - Triggers daily to check class schedules Read Class Schedule - Retrieves today's class schedule from database/Excel Filter Today's Classes - Identifies classes happening today Has Classes Today? - Checks if there are any classes scheduled Read Student Contacts - Gets student contact information for enrolled classes Sync to Google Calendar - Creates/updates events in Google Calendar Create Student Reminders - Generates personalized reminder messages Split Into Batches - Processes reminders in manageable batches Email or SMS? - Routes based on student communication preferences Prepare Email Reminders - Creates email reminder content Prepare SMS Reminders - Creates SMS reminder content Read Reminder Log - Checks previous reminder history Update Reminder Log - Records sent reminders Save Reminder Log - Saves updated log data

Essential Prerequisites Class schedule database/Excel file with student enrollments Student contact database with email and phone numbers Google Calendar API access and credentials SMTP server for email notifications SMS service provider (Twilio, etc.) for text reminders Reminder log file for tracking sent notifications

Required Data Files:

classschedule.xlsx: Class ID | Class Name | Date | Time | Duration Instructor | Room | Students Enrolled | Status

studentcontacts.xlsx: Student ID | Name | Email | Phone | Preferred Contact Program | Class IDs | Active Status

reminderlog.xlsx: Log ID | Date | Student ID | Class ID | Contact Method Status | Sent Time | Response