Automate finding a company URL on Google Sheets for FREE in just 3 easy steps

If you are frequently managing contact lists you may sometimes end up with lists containing company names and no company URL.

What the problem, right?

Now why would we need a company URL?

There are a trillion reasons you could need this. I think one of the obvious ones is to enrich a google sheet database with emails and company data.

So here is how it’s done!

The steps are written below-

STEP 1 :

Copy this link:

We are going to use the clearbit autocomplete API, which is FREE.

It’s pretty simple, you feed it a company name and it gives you back normalised data with the company name, logo and domain!!

STEP 2:

Now it’s time to generate a set of these requests on your sheet:

[examples]

Use a CONCATENER Function. And drag-down a whole column of them.

STEP 3:

In Google Sheets, open Tools> Script Editor and copy paste this code:

function FETCH(url) {

var response = UrlFetchApp.fetch(url);

Logger.log(response.getContentText());

var out = JSON.parse(response.getContentText());

return out[0][“domain”];

}

Don’t forget to save this code! (shortcut: "CTRL+S")

Now you are done!