Find LinkedIn Profiles Based on Email Address for FREE

4 mins

In B2B sales you have only two channels to contact your potential leads. It’s email & LinkedIn and, in rare cases, phone calls. When it comes to “how to find an email address”, one will find it as easy as falling off a log. You simply use Email Finder Chrome Extensions like Lusha,, etc. 

But how to find a LinkedIn profile? 

There is one way that everyone knows… 

Google your targeted person and copy the LinkedIn URL from the search:

search linkedin by email

But there is a much better way to do it at scale! 

We’ve prepared a Google Sheets Formula that will find LinkedIn profiles based on emails AND/OR people’s names.

Though a combination of other tools may give you the same result, this method requires as much as 3 min to set up and is totally FREE!

(The FREE limitation is 100 searches/day, but it equals to 3000 searches / month!).

How to create formula

There is no in-built Google Sheets formula that parses & returns back a LinkedIn profile based on email and/or a person’s name. But we’ve created one! 

For this case, we’ll use: 

  1. Google Sheets (of course)
  2. Programmable Search Engine (to find Full name and LinkedIn Profile)
  3. Search Engine by Google
  4. AppScript (tool to add the script)
  5. The script I’ll share with you (I have 0 coding skills, so it was generated by Chat GPT 🤖. But it’s working, and I’m happy about it)

Note: You can do this for free with 100 searches (100 rows in Google Sheets) per day. More is paid, but super cheap.

Now we need to delete the columns we are not gonna use and keep only three of them (in this case,I have Email, First Name & Last Name).

And we add 2 more columns:

Full Name

LinkedIn profile

how to find someone's email on linkedin

Below, I’ll share with you the script you need to add to App Script.

  1. So now pls click on “Extensions” → “App Script”
    search linkedin by email
  2. Delete everything you have here, so it’s blank:
    how to find someone's email on linkedin
  3. Copy and paste the code I give you below.

Note: You will need to change the “YOUR API” & “YOUR KEY” parameters to yours (I’ll show how to do that):

* Find a LinkedIn profile from email, first name, and/or last name
* @param {string} email The email of the person. If not provided, set as empty string.
* @param {string} firstName The first name of the person. If not provided, set as empty string.
* @param {string} lastName The last name of the person. If not provided, set as empty string.
* @return if found the LinkedIn URL and name of the person
* @customfunction
function getLinkedInProfile(email = "", firstName = "", lastName = "") {
    // Get a Custom Search API Key
    var key = "YOUR API";

    // Create a Programmable Search Engine
    let searchEngineId = "YOUR KEY";

    // Prepare the search query
    let searchTerms = [];
    if(email) searchTerms.push(email);
    if(firstName) searchTerms.push(firstName);
    if(lastName) searchTerms.push(lastName);

    let search = " " + searchTerms.join(" ");

    // Call Google Custom Search API
    var options = {
        method: "get",
        contentType: "application/json",
    var response = UrlFetchApp.fetch(
        "" +
        key +
        "&q=" +
        search +
        "&cx=" +

    // Parse LinkedIn URL and name
    var url = JSON.parse(response).items[0].formattedUrl;
    var title = JSON.parse(response).items[0].title.split("-")[0];

    // Return the results in a 2D array
    return [[title, url]];

So it looks like this: 

search linkedin by email

  1. Now you need to add “YOUR API” & “YOUR KEY”:

Don’t fret! Even though it might seem as confusing as a Rubik’s Cube, fear not. All you need to do is follow the simple steps below and you’ll get the result:



  1. Go here:
  2. Click on “Get a key” to generate a new API. If you need to create a project, do it.

how to find someone's email on linkedin


  1. Go here:
  2. And create a new Search Engine, as shown below:
    search linkedin by email
  3. Click on “Basic” on the left menu and copy the Search Engine ID. It’ll be “YOUR KEY”

how to find someone's email on linkedin

Now update this code with your API and Search Engine KEY. Click the “Save” button.

search linkedin by email

Once it is done, let’s get back to Google Sheets.

Add the formula  “getLinkedInProfile("[email protected]", "John", "Doe").

how to find someone's email on linkedin

In a few seconds, this function will return LinkedIn account URs based on the info you have:

search linkedin by email

Now apply this formula to all the rows you have: 

how to find someone's email on linkedin

Boom! In a few seconds, you get all the results! 

search linkedin by email

How to use it 

Now you can add an extra channel for your outreach & nurturing process — LinkedIn!

For example, you have a list of potential clients in your CRM. Simply export this list and open in Google Sheets! In a matter of seconds, you have the list of LinkedIn profiles and can proceed to reaching out to them on scale!

Since you have people with their LinkedIn URLs in your Google Sheet,  download it as a CSV & add them to Expandi:

how to find someone's email on linkedin

Now you can set up a campaign & reach out to them: 

search linkedin by email

By unlocking several channels in your outreach & prospecting, you can 2x your results! 


If you’re reading this, here are a few more useful things:

  1. Sign up for Expandi Free Trial
  2. Connect with me on LinkedIn
  3. Join our LinkedIn Outreach Family community (we share a lot of exclusive things here)


This eBook is your ticket to never wondering how to promote your LinkedIn event the right way ever again

This FREE eBook will teach you all the tricks

  • The exact 1on1 examples we used (many times over) from our content plan (posts, video, polls)
  • How to automatically Invite your network throughout the month
  • 7 ‘Untapped Promotion’ strategies to get over 1000+ people to register for your event
  • How to interact with all attendees before the event and after the event

What works now won’t work again in a few months 😉 So…If you want take the swing and benefits – before it’s too late and before everyone starts using them

Download your FREE eBook now

Previous Post
Formatting LinkedIn Posts: Bold, Italics, Underline – Expandi
Next Post
18 LinkedIn recruiter message templates to 2x candidates’ responses

More posts