How to Import Email to Excel Automatically

In this step-by-step tutorial, learn how to import email from either Gmail or Outlook into Microsoft Excel using Power Automate. First, we visit Office.com and sign in with a free account. Next, we set up a new workbook in Microsoft Excel and enter the columns that we want to populate with content from an email. We proceed to Power Automate, where we set up a flow to take the contents of an email and insert them into our workbook table. Finally, we test the flow to ensure that the email successfully imports into the Excel worksheet. By the end, you’ll be able to take the contents from an email and fill it into your Excel workbook. The resulting flow will work automatically in the cloud and there’s no need to launch Outlook, Gmail, or Excel for this to work.

  • Additional resources
    • How to use Microsoft Power Automate: https://youtu.be/dDO4Y4aDYXw
    • Reference guide to using functions in expressions for Power Automate – this will help you understand the expressions below and how they parse text in an email: https://docs.microsoft.com/en-us/azur…
    • The expression in the “Cookie Type” field: first(skip(split(first(split(body(‘Html_to_text’),’Quantity’)),’: ‘),1))
    • The expression in the “Quantity” field: first(skip(split(first(split(body(‘Html_to_text’),’Delivery Method’)),’Quantity: ‘),1))
    • The expression in the “Delivery Method” field: first(skip(split(body(‘Html_to_text’),’Delivery Method: ‘),1))
  • Timestamps
    • 0:00 Introduction
    • 0:56 Sign into office.com
    • 1:28 Create new Excel workbook
    • 3:07 Navigate to Power Automate
    • 4:02 Build automated cloud flow
    • 5:15 Example email to import into Excel
    • 5:39 Step 1: Check when a new email arrives & filters
    • 6:35 Step 2: Convert HTML into text
    • 7:20 Step 3: Add new row into Excel table with email contents
    • 9:55 Extract content from body of email using expression
    • 11:28 Test flow
    • 13:05 Wrap up

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s