Extracting dealer information from various portals like Generac, Cummins, etc is done quarterly to fetch the dealer data like Company name, Street address, City, state, Zip-code, Website, Phone number & the services offered. The search needs to be performed by zip-codes in U.S. and Canada countries such that each and every zip-code is searched for dealers for a range of xx KMs. Web data scraping needs to be performed from web portals which is a highly voluminous and repetitive task that consumes multiple FTE’s time and is a monotonous task to be done manually.
UiPath automation tool performs web data scraping to navigate to each portal one by one and based on the pin code of a particular city or name of the particular city in a country, it extracts the full address of that specific dealer along with its contact information and services provided from the web portal and saves the information in an Excel sheet for further analysis.
This bot deals with extraction of data from web portals based on input data from an Excel (.CSV) file, and then saves the extracted results into an Excel file.
· UiPath reads the list of zip codes/cities and inputs a range of xx KMs to locate the dealer within that area.
· Once the extraction is completed, it updates the address and other data for each dealer from those locations in the Excel file.
This bot is developed using UiPath Studio Activities, which reads the text from the webpage.
UiPath Studio activities are used to integrated with Excel for data manipulation.