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

Jul 31, 2024Zayyad Muhammad Sani

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
company-urls-in-table.png

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

  • Name - is empty
  • Domain - is not empty
filters-brand-info.png

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.

sign up for data fetcher.png

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

create your first request logo 2 smaller.png

Look up Company Brand Info in Airtable

Follow these steps to configure the request:

1. Select Custom under Application.

select custom request.png

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

name-brand-info-request.png

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

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

brand-fetch-url.png

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

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

reference-field-brand-info.png

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

add-domain-reference-brand-info.png

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

7. Click Authorization and select Bearer Token under Type.

add-authorization-brand-info.png

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.

brandfetch-api-key.png

api-key-pasted.png

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.

open-advanced-settings-brand-info.png

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

turn-off-data-transformation-brand-info.png

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.

response-field-mapping-brand-info.png

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

  • Click Deselect all
deselect-all-brand-info.png
  • 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
logo-brand-info.png

font-brand-info.png
  • Click Save and Run in the bottom right corner.

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

brand-info-retrieved.png

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.

Other Recent Posts

How to Import Data into Airtable Without Duplicates

How to Import Data into Airtable Without Duplicates

Oct 7, 2024

Zayyad Muhammad Sani

Custom RequestsData Fetcher
How to Connect to an OAuth 1.0 API in Airtable

How to Connect to an OAuth 1.0 API in Airtable

Sep 20, 2024

Zayyad Muhammad Sani

Custom Requests
Connect to the Anthropic (Claude) API in Airtable

Connect to the Anthropic (Claude) API in Airtable

Sep 5, 2024

Zayyad Muhammad Sani

Anthropic