Automatic Microsoft Outlook attachment storage to OneDrive with Excel logging
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs on Microsoft Outlook events. Along the way it connects Microsoft Outlook, Microsoft OneDrive, Microsoft Excel 365 and Microsoft Teams.
How it runs
Trigger: On Microsoft Outlook events.
- Get Message ID (Edit Fields (Set)): sets 1 field: messageId
- Get Attachments (Microsoft Outlook): get many (message attachment)
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Notify User (Microsoft Teams): work with chat message
- Get Folder ID (Microsoft OneDrive): search (folder)
- Download Attachment (Microsoft Outlook): download (message attachment)
- Upload to OneDrive (Microsoft OneDrive): uses Microsoft OneDrive
- Set Filename (Edit Fields (Set)): sets 1 field: Filename
- Append to Excel Log (Microsoft Excel 365): work with table
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 (7)
- Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Microsoft OneDrive
n8n-nodes-base.microsoftOneDrive - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - Microsoft Outlook Trigger
n8n-nodes-base.microsoftOutlookTrigger - Microsoft Teams
n8n-nodes-base.microsoftTeams
From the author
📥 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.…