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:

  1. First name, 
  2. Last name, 
  3. Company name and
  4. Domain

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:

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.

Starting the exporting of the data with Linkedin Helper

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.

Exporting and copying the companies’ data onto a spreadsheet

For this test I’ve decided to keep the following (the ones tagged with * are crucial for getting emails):

Property nameDesciption
nameName 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
industryIndustry of the company. See full list here.
countryCountry where company is based in
cityCity where company is based in
geographical areaState/Region where company is based in
sizeNumber of employees. Can indicate the potential size of the business
foundedYear that business was founded
followersNumber 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.

  1. Includes all columns in Company Data sheet that are filled with data.
  2. Includes the first column where the URLs of the Companies’ LinkedIn profiles are stored in Company Data sheet
  3. The Column from Company Data that should be shown in column G on Employees sheet (from 2 to 10 for column O)
  4. Should equal to the cell including URL of the Company LinkedIn profile on Employees sheet.
  5. 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.

Copy-paste the cell values as values only to get rid of 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.

Conclusion

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 placeholderSecond placeholderEmail variant
First nameEmpty[email protected]
Last nameEmpty[email protected]
First nameLast name[email protected]
First name [0]Last name [email protected]
Last nameFirst name[email protected]
Last name [0]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!

Leave A Comment

Your email address will not be published. Required fields are marked *