Hi! We need you to write a customised web crawler for Windows.
I want to be able to import an Excel file with a list of companies into the programme, and it should search for emails, phone numbers and names of employees of these companies in google. It should then add the emails, phone numbers and names (and the source link) it found back into that Excel file.
More details below. I am happy to discuss if any of them look too complex and we can find the way to optimise the task.
We have an Excel template. The programme should be able to import data from Excel. The template is attached; the list of companies which will be imported is in the tab 'Company List'. All these companies purchase and process wheat.
The programme should search in the top 5-10 google results, as well as on a few other predefined websites (e.g. yellowpages, facebook).
Note that most of the companies in our list are quite small and don't have their own website, for example a company in Thailand called NATEE FEEL MILL CO., LTD.
The programme should search not only by the exact spelling of the company name (e.g. NATEE FEEL MILL CO., LTD) but also remove punctuation marks (i.e. NATEE FEEL MILL CO LTD) as this will increase the chances of finding the information.
Most of the companies are going to be from the following countries: Malaysia, Bangladesh, Indonesia, Philippines, Egypt, Singapore, Italy, Tunisia, Thailand, Myanmar, Israel, Taiwan, UK, India, Vietnam, UAE, Hong Kong, Morocco.
In the same template you will see a tab called ‘Philippines’ which is an example of the required outputs. Columns C to I should be populated by the programme.
Note that where there are multiple emails / phone numbers for a company, the programme should create a separate row for each of the email / phone number. This is important for us as it allows us to keep track of communication on each phone number / email address separately.