Collect student absence reasons via WhatsApp, Google Sheets, Gemini, and Redis
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 41 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects WhatsApp Business Cloud, Google Sheets, Redis and Google Gemini Chat Model and 1 more.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Retrieve Absent Students from Sheets (Google Sheets): uses Google Sheets
- Set Message Details (Edit Fields (Set)): sets or maps fields
- Check If Reason is Missing (If): checks a condition and branches into true / false
- Verify Message Contains Text (If): checks a condition and branches into true / false
- Send Absence Notice on WhatsApp (WhatsApp Business Cloud): uses WhatsApp Business Cloud
- Confirm Message is Text Type (If): checks a condition and branches into true / false
- Store Notice in Redis (Redis): uses Redis
- Verify Dedup Key in Redis (Redis): uses Redis
- Warn Non-Text Message on WhatsApp (WhatsApp Business Cloud): uses WhatsApp Business Cloud
- Determine Message Duplication (If): checks a condition and branches into true / false
…plus 23 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Redis
n8n-nodes-base.redis - Edit Fields (Set)
n8n-nodes-base.set - No Operation, do nothing
n8n-nodes-base.noOp - Wait
n8n-nodes-base.wait - WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Redis Chat Memory
@n8n/n8n-nodes-langchain.memoryRedisChat
From the author
Quick overview Youtube Video: https://youtu.be/Bn1u3pc0Lpo This workflow checks a Google Sheets attendance tracker every day and messages parents of absent students via WhatsApp, then uses Google Gemini plus Redis-based deduplication, buffering, and chat…