Automates scanning of Google Calendars on the 1st of each month at 8am for Holiday or Illness events, aggregates counts per person, and emails a summary report.
This workflow triggers every 1st of the month at 8am to review the previous month's Google Calendar events. It queries specified calendars for events containing 'Holiday' or 'Illness' in the summary, filters them via a Switch node, and merges counts for each team member.
A comprehensive email report is then sent with the aggregated absence data, making it easy to track team availability without manual checks. Setup requires Google Calendar credentials, calendar ID selection, and email node conf
Platform
n8n
Category
Travel
Price
$12.99
Creator
Bryce Yu
Google Calendar
Absences
HR Automation
Productivity
Email Reports
Scheduling
Team Management
Holidays
Illness Tracking
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.