Class reminders: the timetable from a sheet — into the calendar and to students

Each day the scenario takes today's classes from the sheet, puts them into the calendar and sends students personal reminders by email or text.

  • The timetable is edited in a sheet — the rest happens by itself
  • Classes land in the calendar, not just in a chat
  • Each student gets their own channel: email or text
  • A send log: you can see who was notified and when
Set it upScriptera

How it works

To get Microsoft Excel 365 notifications in pruffme, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Daily Schedule Check
  2. Then: Read Class Schedule
  3. Then: Filter Today's Classes
  4. Check: Has Classes Today?
  5. If yes: Read Student Contacts
  6. Then: Create Student Reminders
  7. Check: Split Into Batches
  8. Check: Email or SMS?
  9. If yes: Prepare Email Reminders
  10. Then: Read Reminder Log
  11. Then: Update Reminder Log
  12. Then: Save Reminder Log
  13. If no: Prepare SMS Reminders
  14. Then: Sync to Google Calendar

You can launch this Microsoft Excel 365 + pruffme integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios