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:
– 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:
– Learn the fundamentals of Excel in just 2 hours:
– 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
Watch related playlists
– Playlist with all my videos on Power Automate:
– Playlist with all my videos on Outlook:
– Playlist with all my videos on Excel:
Connect with me on social
– LinkedIn:
– Twitter:
– Facebook:
– TikTok:
Subscribe to my YouTube channel
Want to watch again? Navigate back to my YouTube channel quickly
Support me with your Amazon purchases:
As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel — the price to you is the same.
#stratvert…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Get your FREE “Profitable Content” Newsletter…
Thank you Kevin! Took me some time to get how these functions are working, not really straightforward. If you could do some deep dive on them I'm sure it will be greatly appreciated!
How can I automatically create a new Excel for each day, like a rolling log? Thank you very much
Hi Kevin, Thanks for uploading and sharing this video. However, I have a query where I receive information via outlook email where I need to capture few details: below is the email body-
"""The following work item requires processing in your SAP Workflow inbox in system SRO Client : 200
Release SES 1223456786 (60) from Vendor Halder Holding LLC for 10528.30
Kindly note that the payment for the related Invoice is due on 18 AUG 2023. Please action in advance to allow other approvers to action before this due date.
Service Entry Sheet 1223456786 INV -1003456I0001/0001 for Purchase Order item 412345890/00001 requires your Release approval for level 60.
Please can you release the Service Entry Sheet to allow the approval process to continue.
Technical information:
Workflow Inbox ""
How can I capture the SES number , vendor name, amount, due date, invoice number, Purchase Order number and level in an excel. can you please help me that.
I have tried above expression which you have shown but that didn't help to resolve this.
Do you a video explaining how to get Excel attachment content from an email and store it in an excel sheet
?
Hi, is it possible to get data from an excel file attachment in an email to MS Access?
Good afternoon Kevin, following up on this video, trying to to step by step the procedure, but I'm getting stuck, i guess there is a problem with the script for me, because i'm getting this error when running the flow
Hi Kevin! Do we have same functionality on MacOS?
Hi Kevin, great channel and excellent video, I wonder if you can assist – I want to take this automation one step further and add a hyperlink into the table linking to the original email in outlook. Is this possible using the functions?
Traduzir o vedeo em português
the hardest part of this tutorial, the expressions, gets completely glossed over. The examples given in the text don't make any sense.
Amazing tutorial… is it possible to automatically update an excel file in SharePoint by importing data from another excel file in Outlook as attachment everytime we receive it?
I'm still not able to understand how the expresions works, I know you are providing some condittions to pull the information, but I'm getting confused with the numbers and the "split" or the "first" I'm not sure on what it does.
Hi Kevin, Thanks for the tutorial, can you do something like this for MS Teams as well
In desktop automate , one email have multiple data to crop. I am able to successfully crop (using flag between two text) only first set of data. I not able to crop the next …set of text data in that same email. How to do that?
Bro, I went through all the steps (using the business account) and once I hit the test button, it took me to a pricing page to buy a subscription! Argh. This was a great instructional video though. Keep it up
been at this most the day, cant get it to work, copies a column header and pastes into my cells
this is exactly what i need but it imports a column name into each of my cells not the data and also has a strange date format…? any ideas please?
Hi there I did exactly step by step as in the tutorial, however I have two major obstacles: firstly all the data went into 1 columns, later the flow is working but no data is going to excel at all. I browsed google for the answer but there seems not to be one. can you help ?
Do we require to provide passwords if we are selecting a shared mailbox?
Hi th, I am trying to export the calendar data into excel. Its a manual trigger as every month the user has to change the dates he wants to analyze the data in excel. Thus my flow first delete all the rows using the run script( big issue) as I need to have fresh new data. ( reason I ll mention at the end) . Then I use Get calendar view of events and export the data into excel using Apply to each and Add rows into the table as an action. After testing the flow into my system number of times, I a getting the duplicate rows. I checked online and somebody wrote that if I make the concurrency 1 then the duplication won't happen. But this is giving errors in apply to each and times out after 10 mins. I need to understand if you can help
Hi Kevin, Thank you for the video. I got stuck on step where I am choosing excel file to add a new row. I am using a business account and when I go to file it tell me this "the resolved values for the following parameters are invalid, the may not be null or empty: 'drive'
Is it helpful if we have tables in our Outlook email. which may contain cell merge in one column
Can this be done on emails already in inbox?
a lot dev needed, but great for retrieving purchase order receipts to keep track of inventory
Would've been cool if he took more time to explain the expression for beginners, but nice explanation though…
Could you use this for extracting Outlook calendar entries into Excel as well?
Hi Kevin. Is it possible too to include the email attachment in the excel?