Monthly Google Calendar Absence Collector

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 configuration.

Ideal for HR, managers, or remote teams to monitor absences efficiently, saving hours of manual spreadsheet work. Benefits include real-time insights into team holidays and illnesses, improved planning, and reduced administrative overhead. Use cases: small businesses, agencies, or any team using Google Workspace for scheduling.