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.
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.
In Airtable, create a table called 'Companies', then add a field called 'LinkedIn URL' with the field type of 'URL'.
Copy and paste the following URLs into the 'LinkedIn URL' field (or use your own if you would rather).
Add a view called 'Needs info' and set the following conditions using the 'Filter' menu:
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.
Click 'Create your first request' to use the LinkedIn to Airtable integration.
For Application, select 'Proxycurl'.
For Endpoint, select 'Full company profile for LinkedIn company profile URL(s)'.
Give your request a name such as 'Import Company Data' and click 'Save & Continue.'
Next, we want to insert a reference to our output table. Click the + button to the right of LinkedIn company profile URL.
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'.
Your parameters should now look like this:
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:
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.
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.
Select a plan to suit you and enter your payment details.
In Data Fetcher, click 'I've done this'.
Next, select the 'Trigger' tab and click '+ Authorize' underneath.
Accept the prompt 'I understand, let's Authorize'.
Click '+ Add a base'.
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'.
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.
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.