Microsoft Outlook and Microsoft Teams integration

📥 Save Email Attachments to OneDrive & Log Them in Excel This workflow watches your Outlook inbox, automatically downloads file attachments (for example invoices), saves them into a specific OneDrive folder, and logs each file name into an Excel table. Optionally, it also posts a Microsoft Teams message to let you know that a new attachment has been processed. ✨ What this workflow does Monitors a Microsoft Outlook mailbox for new emails. Fetches all attachments from each incoming message. Processes attachments one by one so every file is handled cleanly. Downloads each attachment as binary data. Uploads the file into a OneDrive folder (looked up by name). Appends a new row with the filename to an Excel table for tracking. Sends a Teams chat notification once an attachment has been uploaded (optional). 🧑‍💼 Who this is for This workflow is ideal for: Finance / accounting teams who receive invoices by email and want them stored centrally. Anyone who wants an “email → OneDrive → Excel log” pipeline without manual downloading and renaming. n8n users who work in a Microsoft 365 environment (Outlook, OneDrive, Excel, Teams). ✅ Requirements Before you run the workflow, you’ll need: A Microsoft Outlook account with permissions to read emails and attachments. A OneDrive / SharePoint drive with a target folder (the example uses a folder whose name matches the search in the Get Folder ID node, e.g. Testn8n). An Excel workbook stored in OneDrive with: A worksheet and table already created. A column named Filename (or adjust the Set Filename + Excel node to match your column name). n8n credentials set up for: Microsoft Outlook Microsoft OneDrive Microsoft Excel Microsoft Teams (optional but used in this template) 🛠️ Setup steps Import the workflow JSON into your n8n instance. Configure credentials: Set your Outlook, OneDrive, Excel, and Teams credentials on the respective nodes. Adjust the mail trigger (On Mail Received): Optionally add filters (subject, sender, folder) if you only want to process invoices or a specific mailbox/folder. Set the OneDrive folder search (Get Folder ID): Update the query parameter to the exact name of the folder where attachments should be stored. Point the Excel node to your workbook (Append to Excel Log): Use the dropdowns to select your workbook, worksheet and table. Ensure there’s a Filename column (or rename the field in Set Filename to match your actual column). Activate the workflow: Once active, every new email that hits the trigger will have its attachments stored in OneDrive and logged in Excel. 🔗 Integrations used Microsoft Outlook** – trigger on incoming emails and download attachments. Microsoft OneDrive** – search for folders and upload files. Microsoft Excel** – append rows to a table in a workbook. Microsoft Teams** – send notifications when attachments are processed.

This workflow sends an automatic daily summary of your Microsoft Outlook calendar events into a Microsoft Teams channel. Perfect for team visibility or personal reminders. This automation is ideal for team leads, project managers, and remote workers who need to keep stakeholders informed of scheduled events without manual effort. It saves time, ensures consistent communication, and reduces the chance of missing important meetings. How it works Scheduled Trigger The workflow runs automatically every midnight (00:00 UTC). Create filter for "TODAY" value (Code Node) The code node generates the date value for "today" Calculates UTC start and end of the current day Builds a Microsoft Graph-compatible filter string Microsoft Outlook Node: Get Today’s Events Resource : Event Operation : Get Many Uses {{ $json.filter }}, which is generated from today's date, to retrieve only relevant entries Format Events as HTML (Code Node) Code node transforms each event into a formatted HTML message Meeting Time: 2025-07-08T10:00:00Z Subject: Weekly Sync Summary: Discuss project milestones and blockers. Microsoft Teams Node: Send Summary Message Chat Message | Create | Selected Channel | HTML content Uses the htmlMessage field from the previous node as the message body How to Use Import the Workflow Load the .json file into your n8n instance via “Import from File” or directly via the workflow UI. Set Up Credentials Go to Credentials in n8n. Add or configure your Microsoft Outlook OAuth2 API credential. Add or configure your Microsoft Teams OAuth2 API credential. Assign these credentials to the corresponding nodes in the workflow. Adjust Timezone and Schedule Edit the Schedule Trigger node to reflect your local timezone or preferred time. Configure the Microsoft Outlook Node Ensure the correct Outlook calendar is targeted. Confirm the Get Many node includes this expression in the filter field: {{ $json.filter }} Customize the HTML Output (Optional) Open the “Format Events” Code node to: Add new fields like Location, Organizer, or Attendees. Adjust date formatting to local time if needed. Target the Correct Teams Channel Open the Microsoft Teams node, select the team and channel where messages should be posted. Message type must be set to HTML if sending formatted content. Test the Workflow Run it manually to verify: Events are fetched correctly. The message is well-formatted and appears in the correct Teams channel. If you see no events, double-check the date filter logic or ensure events exist for today. Example Use Cases Team Syncs**: Automatically notify your project channel every morning with today's meetings. Remote Work**: Help remote teams stay aligned on shared calendars. Personal Assistant**: Keep track of your own day’s agenda with an automatic Teams message. Requirements Microsoft Outlook** Account must have permission to access calendar events via Graph API. OAuth2 credential must be configured in n8n Credential Manager. Microsoft Teams** Requires permission to post messages to specific channels. OAuth2 credential must be configured and authorized.