We need to be able to enter any key word and city combination into Google and get results from our defined search.
From each search we need to collect data from page one up to page ten. The data we need to collect is:
Company website, company name, address, city, state, zip, phone number, email address, the date of the search, the search page number the website is on Google, it's Google page ranking, the key word and city combination used in the search.
We do not need company information from group or aggregated websites like yelp or city search or the like. But we do want the URL for the group website and the search page it is on.
We will need the ability to output the collected data to an excel file or CSV file like the attached excel file (Software Output).
We need to be able to clear a search and start over with a new search after each new output.