Google Sheets Domain Finder FETCH Script

google-sheets-domain-fetch.txt

function FETCH(url1) {
  var response = UrlFetchApp.fetch(url1);
  var json = JSON.parse(response.getContentText());
  
  var output = [];
  for (var i = 0; i < json.length; i++) {
    var company = json[i];
    output.push(company.name);
    output.push(company.domain);
    output.push(company.logo);
  }
  
  return [output];
}