Cerrado

Write some Software

Este proyecto recibió 24 ofertas de freelancers talentosos con una oferta promedio de $469 USD.

Obtén cotizaciones gratis para un proyecto como este
Empleador trabajando
Presupuesto de Proyecto
$250 - $750 USD
Ofertas Totales
24
Descripción del Proyecto

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

Buscando hacer algo de dinero?

  • Establece tu presupuesto y período de tiempo
  • Describe tu propuesta
  • Consigue pago por tu trabajo

Contrata Freelancers que también oferten en este proyecto

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