Hi, I am working on an automation to read an excel file with thousands of business names, scraping the web for each business, and pulling the address back into a new column in the sheet. This is my first time using PA so any insight would be greatly appreciated.
I've read in the names from excel (just 1 column though, I may need to append other columns like the city or province to get a more accurate search result) but I've ran into a wall with the populate text field on web page. I'm not sure how to clear this error, or if it's not iterating through the rows of data correctly. Any feedback/insight would be greatly appreciated!
