Generate weekly student progress reports with Gemini, Supabase, and WhatsApp
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 15 nodes and runs on a schedule (every week at 18:00). Along the way it connects Supabase, Google Gemini Chat Model and WhatsApp Business Cloud.
How it runs
Trigger: On a schedule (every week at 18:00).
- Set Configuration (Edit Fields (Set)): sets 10 fields: coach_name, coach_notify_number, whatsapp_phone_number_id…
- Fetch Weekly Student Data (Supabase): get many
- Generate Student Summary (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini Chat Model; output parser: Summary Parser
- Needs Attention? (If): checks a condition and branches into true / false
- Aggregate: combines items into one
- Notify Coach - Student Needs Attention (WhatsApp Business Cloud): send
- Build Weekly Report HTML (Code): runs custom JavaScript code
- Log Flagged Student (Supabase): insert
- Generate Report PDF (HTTP Request): calls an HTTP API (POST)
- Upload Report PDF (HTTP Request): calls an HTTP API (POST)
…plus 2 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 (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Supabase
n8n-nodes-base.supabase - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - If
n8n-nodes-base.if - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Aggregate
n8n-nodes-base.aggregate - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview This workflow runs weekly to pull student attendance and score data from Supabase, uses Google Gemini to generate per-student performance summaries and attention flags, sends immediate WhatsApp alerts for flagged students, then compiles all…