Use Brandfetch with Google Sheets

Google Sheets’ native IMAGE function can load any Brandfetch CDN URL directly, so you can show live company logos in a spreadsheet without installing an add-on.

Prerequisites

A Brandfetch account with an active client ID

Basic formula

Drop a hardcoded domain straight into the formula:

=IMAGE("https://cdn.brandfetch.io/nike.com?c=BRANDFETCH_CLIENT_ID")

Reference a cell

Most sheets store the domain in a column rather than hardcoding it. Concatenate the cell reference into the URL instead:

=IMAGE("https://cdn.brandfetch.io/"&A2&"?c=BRANDFETCH_CLIENT_ID")

Apply to an entire column

Wrap the formula in ARRAYFORMULA to fill logos down a column automatically as new domains are added:

=ARRAYFORMULA(IF(A2:A="",,IMAGE("https://cdn.brandfetch.io/"&A2:A&"?c=BRANDFETCH_CLIENT_ID")))

Sizing

IMAGE takes an optional mode argument as its second parameter: 1 fits the image to the cell, 2 stretches it, 3 keeps its original size, and 4 lets you pass custom width/height in pixels. For predictable results regardless of cell size, size the logo itself using the Logo API’s own w/h path segments and keep IMAGE at mode 3:

=IMAGE("https://cdn.brandfetch.io/nike.com/w/128/h/128?c=BRANDFETCH_CLIENT_ID", 3)

Theme and fallback

Any Logo API parameter works the same way inside the formula, for example a dark-theme icon with a lettermark fallback:

=IMAGE("https://cdn.brandfetch.io/nike.com/theme/dark/fallback/lettermark/icon?c=BRANDFETCH_CLIENT_ID")

Access all brand data (logos, colors, company data…)

IMAGE can only embed images. The rest of a brand’s identity, its color palette, fonts, and company info, comes from the Brand API, which returns JSON and needs an Authorization header that no spreadsheet formula can send. A small Apps Script custom function fills the gap. You’ll need a Brand API key from the API keys page, this is a secret key, separate from the client ID used above. Open Extensions > Apps Script, paste the function below, and save:

Code.gs

const API_KEY = "YOUR_BRAND_API_KEY";

/**
 * Returns a brand attribute from the Brandfetch Brand API.
 *
 * @param {string} domain The company domain, e.g. "nike.com".
 * @param {string} field One of "name", "description", "accent", "font".
 * @return The requested value.
 * @customfunction
 */
function BRANDFETCH(domain, field) {
  const res = UrlFetchApp.fetch(
    "https://api.brandfetch.io/v2/brands/domain/" + domain,
    { headers: { Authorization: "Bearer " + API_KEY }, muteHttpExceptions: true }
  );
  if (res.getResponseCode() !== 200) return "";

  const brand = JSON.parse(res.getContentText());
  if (field === "name") return brand.name;
  if (field === "description") return brand.description;
  if (field === "accent") {
    const accent = brand.colors.find((c) => c.type === "accent");
    return accent ? accent.hex : "";
  }
  if (field === "font") {
    const title = brand.fonts.find((f) => f.type === "title");
    return title ? title.name : "";
  }
  return "Unknown field: " + field;
}

Then use it like any built-in function, next to the IMAGE logo column:

=BRANDFETCH(A2, "accent")

Brand API keys are secret. Anyone who can edit the spreadsheet can open the script and read the key, so don’t share the sheet outside your team with the key in place.

Custom functions re-run when the sheet recalculates (for example on reopen), and every run counts against your Brand API plan’s quota. Once a column is filled, freeze it with Edit > Paste special > Values only.

Integrations

Comparisons

Guides

Use Brandfetch with Google Sheets

Prerequisites

Basic formula

Reference a cell

Apply to an entire column

Sizing

Theme and fallback

Access all brand data (logos, colors, company data…)

​Prerequisites

​Basic formula

​Reference a cell

​Apply to an entire column

​Sizing

​Theme and fallback

​Access all brand data (logos, colors, company data…)

Prerequisites

Basic formula

Reference a cell

Apply to an entire column

Sizing

Theme and fallback

Access all brand data (logos, colors, company data…)