Automatically collecting Logos

Hi, in case this is not a well-know trick, it is possible to automatically collect companies logo (via an api) without having to upload each picture per company.

Approach:
1/ A “www” column with company’s website adress
2/ A “logo manual” column in case the company does not have a website or the collected logo is not satisfactory
3/ A template colum “logo auto”: https://logo.clearbit.com/XXX => XXX stands for the “www” column
4/ An if-then-else column: if “logo manual” Not empty => “logo manual” => else “logo auto”

nb: in the “template column” you can change some parameters to the https to have the picture in greyscale or other dimensions with guidelines here Clearbit API Documentation For Developers

10 Likes

Neat trick, will have a play with that :+1:

:+1::+1::+1::+1: