{"product_id":"n8n-workflow-email-report-for-overlapping-google-calendar-events","title":"n8n Workflow: Email Report for Overlapping Google Calendar Events","description":"\u003ch3\u003eAutomatically detect overlapping Google Calendar events and email yourself a clear report\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks one Google Calendar for timed-appointment clashes, builds a plain-text overlap summary, and (in live mode) sends it via Gmail to the configured recipient—so you can fix scheduling conflicts fast.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand or on a schedule\u003c\/strong\u003e (e.g., every morning) to keep your calendar reviewed automatically.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates audit settings\u003c\/strong\u003e including calendar ID, recipient email, timezone, lookahead window, and report limits.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupports demo mode\u003c\/strong\u003e to generate fictional upcoming events so you can test everything without Google credentials. The included example produces a sample overlap.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches and expands events\u003c\/strong\u003e from Google Calendar in live mode, including recurring events, then prepares them for analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters events before checking overlaps\u003c\/strong\u003e by excluding cancelled, free (transparent), all-day, self-declined, and duplicate events.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects overlapping timed appointments\u003c\/strong\u003e by finding overlapping event pairs with valid timed dates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a text report\u003c\/strong\u003e with overlap counts, excluded events, and any events that could not be checked due to invalid timed dates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the report via Gmail (live mode only)\u003c\/strong\u003e when attention is needed; otherwise it outputs results for inspection.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePrevent double-booking by automatically reviewing your team’s or personal calendar each morning.\u003c\/li\u003e\n  \u003cli\u003eRun a no-credentials test first (demo mode), then switch to live mode to start alerting via email.\u003c\/li\u003e\n  \u003cli\u003eAudit calendar data quality by highlighting events with invalid timed dates that can’t be reliably checked.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e Google Calendar, Gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic nodes:\u003c\/strong\u003e if, set, code, no op, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecurring event handling:\u003c\/strong\u003e expands recurring events during the audit window\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReport behavior:\u003c\/strong\u003e demo mode runs without sending email; live mode sends a Gmail report when attention is required\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46159503851699,"sku":"N8N-20384","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/4ufgmlGk8x0L279-l6QdW_m2CLvJ8N.png?v=1791104870","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-email-report-for-overlapping-google-calendar-events","provider":"N8N Commerce","version":"1.0","type":"link"}