Copy button to copy the code snippet.function checkURLs() {
var sheet = SpreadsheetApp.getActive().getSheetByName("Sheet1"); // Change "Sheet1" if needed
var range = sheet.getDataRange();
var values = range.getValues();
for (var row = 0; row < values.length; row++) {
var url = values[row][0]; // ✅ URLs assumed to be in Column A
if (typeof url === 'string' && url.startsWith("http")) {
try {
var response = UrlFetchApp.fetch(url, { muteHttpExceptions: true });
var code = response.getResponseCode();
var status = (code === 200) ? "Live" : "Not live";
// ✅ Write status and response code in columns B and C
sheet.getRange(row + 1, 2).setValue(status);
sheet.getRange(row + 1, 3).setValue(code);
} catch (error) {
// ✅ Handle invalid URL or fetch errors gracefully
sheet.getRange(row + 1, 2).setValue("Error");
sheet.getRange(row + 1, 3).setValue(error.toString());
}
} else {
// If the cell is empty or doesn't contain a valid URL
sheet.getRange(row + 1, 2).setValue("Invalid URL");
sheet.getRange(row + 1, 3).clearContent();
}
}
}