Automate finding a company URL with a company name on Google Sheets for FREE in 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 a bummer, right?

Now why would you need a company URL?

There are a million reasons you could need this. I guess 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, but if you are not familiar with Sheets I suggest you watch this short video:

STEP 1 :

Copy this link:

https://autocomplete.clearbit.com/v1/companies/suggest?query=

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]

https://autocomplete.clearbit.com/v1/companies/suggest?query=quora

https://autocomplete.clearbit.com/v1/companies/suggest?query=trello

https://autocomplete.clearbit.com/v1/companies/suggest?query=slack

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: ⌘S)

Now you are done! 🎉

You can go back to your sheet.

In an empty column just apply the function: FETCH (url)

[*url = the cell with your generated request from step 2].

Apply the formula to all the generated requests and the script will find the domains for you!! Nice & easy.

If you enjoyed this article you might like my newsletter. Short, tactical learning twice a month in your inbox!