Education

Student Absence WhatsApp Alerts

When attendance is recorded, parents of absent students get an instant WhatsApp alert with a form to share the reason. Notification status is tracked in Google Sheets.

The Student Absence WhatsApp Alerts workflow on the n8n canvas, with its 14 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
Education
Nodes
14
Apps
Google Sheets, Google Forms
Price
Free
Download JSON
On this page

How it works

  1. A one-time setup creates the attendance form and sheet.
  2. New attendance entries start the workflow.
  3. Absent students are filtered and the parent's contact is looked up.
  4. A WhatsApp alert with a reason form is sent.
  5. The notification status is updated.

Use cases

  • Schools
  • Coaching classes
  • Day-care centers

What you need

This workflow connects to these apps.

  • n8n
  • Google Sheets
  • Google Forms

You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.

  • Google Sheets Trigger account
  • Google Sheets account
  • Google account
  • Http Header Auth account
  • Twilio account

Data setup

Create these tables with these exact column names before the first run.

TableColumns
Attendance Tracking + Parent Alerts → StudentsGoogle SheetsRollNoClass
Attendance Tracking + Parent Alerts → AttendanceGoogle SheetsRowIDNotificationStatusSentAt

Setup

  1. Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.

Nodes

NodeType
Lookup Parent ContactgoogleSheets
Build WhatsApp Messagecode
Send WhatsApp Alerttwilio
Update Notification StatusgoogleSheets
Structure Attendance Datacode
Check Absent Statusif
Loop Attendance DatasplitInBatches
Trigger New Attendance AddgoogleSheetsTrigger
Add Student DatahttpRequest
When clicking ‘Execute workflow’manualTrigger
Create FormhttpRequest

Frequently asked questions

When attendance is recorded, parents of absent students get an instant WhatsApp alert with a form to share the reason. Notification status is tracked in Google Sheets. It's a 14-node n8n workflow.

An n8n instance, on n8n Cloud or self-hosted, and credentials for Google Sheets, Google, HTTP, and Twilio. It uses only nodes that ship with n8n, so there's nothing else to install.

It works with 2 tables in Google Sheets. Create them with the column names listed under Data setup on this page before the first run.

Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.

Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.

Keep exploring
  • n8n canvas of the OMR Answer Sheet Auto-Grader workflow

    Education9 nodes

    OMR Answer Sheet Auto-Grader

    Upload a photo of an OMR sheet and get the score back instantly. AI vision reads the marked answers, they're compared with the answer key, and the result is saved to Google Sheets.

  • n8n canvas of the PDF to Google Forms Quiz Generator workflow

    Education12 nodes

    PDF to Google Forms Quiz Generator

    Upload study material as a PDF and get a ready-to-share Google Forms quiz. AI writes the multiple-choice questions, answers and marks, and a copy of every question is saved to Google Sheets.

  • n8n canvas of the Student Fee Reminders with Stripe Payment Links workflow

    Education27 nodes

    Student Fee Reminders with Stripe Payment Links

    Sends staged WhatsApp fee reminders to parents with a Stripe payment link. When payment is made, the record is updated, a receipt PDF is generated and the receipt is shared.