Show Logo from a website

[alhazen]

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.

[dbaum]

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.

[alhazen]

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

[alhazen]

Can anyone help me, please? Thank you very much

CC: @Joseph_Seddik @Marc_Dillon @TeeSee1 

[Joseph_Seddik]

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. 

[alhazen]

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).

[Joseph_Seddik]

The look for alternatives: logo repository api

[alhazen]

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

[TeeSee1]

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)

[Joseph_Seddik]

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. 

[alhazen]

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

[Joseph_Seddik]

That's what the script would do 🙂 process the incoming API/HTTP response. 

[alhazen]

Do you have an idea about the script?

[Joseph_Seddik · Accepted solution]

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 

[alhazen]

Thanks Joe for your feedback

[Joseph_Seddik]

Welcome my friend!