Encerrado

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
Empregado trabalhando
Orçamento do projeto
$250 - $750 USD
Total de Ofertas
24
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!

Habilidades requeridas

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online