LinkedIn Profile URL finder

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.

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”.