Hello friendly people
I am working in Studio Web on automating the following process in UiPath:
For each email received in Gmail with an attachment, I want to Download the attachment and upload it to a specific Google Drive folder.
Once the file is uploaded, I need to Open the file (which will be a Google Sheets file with a sheet named “Sheet1”) and Extract the value from cell I11
Append the extracted value into an existing sheet in cells A2
This process should loop, so for each new file, the values from I11 are added to the next available row in the **existing** file (A3, A4, etc.).
I cannot make this into a loop as every time the new email overwrites the old information.
Has anyone worked on something similar, and if so, what is the best way to structure this automation in UiPath Web?
Any pointers or best practices would be highly appreciated!
Hey @Anil_G , thank you for the help!
I would like to do this action with several cells and some of them are strings, others- numbers. However strings cannot be converted into a data table.
Do you have other possible solution?
Ideally what you would do is say you want to append data to 10 different columns then create a row and add add that row to datatable and use append range directly for once
First use a build datatable and add all column names you need After read use add data row and add array of elements with variable eg: {"",var1,var2,"","Some value if you need"}
Now at last use append range and pass the datatable which has all data in required columns with one row
