How to Import Public Company Data from LinkedIn to Airtable

Oct 15, 2023‚ÄĘRosie Threlfall

In this tutorial, we'll run through the steps needed to import company data (such as name, description, employee count, and website) from LinkedIn into Airtable.

We'll use the Data Fetcher Airtable extension's Proxycurl integration to import this information. We'll also set it up to automatically import new company data based on changes we make to the Airtable spreadsheet.

What is Proxycurl?

Proxycurl is a tool that allows you to perform tasks such as looking up companies and their contact information. Proxycurl uses a credit system for billing.

Create 'Companies' Table

In Airtable, create a table called 'Companies', then add a field called 'LinkedIn URL' with the field type of 'URL'.

LinkedIn-Company-Data-Airtable.jpg

Copy and paste the following URLs into the 'LinkedIn URL' field (or use your own if you would rather).

  • https://www.linkedin.com/company/deliveroo/
  • ‚Ā†https://www.linkedin.com/company/apple/
  • ‚Ā†https://www.linkedin.com/company/skyscanner/
LinkedIn-Company-Data-Airtable-2.jpg

Add a view called 'Needs info' and set the following conditions using the 'Filter' menu:

  • 'LinkedIn URL' is not empty
  • Name is empty
LinkedIn-Company-Data-Airtable-3.jpg

Install Data Fetcher

To import company data from LinkedIn to Airtable, we're going to use an Airtable extension called Data Fetcher. You'll need to install Data Fetcher from the Airtable marketplace. Data Fetcher enables you to import data into Airtable from Proxycurl and many other apps and APIs.

Either sign up for a free Data Fetcher account or log into your existing one.

Group 1Data Fetcher Sign Up .png

Import LinkedIn Company Info into Airtable

Click 'Create your first request' to use the LinkedIn to Airtable integration.

Create your first request in Data Fetcher

For Application, select 'Proxycurl'.

LinkedIn-Proxycurl-Airtable-03.jpg

Connect a Proxycurl API Key

If you are new to Proxycurl you can sign up here. You will need to copy your API key which you can find here. Paste this key under Authorization.

LinkedIn-Proxycurl-Airtable-04.jpg

For Endpoint, select 'Full company profile for LinkedIn company profile URL(s)'.

LinkedIn-Company-Data-Airtable-4.jpg

Give your request a name such as 'Import Company Data' and click 'Save & Continue.'

LinkedIn-Company-Data-Airtable-5.jpg

Next, we want to insert a reference to our output table. Click the + button to the right of LinkedIn company profile URL.

LinkedIn-Company-Data-Airtable-6.jpg

On the modal window that opens, select 'Companies' for Table and 'LinkedIn URL' for Field, and 'Needs Info' for Run for every record in view and click 'Confirm'.

LinkedIn-Company-Data-Airtable-7.jpg

Your parameters should now look like this:

LinkedIn-Company-Data-Airtable-8.jpg

Click 'Save & Run'.

The Response field mapping modal window will now open. This is where you configure how the available data from LinkedIn maps to fields in Airtable.

Click 'Filter all' to remove the preselected fields, then use the search bar to find the fields you wish to import.

Check the following fields to import this data:

  • Name
  • ‚Ā†Description
  • ‚Ā†Website
  • ‚Ā†Company size on linkedin
  • ‚Ā†Profile picture
  • ‚Ā†Follower count
LinkedIn-Company-Data-Airtable-9.jpg

Then click 'Save & Run'.

The Data Fetcher request will now run, and you'll see that the info we have requested from LinkedIn has been populated into new fields in your output table.

LinkedIn-Company-Data-Airtable-10.jpg

Automatically Import LinkedIn Company Data into Airtable

Currently, we have to run the Data Fetcher request each time we add a new company URL to Airtable in order to import the data for the new company.

Using Data Fetcher's Trigger feature, we can set this to happen automatically. Triggers enable a request to run whenever a change is made to an Airtable record. For example, when a new record is created, updated or deleted.

Triggers are a paid Data Fetcher feature, so you'll need to upgrade your account. Scroll to the tabs that say Schedule / Trigger / Webhook URL and click on the 'Upgrade' button underneath.

upgrade.jpg

Select a plan to suit you and enter your payment details.

data fetcher upgrade pricing plans.png

In Data Fetcher, click 'I've done this'.

Schedule Data Fetcher

Next, select the 'Trigger' tab and click '+ Authorize' underneath.

Authorize.jpg

Accept the prompt 'I understand, let's Authorize'.

Authorize2.jpg

Click '+ Add a base'.

Authorize3.jpg

By selecting 'All current and future bases in all current and future workspaces', we'll avoid the need to re-authorize access for individual bases in the future.

Click on 'Grant access'.

Authorize4.jpg

In Data Fetcher, ensure the Trigger tab is selected. For this tutorial, we'll use the trigger type of 'Record created' (meaning the request will be triggered every time a new record is created in the view.) Then select your 'Companies' table and the 'Needs info' view.

Click 'Save'.

AI-Airtable-2023-11.jpg

Every time you add a new LinkedIn URL to Airtable (or make any change in this table), the Data Fetcher request will trigger, and the specified company data will be imported automatically.

Related Posts

How to Import LinkedIn Profile Info into Airtable

How to Import LinkedIn Profile Info into Airtable

Jul 11, 2023

‚ÄĘ

Rosie Threlfall

‚ÄĘWeb ScrapingLinkedIn
How to Create an Airtable Web Scraper with No-Code

How to Create an Airtable Web Scraper with No-Code

May 11, 2023

‚ÄĘ

Rosie Threlfall

‚ÄĘWeb Scraping
How to Scrape Amazon Product Data into Airtable

How to Scrape Amazon Product Data into Airtable

Mar 16, 2023

‚ÄĘ

Rosie Threlfall

‚ÄĘWeb Scraping