HOW TO WORK WITH DIFFERENT URLS

[Carvalho_Vini]

Hello! I need to download images from a advertisement but every time is going to be a new advertisement that I need to download the pictures. How can I do this automation? The urls that it’s going to use are in a google spreadsheet.

[mkankatala (Mahesh Kankatala)]

Hiii @Carvalho_Vini

Use read range activity to read the excel in to the datatable.
Use for each row in datatable activity to iterate the datatable.
Store the row in a variable like URL = Currentrow(“URL”).toString

Pass this variable in the Use application\browser activity then it will open that website.

Hope it helps!!

[vrdabberu (Varunraj Dabberu)]

HI @Carvalho_Vini

Use the below flow

Regards

[Carvalho_Vini]

Hey! This works to google spreadsheets too?

[vrdabberu (Varunraj Dabberu)]

@Carvalho_Vini

Yeah, for google spread sheet also it works

Regards

[vrdabberu (Varunraj Dabberu)]

hi @Carvalho_Vini

try this for google spreadsheet

Download Gsuite activities for this

Regards

[vrdabberu (Varunraj Dabberu)]

@Carvalho_Vini

If you find the solution for you query please mark as solution to close the loop.

Happy Automation!!

[Carvalho_Vini]

Hey! I dont have the “for each row” activity!

[vrdabberu (Varunraj Dabberu)]

@Carvalho_Vini

You have for each row in spreadsheet right?

Regards

[vrdabberu (Varunraj Dabberu)]

@Carvalho_Vini

Please see the below workflow I have done the workflow in StudioX
Download the package as UiPath.Gsuite.Activities so that you can use the spreadsheet

Regards