This project is an AI-powered workflow automation system built with n8n to streamline student result processing, automate success notifications, and generate performance analytics for instructors.
The workflow receives a file containing student names, email addresses, and grades. It processes the records and separates successful students from those who did not pass, using a passing threshold of 50.
Key Features:
* Automated Data Processing: Reads and processes student records, including names, email addresses, and grades.
* Pass/Fail Filtering: Identifies students who scored above 50 as successful, according to the defined business rule.
* Automated Email Notifications: Sends personalized congratulations emails to successful students while excluding unsuccessful students from these notifications.
* Performance Analytics: Aggregates student results and calculates overall success and failure rates.
* AI-Powered Instructor Reports: Uses Google Gemini to help generate a summary of student performance and identify potential areas for improvement.
* Workflow Automation: Connects data processing, conditional filtering, email delivery, and AI-assisted reporting in one automated workflow.
Business Outcome:
The solution reduces repetitive administrative work, streamlines student communication, and gives instructors a clearer overview of class performance to support more informed decisions and targeted improvements.