Class reminders for tomorrow on WhatsApp
Every evening, remind students (or their parents) about tomorrow's class: course, time and place.
How it works
Trigger: Schedule — every day at 18:00
- Read the Sessions sheet (date, time, course, student, phone, location).
- Keep tomorrow's sessions.
- Send each student a WhatsApp template with the course, time and location.
Diagram
Trigger App Code
Code
JavaScript used in the Code step — already included in the template below.
// Sessions sheet columns: date (YYYY-MM-DD) | time | course | student | parent_phone | location
// Keeps tomorrow's sessions that have a phone number.
const tomorrow = new Date(Date.now() + 24 * 60 * 60 * 1000).toISOString().slice(0, 10);
return $input.all()
.map((item) => item.json)
.filter((s) => String(s.date).slice(0, 10) === tomorrow && s.parent_phone)
.map((s) => ({
json: {
phone: String(s.parent_phone).replace(/[^0-9]/g, ""),
student: s.student,
course: s.course,
time: s.time,
location: s.location || "online",
},
}));Build it
Pick your tool — same automation, step by step.
Copy and paste straight into an n8n canvas (Ctrl+V), or download and use Import from File. Then connect your own credentials and replace every YOUR_… placeholder.
Show code (162 lines)
{
"name": "Class reminders for tomorrow on WhatsApp (Flowngn)",
"nodes": [
{
"parameters": {
"content": "## Class reminders for tomorrow on WhatsApp\nEvery evening, remind students (or their parents) about tomorrow's class: course, time and place.\n\n**Setup**\n1. Open each node and connect your own credentials.\n2. Replace every YOUR_… placeholder.\n3. Test once, then activate.\n\nFree template from Flowngn",
"height": 260,
"width": 340
},
"id": "2c52a72d-5fca-44f4-aa39-2f513d8b72a5",
"name": "Setup notes",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-420,
-60
]
},
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 18
}
]
}
},
"id": "2c52a72d-5fca-44f4-aa39-2f513d8b72a5",
"name": "Every day 18:00",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
0,
0
]
},
{
"parameters": {
"operation": "read",
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Sessions",
"mode": "name"
},
"options": {}
},
"id": "2c52a72d-5fca-44f4-aa39-2f513d8b72a5",
"name": "Read sessions",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
300,
0
]
},
{
"parameters": {
"jsCode": "// Sessions sheet columns: date (YYYY-MM-DD) | time | course | student | parent_phone | location\n// Keeps tomorrow's sessions that have a phone number.\nconst tomorrow = new Date(Date.now() + 24 * 60 * 60 * 1000).toISOString().slice(0, 10);\n\nreturn $input.all()\n .map((item) => item.json)\n .filter((s) => String(s.date).slice(0, 10) === tomorrow && s.parent_phone)\n .map((s) => ({\n json: {\n phone: String(s.parent_phone).replace(/[^0-9]/g, \"\"),\n student: s.student,\n course: s.course,\n time: s.time,\n location: s.location || \"online\",\n },\n }));"
},
"id": "2c52a72d-5fca-44f4-aa39-2f513d8b72a5",
"name": "Tomorrow's sessions",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
600,
0
]
},
{
"parameters": {
"operation": "sendTemplate",
"phoneNumberId": "YOUR_PHONE_NUMBER_ID",
"recipientPhoneNumber": "={{ $json.phone }}",
"template": "YOUR_CLASS_REMINDER_TEMPLATE|ar",
"components": {
"component": [
{
"type": "body",
"bodyParameters": {
"parameter": [
{
"type": "text",
"text": "={{ $json.student }}"
},
{
"type": "text",
"text": "={{ $json.course }}"
},
{
"type": "text",
"text": "={{ $json.time }}"
},
{
"type": "text",
"text": "={{ $json.location }}"
}
]
}
}
]
}
},
"id": "2c52a72d-5fca-44f4-aa39-2f513d8b72a5",
"name": "Send reminder",
"type": "n8n-nodes-base.whatsApp",
"typeVersion": 1,
"position": [
900,
0
]
}
],
"connections": {
"Every day 18:00": {
"main": [
[
{
"node": "Read sessions",
"type": "main",
"index": 0
}
]
]
},
"Read sessions": {
"main": [
[
{
"node": "Tomorrow's sessions",
"type": "main",
"index": 0
}
]
]
},
"Tomorrow's sessions": {
"main": [
[
{
"node": "Send reminder",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"meta": {
"templateCredsSetupCompleted": false
},
"tags": []
}In Make, create a new scenario and add these modules in order:
- Schedule the scenario: Every day 18:00
- Google Sheets › Search Rows
- Tools › Set variable / Iterator + Array aggregator (same logic as the Code step)
- WhatsApp Business Cloud › Send a Template Message
- Every module run uses Make operations — the free plan includes a monthly quota.
- Make's built-in functions (map, sum, formatDate…) can replace most Code steps; for complex logic use a code module.
- Module and step names can differ slightly as Make and Zapier update their apps.
In Zapier, create a new Zap and add these steps in order:
- Schedule by Zapier — Every day 18:00
- Google Sheets — Lookup Spreadsheet Rows (or Code by Zapier)
- Code by Zapier — Run JavaScript (paste the code from the Code section)
- WhatsApp — Send Template Message
- Zaps with more than two steps need a paid Zapier plan.
- Webhooks, Filters/Paths and Code by Zapier are premium features on some Zapier plans.
- Code by Zapier runs JavaScript: reuse the code shown above, reading inputs from inputData instead of $json.
- Module and step names can differ slightly as Make and Zapier update their apps.
Tips
- For online classes, put the meeting link in the location column.
Related flows
Education & TrainingEasy
Tell parents on WhatsApp when a student is absent
When a teacher marks a student absent in the attendance sheet, the parent gets a WhatsApp message right away.
Google Sheets → WhatsApp6h/mo
Education & TrainingEasy
Email students their Google Forms quiz score
As soon as a student submits a Google Forms quiz, they get an email with their score and a link to review.
Google Sheets → Gmail2h/mo
Education & TrainingEasy
Email certificates when a student finishes a course
Mark a student as completed in a sheet and they get a congratulations email with their certificate link.
Google Sheets → Gmail3h/mo