I built a scraper to gather LinkedIn profile URLs in a spreadsheet; however, I need their emails, too. I'm looking for either a desktop app or web app to do this.
This is the advice I've received. Hopefully it helps.
"Your can try reverse pinging the LinkedIn or AL APIs or use clearbit to see if there is a match. Or you can just ping sendgrid API to get the email engagement rate, as they've seen nearly all emails before."
I have on the right side of the spreadsheet the most likely email formats of each person you come across on LinkedIn: https://docs.google.com/spreadsheets/d/1skLZ_iThod5LxMnPa24Lk3Fz9v1Idy_et7Dle_b4Mw4/edit?usp=sharing
I need the tool to simply output the correct email or "N/A" if the email can't be found next to a created column of LinkedIn addresses.
Looking to process around 50,000 LinkedIn URLS once a week.
Here's an example spreadsheet of the data sets I will be dealing with: https://docs.google.com/spreadsheets/d/1KQAI3ACTkl7EvJkT4G0GmeLMpYrHoTqsxjpqQYWWKUU/edit?usp=sharing