I’m trying to set up an automation where the process would read a list of URL in Column A, access the URL and get a specific portion of text in a zone (URLs are Instagram profiles and the information collected will be the same location on each page).
Accessing one site in cell A2, capturing the text and copying it into cell B2 works fine, but I’ve trying to use For Each Row process to repeat the action for the next cell of Column A so that it can copy the specific text from each link.
In for each row there is a index section in property panel, create a variable let’s say index which gives the row no through which it is iterating
Then inside the use read cell activitiy to read the url at column A making the cell as dynamic like this
“A”+(index+2).ToString and storing the url from read cell in form of string varaible
(index start from zero , for first row the index value is zero, we need to read from A2 cell, similarly in general for nth index we need to read from “A”+(index+2).ToString, this is general logic)
After going to url and accessing the text use write cell activitiy to write the data corresponding to the url row in B Column, ie f
Using write cell activitiy put the cell as dynamic like as we did in read range