Automated searches using Excel data
Use Liberty RPA’s Microsoft Excel activities together with browser activities (Google Chrome) to perform automated searches.
Use Liberty RPA’s Microsoft Excel activities together with browser activities (Google Chrome) and the loop special node.
This solution consists of two parts. The first is to retrieve a list of keywords from a table in an Excel file to use in the automation. Using each keyword in the table, a search on bing.com will be performed. The flow will loop through all the keywords, search bing.com and return results for each.
It’s a simple illustration of how data can be retrieved from a source and put to use on the web. This data could come from any source such as a comma separated file (csv), a text file (txt) or from a central database such as MySQL, Google Big Query or Oracle.
As well as using each keyword for searching the browser, the data could be put to other uses such as completing a webform, navigating an online interface and filling in data fields.