Monthly Google Calendar Absence Collector
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.
Related Travel workflows
- Webhook Filter Sync for Accommodation Booking$6.99
- Automate Flight Searches and Recommendations with DeepSeek AI and Google Flights$4.99
- Daily Weather Forecast Emails with MeteoSource and Gmail$4.99
- Automate Airbnb Searches via Telegram with AI and Voice Support$9.99
- Automate Daily Weather Updates via Telegram Using OpenWeatherMap$9.99
- Automate Flight Price Tracking with Bright Data and n8n$9.99
More from Bryce Yu
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.