Find Domains from Company Names in Airtable

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'.
Screenshot 2021-09-30 at 14.39.39.png
  • Create a Grid view in the 'Companies' table called 'To process' with the following filters:
    • 'Name' is not empty.
    • 'Domain' is empty.
Screenshot 2021-09-30 at 14.41.43.png

Get a Clearbit API Key

Screenshot 2021-09-30 at 12.03.02.png

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'.
  • Based on the Clearbit Name to Domain API documentation, enter this URL in the URL input on the create request screen:

https://company.clearbit.com/v1/domains/find

  • Add a parameter called 'name'. For the value we want to use a reference to the 'Name' column in the 'Companies' table, so enter ***Companies*Name***..

The full URL should now be:

https://company.clearbit.com/v1/domains/find?name=***Companies*Name***

  • Set the output table to the 'Companies' table by clicking 'Use current'.
  • Set the output view to 'To process'.
  • Set up basic authorization with your API key from the previous step as the username. You can leave the password empty.

Screenshot 2021-09-30 at 14.54.12.png
  • 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.
Screenshot 2021-09-30 at 12.19.20.png
  • Click 'Run'. You will see a loading message while the request runs, then the response field mapping modal will open. This is where we select which fields from the API response to keep and how they should map to the fields in the output table. Click 'Show response' on this modal to see the actual response.
  • Set up the following fields and data types:

Response field

Data type

Use table field

Or, create field

name

Single line text

Name

domain

Url

Domain

logo

Url

Logo URL

Screenshot 2021-09-30 at 14.56.53.png

  • Click 'Confirm'. Data Fetcher will create the new fields in the output table, then the request will run again and import the domains for each company name from Clearbit into Airtable.
  • Click 'Save'.

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.
  • Click 'Save'.
Screenshot 2021-07-28 at 16.07.36.png