Get your API key from the Logo.dev dashboard to
get started.
Basic formula
Use Google Sheets’IMAGE
function to display logos from company domains:
YOUR_API_KEY
with your publishable key from the dashboard.
The basic formula uses a hardcoded domain, while the cell reference formula pulls domains from cells dynamically. Use ARRAYFORMULA to apply logos to entire columns at once.
Customize logo appearance
Customize logo appearance with URL parameters:Control image sizing in cells
Google Sheets’ IMAGE function supports sizing modes:Bulk logo retrieval with ARRAYFORMULA
Apply the logo formula to entire columns using ARRAYFORMULA:- Checks if cells in column A are empty
- If not empty, generates a logo from the domain
- Applies to all rows automatically as you add data
FAQs
Does this work in Google Sheets mobile app?
Does this work in Google Sheets mobile app?
Yes. The IMAGE function and Logo.dev API work in Google Sheets on mobile (iOS and Android). Logos will load automatically when you have an internet connection.
Can I use this in Google Apps Script?
Can I use this in Google Apps Script?
Yes. You can fetch logos programmatically using Google Apps Script with
UrlFetchApp to call the Logo.dev API, then insert images into your sheet.
How do I add logos to multiple rows at once?
How do I add logos to multiple rows at once?
Use ARRAYFORMULA with the IMAGE function to apply logos to entire columns. See
the “Bulk logo retrieval” section above for the formula.
Will logos appear when I share the Google Sheet?
Will logos appear when I share the Google Sheet?
Can I use this in Google Docs or Google Slides?
Can I use this in Google Docs or Google Slides?
No. The IMAGE function is specific to Google Sheets. For Google Docs or
Slides, you’ll need to download logos first using the Logo.dev URL, then
insert them manually.
How do I handle companies without logos?
How do I handle companies without logos?
Logo.dev returns generated monograms for companies without logos. To check if
a real logo exists, use the Brand Search API to verify coverage before
inserting.
What image format should I use for Google Sheets?
What image format should I use for Google Sheets?
PNG format is recommended for best quality and compatibility. Google Sheets
handles PNG well. Use
format=png
in your Logo.dev URL.Can I filter or sort rows with logo images?
Can I filter or sort rows with logo images?
Yes. Google Sheets treats images in cells normally, so you can filter and sort
rows that contain logos. Use “Move and size with cells” if inserting images as
overlays.
How do I look up logos if I only have company names?
How do I look up logos if I only have company names?
Use Logo.dev’s Brand Search API with the company
name as a query parameter. This returns logos based on company name matching
instead of domains.
Are there rate limits for Google Sheets integrations?
Are there rate limits for Google Sheets integrations?
Yes. Each plan has defined usage limits. Free accounts include 1,000 requests
per month. Google Sheets may cache images, reducing repeated API calls. See
pricing for higher limits.
Can I use dark mode optimized logos?
Can I use dark mode optimized logos?
Yes. Add
theme=dark
to your Logo.dev URL to get logos optimized for dark
backgrounds. This is useful if your sheet has a dark theme.How do I make logos clickable?
How do I make logos clickable?
Google Sheets doesn’t support clickable images directly. However, you can add
a separate column with HYPERLINK formulas pointing to company websites.