Daily Email Data Consolidation

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted59 minutes ago
I need a robust, fully automated flow in Microsoft Power Automate that links Outlook, OneDrive and Excel Online. Every day the flow must:

• Watch my mailbox for new messages that match a combination of sender address, subject keywords and attachment name.
• When a match is found, save each attached Excel spreadsheet to a designated OneDrive folder, keeping the original file name.
• Open the saved file, pull the predefined data range, and append those values into the correct columns of an existing master workbook (also in OneDrive).
• Use the sender address plus the email’s received-date to detect and skip duplicates so historical records remain intact.
• Run on schedule or trigger without any manual button-press, and generate success/error logging I can review later.

Acceptance criteria
1. Flow template (.zip) imported into my tenant and demonstrated working end-to-end.
2. Master sheet shows new, non-duplicated rows after each test email.
3. Clear, commented steps inside the flow so I can maintain or extend it.
4. Short hand-over guide (markdown or PDF) covering how to adjust filters, change column mapping, and redeploy the flow if needed.

Please build and test in your own Office 365 developer environment; we’ll migrate to my account once everything passes.
php visual basic excel software architecture data integration automation data management workflow automation
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.