top of page



View Tool Page



Step 1: add ( to the right of the company name

Step 2: add (=CONCENTRATE) and combine the URL from step 1 with the company name. Example is:

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);
var out = JSON.parse(response.getContentText());
return out[0]['domain'];

Step 5: In a cell to the right, enter in =FETCH(URL)
Example: =FETCH(

That's it! Weeee!

How to easily find company domain URL based off company name in Google Sheets

Related Videos

Add a Title

Add a Title

Add a Title

bottom of page