Show Logo from a website

AppSheet AppSheet Q&A
1

Hey guys, i hope you’re very well.

I have created a CRM Application. I use this formula “https://logo.clearbit.com/”&[URL]&“?s=256” to get logos of websites to display in the [logo] column. But there are some companies that are not listed on Clearbit. Is there another way to display the logo using a URL?

Thank you very much for your help.

2

I don’t know of another automatic way to get a logo. As you’re likely already aware, there’s a manual method. You could go to the company’s homepage, right-click on its logo to open the image in its own browser tab, and then copy that tab’s URL to store directly in your app’s row for that company.

Also: Thanks for sharing that Clearbit logo API. I hadn’t seen that before. For anyone who wants more info, see https://clearbit.com/blog/logo.

3 Likes
3

Hey @Steve do you have an idea about my question?

4

Can anyone help me, please? Thank you very much

CC: @Joseph_Seddik @Marc_Dillon @TeeSee1

5
  1. Download your logos in a publicly-shared Google Drive folder.
  2. Create a table having two columns, one for the company name and another for the URL to its logo stored in Drive folder.
  3. Retrieve the corresponding URL using a dereference expression.
2 Likes
6

Thanks for feedback.

I think it is a manual method

I use this formula “https://logo.clearbit.com/”&[URL]&“?s=256” to get logos of websites to display in the [logo] column automatically. The problem is that not all companies are listed on clearbit. Logo won’t show (404).

7

The look for alternatives: logo repository api

2 Likes
8

is it possible to make a default thumbnail when it show 404?

9

Apparently many people are looking to scrape company logos automatically but none found a perfect solution. It is a combination of automated and manual collection at the end. (not really an AppSheet question, either)

3 Likes
10

The simple answer is: that would depend on the URL destination. Or, should you really want to do it, you can launch an API request and process its response through Apps Script.

2 Likes
11

I tried to make it as simple as this,
IF([logo]=404, TEXT_ICON([company_name]), “https://logo.clearbit.com/”&[URL]&“?s=256”

but it doesn’t work lol

1 Like
12

That’s what the script would do :slightly_smiling_face: process the incoming API/HTTP response.

1 Like
13

Do you have an idea about the script?

14

That unfortunately from my point of view would be outside the scope of this forum. It is not a simple task to do, but it is simple enough to learn:

Google Apps Script overview | Google Developers

2 Likes
15

Thanks Joe for your feedback

1 Like
16

Welcome my friend!

1 Like