Who’s it for
Remote and distributed teams that schedule across time zones and want to avoid meetings landing on public holidays—PMs, CS/AM teams, and ops leads who own cross-regional calendars.
What it does / How it works
The workflow checks next week’s Google Calendar events, compares event dates against public holidays for selected country codes, and produces a single Slack digest with any conflicts plus suggested alternative dates. Core steps: Workflow Configuration (Set) → Fetch Public Holidays (via a public holiday API such as Calendarific/Nager.Date) → Get Next Week Calendar Events (Google Calendar) → Detect Holiday Conflicts (compare dates) → Generate Reschedule Suggestions (find nearest business day that isn’t a holiday/weekend) → Format Slack Digest → Post Slack Digest.
How to set up
Open Workflow Configuration (Set) and edit: countryCodes, calendarId, slackChannel, nextWeekStart, nextWeekEnd.
Connect your own Google Calendar and Slack credentials in n8n (no hardcoded keys).
(Optional) Adjust the Trigger to run daily or only on Mondays.
Requirements
n8n (Cloud or self-hosted)
Google Calendar read access to the target calendar
Slack app with permission to post to the chosen channel
A public-holiday API (no secrets needed for Nager.Date; Calendarific requires an API key)
How to customize the workflow
Time window: Change nextWeekStart/End to scan a different period.
Holiday sources: Add or swap APIs; merge multiple regions.
Suggestion logic: Tweak the look-ahead window or rules (e.g., skip Fridays).
Output: Post per-calendar messages, DM owners, or create tentative reschedule events automatically.