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:
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: "CTRL+S")
Now you are done!
