In this guide, we will find domains for a list of company names in Airtable using the Clearbit API and the Data Fetcher app. We'll get a Clearbit API key, then set up an API request that fetches the domain for a list of company names. Finally, we'll see how to schedule this to run automatically.
Create Companies Table
Create a table in your base called 'Companies'.
In the name field, add the names of the companies you want to find domains for.
Add a field called 'Domain' with type 'URL'.
Get a Clearbit API Key
Install Data Fetcher
Find Domains from Company Names in Airtable
On the home screen of the Data Fetcher app, click 'Create request'.
On the create request screen, enter the request name 'Domains for Company Names'.
Add a parameter
called 'name'. For the value we want to use a reference to the 'Name' column in the 'Companies' table, so enter
The full URL should now be:
Click 'Advanced' to open the advanced settings.
Under 'Run on Multiple Records', click 'Use current' to set the table to 'Companies', then select the 'To process' view. This means an API request will run for every record in our 'To process' view, fetch the domain from Clearbit, and move it out of the view so it does not get updated next time we run the request.
Turn on the 'If one of these records causes an error, run the next request anyway.' option.
Use table field
Or, create field
Single line text
Import Domains Automatically
At the moment you have to import the domains by manually clicking the 'Run' button. Let's automate this by using Data Fetcher's scheduled requests feature.
On the create request screen in Data Fetcher, scroll to 'Schedule'.
You will need a paid account to use this feature, so click the button to upgrade your account if you haven't already. After upgrading, click the 'I've done this' button.
Add your Airtable API key if you haven't already.
Turn on 'Schedule this API request'.
Set how often you want the request to run.