Enrich Emails with Company Info in Airtable

In this guide, we'll enrich a list of emails with company information in Airtable. We'll use the Data Fetcher Airtable app with the Clearbit API and enrich the emails with attributes such as name, industry and address. Although we'll be using the Clearbit API, this tutorial is 100% no-code!

Create Emails Table

Create a table in your base called 'Emails'. If you already have a table with the emails in, you can just follow this tutorial with the equivalent fields in your existing table.

Add a field called 'Email' with type 'Email' and add the list of emails you want to enrich.

Screenshot 2022-02-02 at 10.46.23.png

Create a Grid view in the 'Emails' table called 'To process' with the following filters:

  • 'Email' is not empty.
  • 'Name' is empty.
Screenshot 2022-02-02 at 10.47.19.png

Install Data Fetcher

Install Data Fetcher from the Airtable app marketplace. After the app launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'.

Group 1Data Fetcher Sign Up .png

Enrich Emails with Company Info in Airtable

On the home screen of the Data Fetcher app, click 'Create your first request'. Requests in Data Fetcher are how you import data to or send data from your Airtable base.

click-create-your-first-request.png

On the create request screen in Data Fetcher, for Application, select 'Clearbit'.

clearbit-application-selected.png

Clearbit provides data for companies based on an email address, so we can use it to enrich our list of emails. 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.

find-your-clearbit-api-key.png

Enter this key into the API Key input in Data Fetcher.

clearbit-authorization-api-key.png

For Endpoint, select 'Look up person & company info from email address(es)'.

clearbit-email-endpoint.png

Enter a Name for your request, e.g. 'Import Company Info'. Then click 'Save & Continue'.

clearbit-email-save-continue.png

For Email, we want to insert a reference to our 'Email' field. First click the + button.

clearbit-email-add-icon.png

A modal will open where we can create the table reference. For Field, select 'Email'.

clearbit-email-field.png

Click 'Confirm'.

clearbit-email-reference-confirm.png

The Email field should now contain a reference to the table.

clearbit-email-table-reference.png

Make sure the Output Table & View is set to 'Emails' and 'To process'.

clearbit-email-output-table-view.png

Click 'Save & Run'.

clearbit-email-save-run.png

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.

Map the 'Person name full name' field to the existing 'Name' field by clicking 'Existing field' and then selecting 'Name'. Import any other fields you want. Then click 'Save & Run'.

clearbit-emails-response-field-mapping.png

Data Fetcher will create any fields that need to be created in the output table, then run the request and enrich the emails with company and person information from the Clearbit API.

clearbit-emails-imported-data.png

Enrich Emails Automatically

At the moment, we have to manually run the request to enrich the emails with company and person information. We can use Data Fetcher's scheduled requests feature to enrich them every 15 minutes/ hour/ day etc.

In Data Fetcher, scroll to Schedule and click 'Upgrade'.

table-1-schedule-upgrade-button.png

A new tab will open where you can select a plan and enter your payment details to upgrade.

Screenshot 2021-12-29 at 10.25.19.png

Return to the Data Fetcher app and click "I've done this".

table-1-schedule-ive-done-this-button.png

Click 'Add API key' in order to add your Airtable API key. You can find your Airtable API key here.

Group 11(1).png

Enter your Airtable API key and click 'Save'.

save-airtable-api-key.png

Enable Schedule this request.

schedule-data-fetcher-request.png

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 enrich the emails using Clearbit automatically.

Group 11(2).png