How to easily find company domain URL based off company name in Google Sheets
Step 1: add (https://autocomplete.clearbit.com/v1/companies/suggest?query=) to the right of the company name
Step 2: add (=CONCENTRATE) and combine the URL from step 1 with the company name. Example is: https://autocomplete.clearbit.com/v1/companies/suggest?query=GOOGLE
Step 3: Tap on “Tools” then “Script Editor”
Step 4: Enter in this script and then save it…
function FETCH(url) {
var response = UrlFetchApp.fetch(url);
Logger.log(response.getContentText());
var out = JSON.parse(response.getContentText());
return out[0][‘domain’];
Step 5: In a cell to the right, enter in =FETCH(URL)
Example: =FETCH(https://autocomplete.clearbit.com/v1/companies/suggest?query=GOOGLE)
That’s it! Weeee!