Look up Company Logos and Brand Info in Airtable using the Brandfetch API

In this tutorial, you'll learn how to look up company brand assets and information, such as names, logos, and fonts, in Airtable using the Brandfetch API.

Setting up the Brand Info Table

To get started, we'll prepare a table containing the URLs of the companies we want data on.

1. Create a table called "Brand info" or use an existing table.

2. Create a new field called "Domain" with the type URL.

3. Enter the company domains into "Domain". You can use these domains to get started, if you want.

• google.com
• airtable.com
• openai.com

4. Create a new Grid view called Needs info and apply the following filters.

• Name - is empty
• Domain - is not empty

We'll use this view to fetch data for companies in the table that don't contain brand information.

The table is ready, so let's connect to the Brandfetch API with Data Fetcher.

Installing Data Fetcher

We'll create a custom request in Data Fetcher to get the brand data for the company URLs in the table.

1. Add the Data Fetcher extension to your Airtable base.

2. Once you’ve added the extension, sign in to Data Fetcher or sign up if you don’t have an account.

3. Once you're logged in to Data Fetcher, click Create your first request.

Look up Company Brand Info in Airtable

Follow these steps to configure the request:

1. Select Custom under Application.

2. Rename the request to "Fetch brand info".

3. Copy and paste the URL for the brands endpoint into the URL field:

https://api.brandfetch.io/v2/brands/

Next, we'll append the company domains to the endpoint above.

4. Click the + button next to the URL input.

5. In the dialog that opens, select "Domain" under Field, then select Needs info under Run for every record in view.

6. Click Confirm to save the options and close the dialog.

7. Click Authorization and select Bearer Token under Type.

8. Copy and paste your Brandfetch API key under Token. Sign up for a Brandfetch developer account if you don't have an API key.

We'll configure the request so that Data Fetcher maps each logo and font to a separate field in the table. This will come in handy since many companies have multiple logos and fonts.

1. Scroll down and click Advanced settings to open the dropdown.

2. Scroll down to Data Transformation, then turn off Combine nested object keys and Combine arrays of text/numbers.

With these settings turned off, Data Fetcher will add a number suffix to each logo and font field so we can select just the ones we want. Don't worry if you didn't follow this - you'll see it in a minute!

3. Click Save and Run in the bottom right corner.

Mapping Response Fields

Once you've completed the previous steps, Data Fetcher will open Response field mapping. On this page, you'll choose the fields you want to import from the response data.

Let's pick the name, primary logo and font fields.

• Click Deselect all

• Select the following fields and use the mapping below. Use the search bar to find the primary font and logo:
  • Name → Existing field Name
  • Logos 1 formats 1 src → New field Logo
  • Fonts 1 name → New field Font

• Click Save and Run in the bottom right corner.

Check the default view of the table, and you should see the companies' brand info.

Look up Company Brand Info Automatically

If you don't want to manually run the request every time there's a new company in your table, check out Data Fetcher's triggers feature. You use a trigger to look up company brand info automatically whenever you create (or update) a record.

You can also use the scheduling feature to run a request at specific times. Check out our help center to learn more about triggers and scheduling.