# Student Absence WhatsApp Alerts

**Category:** Education  
**Tools:** n8n, Google Sheets, Google Forms  
**Nodes:** 14  
**Built by:** Forgent Systems

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.

![Workflow](preview.webp)

## 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

## Data setup

**Google Sheets** (tab: columns)

- **Attendance Tracking + Parent Alerts → Students**: `RollNo`, `Class`
- **Attendance Tracking + Parent Alerts → Attendance**: `RowID`, `NotificationStatus`, `SentAt`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Google Sheets Trigger account
   - Google Sheets account
   - Google account
   - Http Header Auth account
   - Twilio account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Lookup Parent Contact** — `n8n-nodes-base.googleSheets`
- **Build WhatsApp Message** — `n8n-nodes-base.code`
- **Send WhatsApp Alert** — `n8n-nodes-base.twilio`
- **Update Notification Status** — `n8n-nodes-base.googleSheets`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Sticky Note2** — `n8n-nodes-base.stickyNote`
- **Structure Attendance Data** — `n8n-nodes-base.code`
- **Check Absent Status** — `n8n-nodes-base.if`
- **Loop Attendance Data** — `n8n-nodes-base.splitInBatches`
- **Trigger New Attendance Add** — `n8n-nodes-base.googleSheetsTrigger`
- **Sticky Note1** — `n8n-nodes-base.stickyNote`
- **Add Student Data** — `n8n-nodes-base.httpRequest`
- **When clicking ‘Execute workflow’** — `n8n-nodes-base.manualTrigger`
- **Create Form** — `n8n-nodes-base.httpRequest`
