Write some Software
$250-750 USD
Thanh toán khi bàn giao
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!
ID dự án: #11736135
Về dự án
21 freelancer chào giá trung bình$472 cho công việc này
Hello I have read what you exactly need. However, I would like to ask you a few questions. I do work in a smart way and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detaile Thêm
Hi! I have more than 5 years of experience in data analytics. I also prefer to work with prototypes: create a mock solution for free and if you are fine with this we can discuss the details. Let me know if you are int Thêm
Is possible to do however will need many private proxys, that i need to buy. Google will allways flag as bot if you do many connections, we can use captcha service... but best solition for multithreading, (multiple s Thêm
I'll be completely honest, I've never done this before. But, I will say, you've got me hooked on this problem. if you don't select me for the job, I'm going to solve it anyway :) Hope you have a good weekend! Let me Thêm
i'm very familiar with macro excel, vba, visual basic, access database, and other spreadsheet data manipulation with fastest solution
Hi there, I'm working in one of the biggest companies in the world as Reporting Specialist doing exactly the same job you are looking for. I have macro already created for this kind of stuff. Done this many times Thêm
