Daily Email Data Consolidation
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.
• 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.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.