Report overlapping Google Calendar appointments by email with Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Calendar and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Configure calendar and report (Edit Fields (Set)): sets 6 fields: demo_mode, calendar_id, recipient_email…
- Validate audit settings (Code): runs custom JavaScript code
- Use fictional appointments? (If): checks a condition and branches into true / false
- Build fictional appointments (Code): runs custom JavaScript code
- Read upcoming calendar appointments (Google Calendar): get many
- Find timed appointment overlaps (Code): runs custom JavaScript code
- Send a live attention report? (If): checks a condition and branches into true / false
- Email the internal calendar owner (Gmail): send (message)
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Calendar
n8n-nodes-base.googleCalendar - Gmail
n8n-nodes-base.gmail - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview Checks one Google Calendar for overlapping timed appointments and prepares an email report for its owner. It starts with a fictional example you can run without Google credentials. In live mode, Gmail sends a report when a clash or invalid date…