Hi H_L,Try this spreadsheet macro to get response status like
301,200,404, etc.,function StatusCode(){var sheet =
SpreadsheetApp.getActiveSheet(); for (var i = 2; i <= 1000; i++) { var
address = sheet.getRange('A'+i).getValue(); var response =
UrlFetchApp.fetch(address,{'followRedirects': true});
sheet.getRange('B'+i).setValue(response.getResponseCode()) ;
}}RegardsAshok