How to extract data from gmail and write it to excel

Help
,
1

Hi All,

I need urgent help. I need to extract details from gmail in structured manner and save it into the excel.
I have already gone through the similar topic but didn’t find a way. Can anyone help me with the code.
I am new to UiPath and need to deliver this on urgent basis.

I am attaching the screenshot.
Please help me with this.

Ui
Ui1888×1068 265 KB

2

you want to extract the whole body of gmail or just tables with heading in body.

3

No just the tables

4

Any one facing the same issue. I have found two solution for this.

Thanks!
Anmol

5

What did you do to solve it?

6

@tranthao240495

Here are all the steps:

  1. Get the body of the mail.
  2. Save it using write text file activity with extension .html
  3. Open that file using open browser activity and give the path of the file in which you have saved in step 2.
  4. Using DataScraping extract that table output of this is DataTable.
  5. Use Write Range Activity to write the data table in excel.

Let me know if you need sample workflow.

Thanks!
Anmol

2 Likes
7

pls give me sample if u don’t mind :slight_smile:

8

Hi
where is the solution?

9

@tranthao240495 , @anjan

Here is the sample workflow.
Main.xaml (16.2 KB)

Please let me know if you need any other way than this

Thanks!
Anmol

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.