In this guide, we'll import company data for a list of company URLs in Airtable. We'll use the Data Fetcher extension to connect to the Clearbit API and look up company data such as name, industry and address. Data Fetcher's Airtable Clearbit integration is 100% no-code.
Create Companies Table
Create a table in your base called 'Companies'. If you already have a table with the company URLs in it, you can follow this guide with the equivalent fields in your existing table.
Add a field called 'URL' with type 'URL'. Add the URLs you want to get company data for in this field.
Create a Grid view in the 'Companies' table called 'To process' with the following filters:
- 'URL' is not empty.
- 'Name' is empty.
Install Data Fetcher
Install Data Fetcher from the Airtable marketplace. After Data Fetcher launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'.
Lookup Clearbit Company Data for URLs in Airtable
On the home screen of the Data Fetcher extension, click 'Create your first request'. Requests in Data Fetcher are how you import data to or send data from your Airtable base.
On the create request screen in Data Fetcher, for Application, select 'Clearbit' to use the Airtable Clearbit integration.
Clearbit provides data for companies based on a URL, so we can use it to enrich our list of company URLs. If you do not have a Clearbit account, sign up for one here first. Next, find your Clearbit API key here in the Clearbit dashboard.
Enter this key into the API Key input in Data Fetcher.
For Endpoint, select 'Look up company info from domain(s)'. The endpoint defines what data you want to import to Airtable from Clearbit. You can select anther endpoint to enrich emails with company info or find domains/URLs from company names.
Enter a Name for your request, e.g. 'Import Company Data'. Then click 'Save & Continue'.
For Company domain, we want to insert a reference to our 'URL' field. First click the + button.
A modal will open where we can create the table reference. For Field, select 'URL'.
Click 'Confirm'.
The Company domain field should now contain a reference to the table.
Make sure the Output Table & View is set to 'Companies' and 'To process'.
Click 'Save & Run'.
The request will run and the Response field mapping modal will open. This is where you set how the fields from the Clearbit API should map to fields in the output table. For each Clearbit field, you can either import or filter it. For an imported field, you can set whether to map them to an existing field or create a new field.
Make sure the 'Name' field is mapped to the existing 'Name' field. Import any other fields you want. Then click 'Save & Run'. Import any other fields you want. Then click 'Save & Run'.
Data Fetcher will create any fields that need to be created in the output table, then run the request and import company data for your list of URLs Clearbit API.
Automatic Clearbit Airtable integration
At the moment, we have to manually run the Clearbit Airtable integration to import company data. We can use Data Fetcher's scheduled requests feature to import the data on a schedule.
In Data Fetcher, scroll to Schedule and click 'Upgrade'.
A new tab will open where you can select a plan and enter your payment details to upgrade.
Return to the Data Fetcher extension and click 'I've done this'.
Under Schedule click '+ Authorize'.
A new window will prompt you to authorize the Airtable bases you need Data Fetcher to have access to. We recommended selecting 'All current and future bases in all current and future workspaces' to avoid having to unauthorize bases in the future.
Click 'Grant access'.
In Data Fetcher, Schedule this request will be toggled on.
Select how often you want the request to run, e.g. 'Every 15 mins'. Click 'Save' The Clearbit Airtable integration will now automatically import company data from Clearbit on your chosen schedule.
