Easy Tech TutsHow to Read From Excel and Send Email in Power Automate Easily 2026
By Impran M N
If you keep contact or business data in an Excel spreadsheet, Power Automate can read that data and send personalized emails automatically. This guide walks through connecting Excel to Power Automate and sending dynamic emails through Outlook.
01Prepare the Excel table
Structure your data as a proper Excel table with clear column headers, stored in OneDrive or SharePoint, so Power Automate can read it reliably.
02Connect Excel to Power Automate
Use the Excel Online connector to link your spreadsheet to a new flow.
03Read rows from Excel
Use a list rows action to pull all the data from your table into the flow.
04Send dynamic emails with Outlook
Loop through each row using Apply to Each and use the Outlook connector to send a personalized email built from that row's data.
05Filter and avoid duplicate emails
Add conditions to skip rows that shouldn't receive an email, and consider tracking sent status to avoid sending duplicates.
Frequently asked questions
Does my Excel file need to be a formatted table?
Yes, Power Automate's Excel connector works with data formatted as an Excel table, not just a plain range of cells.
Where does my Excel file need to be stored?
The file typically needs to be stored in OneDrive or SharePoint for Power Automate to connect to it.
Can I personalize the email content with data from each row?
Yes, you can insert dynamic content from each Excel row, such as a name or amount, directly into the email body.
Can I attach files to these automated emails?
Yes, Power Automate can attach files to the emails it sends as part of the same flow.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
