Import LinkedIn Profile Data To Google Sheets

Import LinkedIn Profile data to Google Sheets
Reading Time: 4 minutes

Scrape LinkedIn Data and pull the data to Google Sheets

In this article we’ll learn how to scrape LinkedIn profiles and import LinkedIn profile data to Google Sheets using Amigo Data, a Google Sheets extension.

Scraping LinkedIn profiles with Amigo Data is as easy as easy gets–and it’s quick and requires little manual effort. It involves only two steps and a couple of mini-steps.

But first, install the Amigo Data before we proceed to the steps. Get it here.

If you have Google Sheets opened, you can install it from there as well. Go to Extensions→Add-ons→Get add-ons. Then search Amigo Data and install it in your Google Sheets. And now the steps.

Steps to import LinkedIn profile data to Google Sheets

Step 1: Get the API endpoint URL

Sign up or log in to RapidAPI.

Search for LinkedIn Profile Data and click the first option from the results. Or click this link to go directly to the LinkedIn Profile Data  API documentation page.

The LinkedIn Profile Data API

Click on the Subscribe to Test button and subscribe to a plan of your choice, post which you’ll be able to run the test and import LinkedIn profile data to Google Sheets.

Subscribe to test

Click Endpoints to go back to the API Playground. On the left of the page is the list of available endpoints–of which there’s only one.

In the middle are the headers and parameters. In the Required Parameters field, enter the URL of the LinkedIn profile for which you want to retrieve information.

LinkedIn profile URL

Click the Test Endpoint button to verify if the profile is active or whether it exists. If it is, we’ll see a success message along with the data from LinkedIn. Otherwise, we’ll still see a success result but with the message: “Server is busy. Please try again later.”

The API URL and headers

Step 2: Import LinkedIn Profile data to Google Sheets

Open Google Sheets and launch Amigo Data from the sheet into which you want to fill the data. To connect to Amigo Data, click Extensions→Amigo Data→Connect.

Launch Amigo Data

You’ll be presented with a list of sources to connect to. Choose Custom API.

Select Custom API as the source to connect

Paste the endpoint URL in the API URL field. Do not include the apostrophes. (Likewise for the headers.)

The API URL bar

Then expand the Details tab and enter the header. For the endpoint we’ve selected, the headers are:

Name: X-RapidAPI-Key, Value: YOUR_API_KEY

Name: X-RapidAPI-Host, Value: linkedin-profile-data.p.rapidapi.com

The header names and header values

Preview of the data

The data will be imported into Google Sheets in a moment. Below is a snippet of the imported data.

The imported the data

We can likewise retrieve profile data for any LinkedIn user. However, instead of repeatedly entering the profile URL in RapidAPI and copy-pasting the API endpoint URL, which can be tedious if we need to scrape several profiles, we can use the same base endpoint URL and the headers and specify the query parameters (the profile URL) separately.

Enter the base endpoint URL given below in the API URL field.

Enter the headers are also the same for all queries. So enter the headers used above in the headers field.

Then click the “+QUERY” button and add the required parameter.

In the Value field is where we enter the profile URL of the profile we can to get the data.

If you need to constantly keep watch on a profile–not that you may ever need to, and it is tantamount to stalking but if you want to, there’s an option. You can set a refresh schedule and Amigo Data will update the data at regular intervals automatically. Learn more here.

Visit our blog for a bunch of other useful–and cool–things you can do with Amigo Data, such as pulling data from SurveyMonkey to Google Sheets, tracking stock markets and cryptocurrencies with Google Sheets, and importing Google Ads data to Google Sheets.

Some recommended articles:

Import Local Business Data From Google Maps To Google Sheets

Import Instagram Data To Google Sheets

Import Mailchimp Data To Google Sheets