I need you to develop some software for me. I would like this software to be developed for Windows.
I have a list of companies in excel sheet that I've generated from an online tool. This list contains the company name. I work in sales. I'd like to be able to quickly search the email address of all the companies in this list without having to manually google search for each company every time.
The first solution that I have been unable to find is a website or tool that will allow me to copy/paste my excel workbook/sheet into it and then have the searches automatically done.
The backup plan is to create an automated scraping tool. As far as I understand, this process will take two general steps:
1) Create a search macro or other system to pull data from a cell into a search tool or replace the search text in an existing Google Search Results URL. This will redirect the search results to a page that is unique to that set of search results which I need for step 2.
2) Scrape the hyperlink from the unique search results list to the excel spreadsheet.
3) Using the hyperlink cell from step 2, perform a second scrape, or skip step 2 and do this directly, this time, gather the coded mailing address for each company (or other similar company information easily found from googling the business), and export that information into another cell (in a new column again) for that individual company.
Beyond Step 3, I can manually manipulate the data or do what I need to make this work for me. Is there someone who can show me a solution that will solve this problem?