ENS highlighting

// To use the script, put the addresses in column A and you'd get the ENS names in column B
// It works for your active sheet, so remember to open the sheet you want to work on before you click "Run"

function getENSName(address) {
  var url = "https://api.ensdata.net/" + address;

  var options = {
    'method': 'get',
    'muteHttpExceptions': true
  };

  try {
    var response = UrlFetchApp.fetch(url, options);
    var json = JSON.parse(response.getContentText());

    // Check if ENS name is present
    if (json.ens) {
      return json.ens;
    } else {
      return "No ENS found";
    }
  } catch (e) {
    return "Error: " + e.message;
  }
}

function convertAddressesToENS() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var addresses = sheet.getRange('A2:A').getValues(); // Assuming addresses start from A2
  var ensNames = [];

  for (var i = 0; i < addresses.length; i++) {
    var address = addresses[i][0];
    if (address) {
      var ensName = getENSName(address);
      ensNames.push([ensName]);
    } else {
      ensNames.push([""]);
    }
  }

  // Output ENS names to column B, starting from B2
  sheet.getRange(2, 2, ensNames.length, 1).setValues(ensNames);
}