Automated Monthly Absence Summary Report

This n8n workflow automates the process of generating and sending a monthly summary of employee absences due to holidays and illnesses. It is triggered on the first day of every month at 8 AM. The workflow retrieves previous month events from Google Calendar, filters and counts holiday and illness days, and then compiles a detailed message. The message is formatted to include individual absence days for each employee and is automatically emailed to the payroll team, streamlining HR reporting and ensuring timely communication. This automation is ideal for HR teams seeking to simplify absence tracking and reporting each month without manual intervention.