Automated Weekly Student Progress Reports for Parents

This n8n workflow automates the process of generating and sending weekly academic progress reports to parents. It pulls student data from Google Sheets, retrieves current week LMS academic data via API, analyzes the data (including grades, attendance, and assignments), and creates a comprehensive HTML report. The report is then emailed to parents with a copy of the report, and a log is maintained in Google Sheets. An admin summary is also sent to school administrators. The entire process is scheduled to run every Monday at 9 AM, ensuring timely and consistent communication of student progress.