Write some Software
Este projeto recebeu 24 ofertas de freelancers talentosos com uma oferta média de preço de $469 USD.Obtenha orçamentos gratuitos para um projeto como este
Orçamento do projeto$250 - $750 USD
Total de Ofertas24
Descrição do projeto
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!
Querendo fazer dinheiro?
- Defina seu orçamento e o prazo de entrega
- Descreva sua proposta
- Receba pelo seu trabalho
Contratar freelancers que também ofereça neste projeto
Trabalhe em projetos como este e ganhe dinheiro desde casa!Cadastre-se Agora!
- The New York Times
- Wall Street Journal
- Times Online