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!