Enter the LinkedIn API Request into the Apipheny add-on
Run the Linkedin API request
Step 1.) Install and open the Apipheny Add-on in Google Sheets
To pull data from the Linkedin API to Google Sheets, first install and open the Apipheny Google Sheets add-on.
Apipheny is a no-code API integrator for Google Sheets that you can use to make unlimited API requests to the Linkedin API, connect to unlimited APIs, save API requests, schedule API requests, and more. Click here for more information about Apipheny and get a free trial when you sign up today.
The menu on the left contains a list of available API solutions (Compliance, Consumer, Learning, Marketing, Sales, and Talent):
Clicking one of the available Linkedin APIs (e.g Marketing) will open a dedicated page, with more details about the concepts and operations provided by that solution.
These are organized using a menu on the left of the page, from which you can access more information about Development, Integrations or API References.
For instance, in the Marketing solution’s Integrations section, you’ll find a list of concepts used by this API:
An example Marketing integration concept is Ads. This concept’s menu lists multiple supported objects and operations, grouped under Account Structure and Advertising & Targeting.
The Ad Accounts menu item, in the Account Structure group, lists multiple supported operation endpoints. One of them is Search for Accounts, which allows the user to search for accounts by multiple criteria, such as their IDs, names, references, types and statuses:
The documentation for this endpoint contains a short description of the endpoint’s purpose, the HTTP method and URL, a table of the accepted parameters, as well as a sample request and its associated sample response:
Step 6.) Enter your LinkedIn API Request into the Apipheny add-on
Okay, we’re in the home stretch. Now go back to your Google Sheet and make sure that the Apipheny add-on is open on the “Import” tab. With the Import Tab open, enter these details into the add-on:
Method: At the top of the Apipheny sidebar, select the HTTP method (GET or POST) as required by your LinkedIn API endpoint. For this example, we are using the GET method.
API URL: In Step 5, I explained how you can find the LinkedIn API endpoint that you need. Now copy the complete API URL into the Apipheny add-on, where it says API URL Path (JSON / CSV), followed by any GET parameters required for your query.
For this example, we are using the “Me” endpoint, that gets information about the current user’s account. The corresponding URL for this endpoint is:
In the Headers section of the Apipheny add-on panel, add one row, with the following key and value: