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:
To activate the add-on, go to Extensions > ImportFromWeb > Activate add-on.
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.
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:
Within seconds, you’ll get the first LinkedIn profile URL!
Drag the formula down to the last row to get the rest of the URLs.
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.