# Monthly report of employee absences from Google Calendar sent to payroll via email
This automation workflow collects data on employee absences (holidays and illness) from the previous month via Google Calendar and automatically sends a structured summary to payroll by email. It simplifies salary calculations and eliminates manual reporting errors.
## Who it´s for
- HR specialists automating vacation and sick leave reporting
- Accountants receiving monthly summaries for payroll processing
- Personnel managers in companies with manual time tracking
## What the automation does
- Triggers on the 1st of each month at 8:00 AM via cron schedule
- Fetches calendar events from the previous month using Google Calendar API
- Filters events by ´Holiday´ or ´Illness´ in the event summary
- Extracts employee names and absence duration
- Aggregates days per person and groups the data
- Compiles a text-based report and sends it via email through SMTP
## What´s included
- Ready-to-use n8n workflow
- Trigger and filtering logic
- Integrations with Google Calendar API and SMTP
- Basic setup and adaptation guide
## Requirements for setup
- n8n instance (cloud or self-hosted)
- Access to Google Calendar with employee events
- SMTP server for email delivery
- Valid credentials for service connections in n8n
## Benefits and outcomes
- Saves time on manual data collection
- Reduces payroll calculation errors
- Ensures timely and consistent report delivery without HR involvement
- Increases transparency in absence tracking for accounting
- Easily scales with team size changes
- Zero monthly effort after initial setup
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet