Automate Weekly Student Reports with Gemini & WhatsApp Alerts

Automate Weekly Student Reports with Gemini & WhatsApp Alerts

Streamline your educational institution's reporting process with our robust n8n workflow. This automation effortlessly gathers and analyzes student data, enabling proactive communication and performance management. Each week, it extracts attendance and scores, crafts insightful summaries using Google Gemini, and triggers immediate alerts via WhatsApp for students needing attention, ensuring timely responses and comprehensive overviews.

What This Workflow Does

• Runs automatically each week on a pre-set schedule.
• Fetches student attendance records and score data directly from Supabase.
• Utilizes Google Gemini to create concise performance summaries for each student and identifies those who require additional attention based on specific attendance or performance drop-off rules.
• Dispatches real-time WhatsApp alerts to coaches for students flagged for attention, and logs these flags in Supabase.
• Compiles individual performance summaries into a comprehensive HTML weekly report.
• Converts the HTML report into a PDF using an HTTP-based HTML-to-PDF API, uploads it to a designated file-hosting service, and sends the downloadable PDF link to the coach via WhatsApp.
• Records the report URL in Supabase for seamless tracking and recordkeeping.

Use Cases

• Educational institutions aiming to optimize student performance tracking and communication.
• Automation engineers seeking to enhance data-driven insights for education stakeholders.
• SaaS operators requiring efficient and accurate student monitoring and reporting processes.

Technical Details

• Integration with Supabase for data fetching and storage.
• Utilization of Google Gemini for generating performance summaries and attention flags.
• WhatsApp Business Cloud API to deliver urgent alerts and reports directly to coaches.
• Conversion from HTML to PDF through HTTP-based API for report generation.
• n8n workflow nodes include: if, set, code, supabase, WhatsApp, aggregate.