Extracts Titles/H1 from URLs right inside Google Sheets

Code.gs

function getTitleOrH1(url) {
  var response = UrlFetchApp.fetch(url,
  {
    method: "get",
    muteHttpExceptions: true
  });
  var html = response.getContentText();
  var titleMatch = html.match("<title>(.*?)</title>");
  var h1Match = html.match("<h1[^>]*>(.*?)</h1>");
  
  if (titleMatch) {
    return titleMatch[1];
  } else if (h1Match) {
    return h1Match[1];
  } else {
    return "No title or H1 found";
  }
}