Archive Outlook email attachments to OneDrive with SharePoint logging
Ready for 3.0What this workflow does
This workflow has 16 nodes and runs on a schedule (every hour) (plus 1 other trigger). Along the way it connects Microsoft Outlook, Microsoft OneDrive and Microsoft SharePoint.
How it runs
Trigger: On a schedule (every hour) (plus 1 other trigger).
- Get Unread Emails with Attachments (Microsoft Outlook): get many
- Send Error Email (Microsoft Outlook): uses Microsoft Outlook
- Has Emails? (If): checks a condition and branches into true / false
- Is Upload Error? (If): checks a condition and branches into true / false
- Process One Email at a Time (Loop Over Items (Split in Batches)): loops over the items in batches
- Log Failed Upload to SharePoint (Microsoft SharePoint): work with list item
- Get Email Attachments (Microsoft Outlook): get many (message attachment)
- Build Folder Path + Decode Attachment (Code): runs custom JavaScript code
- Has File Attachments? (If): checks a condition and branches into true / false
- Upload to OneDrive (Microsoft OneDrive): uses Microsoft OneDrive
…plus 3 more steps. See the full node list below.
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 (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Microsoft OneDrive
n8n-nodes-base.microsoftOneDrive - Microsoft SharePoint
n8n-nodes-base.microsoftSharePoint - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Stop letting email attachments pile up in your inbox. Let automation file every document the moment it arrives. Manually downloading and organising email attachments is repetitive, inconsistent, and easy to forget. This workflow checks your Outlook inbox…