Google Sheets Function (SEO, How to Fetch HTTP Status Code for URL in Google Sheets)

getStatusCode.gs

/** 
    Google Sheets Function (Fetch HTTP Status Code for URL)
    How to Fetch HTTP Status Code for URL in Google Sheets
    Reference URL: https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app
**/ 

function getStatusCode(url){
   var options = {
     'muteHttpExceptions': true,
     'followRedirects': false
   };
   var url_trimmed = url.trim();
   var response = UrlFetchApp.fetch(url_trimmed, options);
   return response.getResponseCode();
}