Automate Outlook to OneDrive Attachment Archive with SharePoint

Transform email attachment chaos into organized digital archives with this powerful n8n automation workflow. This solution automatically extracts attachments from your Outlook inbox every hour, uploads them to OneDrive with intelligent folder structures, and logs everything to SharePoint for complete audit compliance—eliminating manual file management forever.

What this workflow does

This automation runs in five sequential stages to handle your email attachments seamlessly:

• Hourly Ingestion: Monitors your Outlook inbox for unread emails, exiting cleanly when no messages are found
• Smart Processing: Processes emails individually using batch loops, extracting all attachments while filtering out invalid 0-byte files
• Intelligent Organization: Creates structured OneDrive folder paths automatically using sender domain and date: /Archives/{year}/{month}/{sender-domain}/
• Seamless Upload: Uploads valid attachments to OneDrive while skipping emails with no real attachments
• Audit Logging: Records all upload activities to SharePoint with sender details, file names, counts, and folder paths for compliance tracking

Use cases

• Document Management: Automatically archive invoices, contracts, and business documents from email into organized OneDrive folders
• Compliance Operations: Maintain audit trails for email attachments with detailed SharePoint logging for regulatory requirements
• Team Productivity: Eliminate manual attachment downloading and filing for busy professionals and administrative teams
• Customer Support: Automatically organize customer-submitted documents by sender domain for streamlined case management

Technical details

Built with essential n8n nodes including if conditions, code transformations, no-op handlers, batch splitting, error triggers, and sticky notes for workflow documentation. Integrates seamlessly with Microsoft Outlook for email processing, OneDrive for file storage, and SharePoint for audit logging. The workflow processes attachments hourly and marks source emails as read automatically, ensuring your inbox stays clean while building a comprehensive document archive system.