Use Cases
- Automate monthly absence reporting for HR departments
- Streamline communication of employee leave to payroll teams
- Reduce manual tracking of employee illness and holiday records
How It Works
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
Setup Steps
- 1Import the workflow template into n8n
- 2Connect your Google Calendar account
- 3Set up the email credentials for sending reports
- 4Select the appropriate Google Calendar for absence events
- 5Activate the workflow to start automated reporting
Apps Used
Google Calendar
Categories
Target Roles
Industries
Tags
#email automation
#process automation
#workflow management