Automated daily Outlook calendar meeting digest

Automated Daily Outlook Calendar Meeting Digest

Overall Goal This workflow automatically runs at a scheduled time (daily at 8 AM by default), calculates the current day's date range, fetches all calendar events from a specified Microsoft Outlook account for that day, formats these events into a user-friendly HTML email, and then sends this digest to a designated email address.

---

How it Works (Step-by-Step Breakdown):

Node: Schedule Trigger (Schedule Trigger Node) - Type: n8n-nodes-base.scheduleTrigger - Purpose: Automatically starts the workflow at a predefined time. - Configuration: - Rule > Interval > Trigger At Hour: 8 (Triggers every day at 8:00 AM according to the n8n server's timezone) - Output: Triggers the workflow execution at the scheduled time.

Node: Code (Code Node) - Type: n8n-nodes-base.code - Purpose: Dynamically calculates the start and end timestamps for "today," based on when the workflow is triggered. - Configuration (JS Code): - Gets the current date and time (workflow runtime). - Sets today to beginning of current day (00:00:00). - Sets tomorrow to beginning of next day (00:00:00). - Converts these to ISO string format (e.g., 2023-10-27T00:00:00Z). - Output: JSON object with today and tomorrow ISO date strings.

Node: Microsoft Outlook (Microsoft Outlook Node) - Type: n8n-nodes-base.microsoftOutlook - Purpose: Fetch calendar events from Outlook within the calculated date range. - Configuration: - Resource: Event - Filters (Custom): start/dateTime ge '{{$json.today}}' and start/dateTime lt '{{$json.tomorrow}}' (OData filter to fetch events starting on or after today and before tomorrow, i.e., all today's events.) - Output: List of event objects from Outlook.

Node: Edit Fields (Set Node) - Type: n8n-nodes-base.set - Purpose: Transform and simplify the event data structure from Outlook. - Configuration: Maps fields from Outlook event to new field names: - id - subject - description (from bodyPreview) - meetingstart - meetingend - attendees - meetingorganizer - meetingorganizeremail - meetinglink - Output: List of JSON objects with simplified meeting details.