School: Absence Alerts

Every school morning it reads the attendance sheet, sends each absent student's parent a short Arabic WhatsApp message, and marks the row so no one is messaged twice. It never records the reason for absence.

Steps in this flow

  1. School days 9:30
  2. Google Sheets: unalerted absences
  3. For each absent student
  4. Parent phone present?
  5. WhatsApp alert to the parent
  6. Google Sheets: mark as alerted

All templates