Back to Templates
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:
Main Components
Essential Prerequisites
Required Data Files:
class_schedule.xlsx:
student_contacts.xlsx:
reminder_log.xlsx:
Key Features
Quick Setup
Parameters to Configure
schedule_file_path
: Path to class schedule filecontacts_file_path
: Path to student contacts filegoogle_calendar_id
: Google Calendar ID for syncinggoogle_api_credentials
: Google Calendar API credentialssmtp_host
: Email server settingssmtp_user
: Email usernamesmtp_password
: Email passwordsms_api_key
: SMS service API keysms_phone_number
: SMS sender phone numberSample Reminder Messages
Use Cases