How to extract table data from multiple emails that has different structure into excel

I’m trying to build a bot to read the multiple emails with table data that has different structure into Excel to enter the data into a form. The HTML code of the email has , ,

tags. Tried to use the Extract Data From HTML activity but the data is not pulling correctly. Please help me by providing a solution or workflow.

You need to predetermine the templates of each email using keywords or sender(hoping there is some template consistency with one of these) and then parse the data with respect to each template and add into data table. Once all the values are added, use write range activity to write into excel.

1 Like