LinkedIn Profile URL finder

Turn a list of prospects into a list of LinkedIn profile URLs

To help you get started right away, you can use this free Google Sheets template

LinkedIn has become an indispensable platform for businesses, professionals, and job seekers worldwide. 

By collecting LinkedIn profile URLs, you gain a competitive edge in your targeted prospection.

Using the ImportFromWeb add-on and the function it adds to Google Sheets, you convert a list of last and first names into LinkedIn Profiles URLs.

First of all, make sure you have installed the ImportFromWeb add-on from the Google Workspace Marketplace.

Then, just follow these easy steps:

Open a new Google Sheets and activate ImportFromWeb

To activate the add-on, go to Extensions > ImportFromWeb > Activate add-on.

Activate ImportFromWeb add-on

Input a list of first names and last names

Input the names in the first column of your spreadsheet. To improve the reliability of the results, you can add the company where the person works in.

Write the =IMPORTFROMGOOGLE() function and extract LinkedIn profile URLs

By default, the =IMPORTFROMGOOGLE() function returns the first 10 Google results with the body, description, and URL. Since we’re looking for the LinkedIn URL of the profile we can use the link data selector. 

And as there’s a high probability that the profile’s LinkedIn URL will be the first result, we can limit the number of results using num_results option. 

Just add this formula: =IMPORTFROMGOOGLE(A2&"LinkedIn","link","num_results:1")

Within seconds, you’ll get the first LinkedIn profile URL!

Scale the collection process

Drag the formula down to the last row to get the rest of the URLs.

Additional social media platforms

To extract the profile URLs for other social media platforms, simply replace “LinkedIn” with the name of the platform; for example, “Instagram” or “Facebook”.

We’ve designed an easy-to-use template.
Make sure you have installed and activated ImportFromWeb in your Google Sheets.