IMAGE-style formula like the one in Google Sheets or Microsoft Excel, and a short script does the same job in one run when you want more control over large tables.
Prerequisites
- A Brandfetch account with an active client ID
- A table with a text field holding each record’s domain (this guide uses
Domain)
Build the logo URL
Add a formula field, e.g. namedLogo URL, that concatenates the domain into a Brandfetch CDN URL the same way you would in Microsoft Excel or Sheets:
icon.png (the default type, as a real file extension) matters here: Brandfetch serves logos in WebP by default with no extension in the URL, and both of those can trip up Airtable’s URL-to-attachment conversion in the next step.
This field only holds text, so Airtable won’t show an image from it directly, and its only job is to feed the next step.
Turn the URL into an attachment
1
Add an Attachment field
Create a field named
Logo with type Attachment.2
Create an automation
Go to Automations > Create automation. Trigger on When a record matches conditions (e.g.
Domain is not empty and Logo is empty), so it fires once per record instead of re-downloading on every edit.3
Update the record
Add an Update record action on the same table. Set the
Logo field’s value to the Logo URL field from the trigger. Airtable downloads the file at that URL and stores it as a real attachment.If a record’s
Logo field still doesn’t populate, use the script below instead, since it sets the filename explicitly.Scripting
The Scripting extension, or a Run a script step in Automations, gives you a loop over every record in one run and lets you set the attachment’s filename directly:Attach Logos
"Companies" for your table’s name. Since this loops over every record with an empty Logo field, it’s safe to rerun after adding new rows. For large tables, run it in the Scripting extension rather than an automation, because automation scripts have a short time limit and can make at most 50 fetch requests per run.
Theme and fallback
Any Logo API parameter works the same way inside the URL, for example a dark-theme icon with a lettermark fallback, combined with the.png extension from above:
Add brand colors and company data
Attachments cover the logo, but a CRM-style base usually wants more: the brand’s name, colors, and fonts. Those come from the Brand API, which the same script pattern can call withfetch. You’ll need a Brand API key from the API keys page, which is a secret key and separate from the client ID used above.
Add text fields named Brand Name, Accent Color, and Title Font, then run:
Enrich With Brand Data
Brand Name check keeps reruns from re-billing records that are already filled.
FAQ
How do I add company logos to Airtable?
How do I add company logos to Airtable?
Add a formula field that builds
"https://cdn.brandfetch.io/" & {Domain} & "/icon.png?c=BRANDFETCH_CLIENT_ID" from each record’s domain, then create an automation with an Update record action that copies that URL into an Attachment field. Airtable downloads the file and stores the logo on the record.Why doesn't my Attachment field fill in?
Why doesn't my Attachment field fill in?
Check that the URL ends in
icon.png rather than no extension, since Airtable’s conversion can fail on extensionless WebP images, and that the domain field has no extra spaces or https:// prefix. For a domain Brandfetch doesn’t know, the default placeholder is served as WebP whatever the extension, so add /fallback/lettermark before /icon.png to get a PNG lettermark that Airtable can store. If it still stays empty, the script sets the filename explicitly and usually works where the automation doesn’t.My Clearbit logos stopped working in Airtable. How do I fix them?
My Clearbit logos stopped working in Airtable. How do I fix them?
Clearbit’s Logo API shut down in December 2025, so formulas that build
logo.clearbit.com URLs no longer return images. Change the formula to "https://cdn.brandfetch.io/" & {Domain} & "/icon.png?c=BRANDFETCH_CLIENT_ID", and attachments that were already downloaded stay in place because Airtable stores the files.Can I get brand colors and fonts into Airtable too?
Can I get brand colors and fonts into Airtable too?
Yes, with the Brand API and a short script that writes the name, accent color, and title font into text fields, as shown in Add brand colors and company data.
How do I refresh a logo after a company rebrands?
How do I refresh a logo after a company rebrands?
Clear the record’s
Logo field and run the automation or script again, since both only fill records whose Logo field is empty. The Logo API always serves the current logo, so the new download picks up the rebrand.