Basically, I have a list of people and I need an automated process to find their location. I have an Access Database (that can be easily converted to Excel) which has tens of thousands of contacts., all of whom I know have LinkedIn Profiles. Most of these contacts have the person's city, but about 30,000 do not. I need a process to automatically fill in these missing locations. I have quite a bit of data on each person including First, Last, Title and company.
I need a formula, macro or Power Query or Microsoft Power BI to search the person's first and last name and either title or company in order to make sure it's the right person on Google (or another search engine), and return the city in the database. For instance, if Power Query searched their first, last and title and "linkedin", the first result should be their linkedin profile, and their location will be listed in that search result. I need it to scrape this location data and return it to the sheet.
I need this to be:
1. Powerful enough to go through tens of thousands of entries and not get flagged by Google (or however it searches the web) as a bot
2. Repeatable on any similar list in the future
I'm not sure if this is possible to do this or not, so please do not accept this job if you don't already know how to do this. I don't want to waste anyone's time!
23 freelancers are bidding on average $479 for this job
Hi, I can assist you with this project. Here is a sampling of the few of my work contained at my portfolio: [login to view URL] Please reply back so we can discuss. Regards, DT