This is a follow-up from Find Prospective Companies and Its Employees and Extract Their Data From LinkedIn.
Sending a message on LinkedIn is great, but the majority of professional still use email as a primary tool of communication. That’s why this guide will focus on getting a direct email for any LinkedIn profile. To do so we will need the following information:
- First name,
- Last name,
- Company name and
In the previous guide, we have already collected the data for the first 3. The final piece missing is the company domain. Moreover, VARIANT A will show you how to collect more data regarding companies. Information like company size, location, year founded and more can help generate an overview of its size and potential
1 Collect company domains
Since we have already collected first and last names, the only thing missing is domains. The information which is in most cases stored on the LinkedIn’s company page. Let’s return to our spreadsheet that. To achieve this goal we can use two tools:
- Companies extractor by LinkedIn Helper
- LinkedIn Profile Scraper API by PhantomBuster
1.1 [OPTIONAL] Companies extractor by Linkedin Helper (VARIANT A)
Firstly, let’s take a look at how we can use Companies extractor by LinkedIn Helper to collect domains and much more information connected to businesses. The main advantages of LN Helper are, extracts a lot more information which can help better describe the businesses and is a more robust method compared to PhantomBuster. The downside is that you’ll need your PC or MAC open for the duration of the process and might require a bit more technicals skills to finish for the first time.
For this task, you’ll need to prepare a list containing companies URLs which will be imported into LN Helper. The tool will visit each company page and extract all information associated with it.
Once the extraction is finished, download the data and copy it onto the spreadsheet. You can see there is a lot of information available. It comes to your own preferences what you would like to keep. However, for the purpose of getting the emails, we will need only domains.
For this test I’ve decided to keep the following (the ones tagged with * are crucial for getting emails):
|name||Name of the business|
|url*||Company LinkedIn profile URL. Required to connect the data with employees’ profiles|
|domain*||Domain of the business. Required for email generation|
|industry||Industry of the company. See full list here.|
|country||Country where company is based in|
|city||City where company is based in|
|geographical area||State/Region where company is based in|
|size||Number of employees. Can indicate the potential size of the business|
|founded||Year that business was founded|
|followers||Number of page followers. Can indicate popularity of the business.|
=INDEX(“Target Columns”,(MATCH(“Key cells”,”Key column”,0)+0),2)
If you are not familiar with INDEX and MATCH function in Google Sheets or Excel it might be a bit puzzling at the beginning. That it’s why below image should help.
- Includes all columns in Company Data sheet that are filled with data.
- Includes the first column where the URLs of the Companies’ LinkedIn profiles are stored in Company Data sheet
- The Column from Company Data that should be shown in column G on Employees sheet (from 2 to 10 for column O)
- Should equal to the cell including URL of the Company LinkedIn profile on Employees sheet.
- Shows the sheet where companies’ data is stored
As you merge the data finish of with copy-paste values only so we get rid of the formulas.
2 Generate direct emails
Finally, we have reached the stage where we will generate the direct emails of employees based on their first, last name and domain. There are two ways to achieve this depending on whether you have completed 1.1 or not. Step 1.1 requires an extra step compared to 2.2 but it provides more information regarding companies.
2.1 Generate direct emails with Hunter (VARIANT A)
Hunter is the leading solution to find and verify professional email addresses. Before we start collecting email addresses let’s make sure our spreadsheet, the data we will import to Hunter, is ready. To maximize the efficiency of Hunter we need to include the following information
- First name,
- Last name,
- Domain and
- Company name
First, set up a free account which gives you 100 free emails per month.
Considering you have successfully completed step 1.1 let’s export the Employees sheet and upload it to Hunter. To find emails with Hunter click on the Bulk tab and select Email Finder option (direct link).
Once Hunter is finished download the leads. Of course, it will not always be able to find emails for each contact. However, there is a way to guess the email based on the information collected.
2.2 Generate direct emails with LinkedIn Profile Scraper API by PhantomBuster (VARIANT B)
This method is quite faster and it requires less effort. The only disadvantage is that it does not provide with the same amount of information like VARIANT A does.
- Install LinkedIn Profile Scraper API via here
- Configure the LinkedIn Profile Scraper API
- Copy Hunter.io API key
Copy API Secret key into PhantomBuster API configurations
When you are satisfied with settings launch the API and let it work its magic.
There you have, API will automatically extract company domain and connect with Hunter to find a direct email address.
Above you have seen how to get a direct email and other information from LinkedIn. In our example, Hunter was able to retrieve about 47% of contacts’ emails. It is not a bad start, but there it can be the yield can certainly be improved. A professional email is most commonly a combination of the first and last name followed by a website’s domain. For instance, let’s look for a hypothetical employee named John Wick whose company’s domain parabellum.com
|First placeholder||Second placeholder||Email variant|
|First name||Empty||[email protected]|
|Last name||Empty||[email protected]|
|First name||Last name||[email protected]|
|First name ||Last name||[email protected]|
|Last name||First name||[email protected]|
|Last name ||First name||[email protected]|
Above table gives you an idea of how knowing first, last name and domain can be enough to get a direct email of an employee. Of course, we need to make sure that email is actually valid and will reach the recipient’s mailbox. This is where email verification software comes into the equation. There are many providers, one that offers free 100 daily verifications is QuickEmailVerification for which you can create a free account.
I will be shortly creating a guide on how to guess the direct email by using first, last name and domain. Furthermore, it will also include how to verify those emails using free services online. Stay tuned!