In this guide, we'll find domains for a list of company names in Airtable. We'll use the Data Fetcher extension and the Clearbit company name to domain API. Clearbit is a service that provides B2B company and person data. Data Fetcher is a free Airtable extension that lets us connect to Clearbit in Airtable with no-code.
Install Data Fetcher from the Airtable marketplace. After the extension launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'.
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'.
Clearbit provides domains for companies based on a name. 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 domain(s) from name(s)'.
Enter a Name for your request, e.g. 'Import Domains for Names'. Then click 'Save & Continue'.
For Company name, we want to insert a reference to our 'Name' field. First click the + button.
A modal will open where we can create the table reference. For Field, select 'Name'.
The Company name 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 Clearbit 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 'Domain' 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 look up Clearbit company name to domain info for your list of companies.
At the moment you have to import the domains by manually clicking the 'Run' button. Let's automate this by using Data Fetcher's schedule feature.
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 now open where you can authorize which Airtable bases you want Data Fetcher to have access to.
If you select 'All current and future bases in all current and future workspaces' you'll avoid issues with unauthorized bases in the future.
Click 'Grant access'.
You'll now see that Schedule this request has toggled on.
Select how often you want the request to run, e.g. 'Every 15 mins'. Click 'Save' The request will now run on the schedule and find domains from company names automatically.