Automatically Save Emails to Excel with Power Automate

Manually tracking emails can be time-consuming, especially when dealing with orders, inquiries, or reports. With Power Automate, you can automatically save email details—such as the sender, subject, and message body—into an Excel file. This tutorial will guide you step by step on how to build this automation.

Step 1: Prepare Your Excel File

Before setting up Power Automate, you need an Excel file where the email data will be stored.

1. Open Excel and create a new worksheet.

2. Create a table with the following headers:

   • Received Date

   • Sender

   • Subject

   • Email Body

3. Select the data range and press Ctrl + T to format it as a table.

4. In the Table Name box (under the Table Design tab), name it EmailData.

   

Save the file in OneDrive for Business or SharePoint so Power Automate can access it.

Step 2: Create a Power Automate Flow

1. Go to Power Automate and log in.

2. Click Create → Automated cloud flow.

   

3. Name your flow "Save Email Data to Excel".

4. Choose the trigger "When a new email arrives" (Outlook).

5. Click Create.

Step 3: Configure the Email Trigger

Click on the box. Select following options: Include Attachments, Folder.

To ensure we capture the right emails, let’s configure the trigger:

• Select Inbox as the email folder.

• Choose "Only with attachments" = No if you just want to save email text.

• (Optional) Add filters to capture only emails from specific senders.

Step 4: Save Email Data to Excel

Now, let’s add an action to store the email details in our Excel file.

1. Click New Step and search for "Add a row into a table". Choose OneDrive for Business (or SharePoint).

   

2. Select the Excel file and choose the EmailTable.

Map the fields:

• DateReceived → Received Time

• SenderEmail → From

• Subject → Subject

• EmailBody → Body

Step 5: Test Your Flow

Click Save and then Test the flow manually.

Send an email to yourself and check if the data appears in your Excel file.

If successful, Power Automate will automatically log emails into Excel every time a new one arrives!

With this automation, you can:

• Reduce manual data entry.

• Organise email data for reporting.

• Save time and avoid errors.

Want to automate more? Contact Power Streamline for help with Power Automate, Excel, and business process automation!