try on your own ide for testing the script

[go to Extension->App script ;also you will find script given below script name :status code ]

[question is every url like google, fb, amazon links are working and showing 200 status but (page is loading on browser but the status code is showing error on the sheet is there any modifications need to be done to the below code ]

//code start

  function getStatusCode(url){
  var response = UrlFetchApp.fetch(url)
  return response.getResponseCode();
  }

//code end