Automated absence reporting from Google Calendar to email

• Automate monthly absence reporting for HR departments
• Streamline communication of employee leave to payroll teams
• Reduce manual tracking of employee illness and holiday records

Triggers on the 1st of every month at 8 AM Calculates the previous month’s date Retrieves events from Google Calendar within the specified date range Checks for events categorized as 'Holiday' or 'Illness' Filters and counts the number of days for each absence type Compiles a summary message of absences Sends the summary via email to the payroll team

1. 1
   Import the workflow template into n8n
2. 2
   Connect your Google Calendar account
3. 3
   Set up the email credentials for sending reports
4. 4
   Select the appropriate Google Calendar for absence events
5. 5
   Activate the workflow to start automated reporting