uptime monitor with appscript

README.md

• At first run allow gmail access.
• Add time driven triggers (hour/minute)

uptime.gs

function uptime()
{
  var url = SpreadsheetApp.getActiveSheet().getRange("E2").getValue();
  
  if (!ScriptProperties.getProperty("status")) {
    ScriptProperties.setProperty("status", 200);
  }
  
  var response, error; 

  try {    
    response = UrlFetchApp.fetch(url);
  } catch(error) 
  {   
    insertData(error, -1, "Website down");
    return;
  }
  
  var code = response.getResponseCode();
  
  if (code == 200) 
    insertData("Up", code, "Website up"); 
  else
    insertData(response.getContent()[0], code, "Website down");
}

function insertData(error, code, msg) {  
  if(code!="200"){
    var sheet = SpreadsheetApp.getActiveSheet();
    var email = sheet.getRange("E3").getValue();
    var site = sheet.getRange("E2").getValue();
    var row   = sheet.getLastRow() + 1;  
    
    sheet.getRange(row,1).setValue(new Date());
    sheet.getRange(row,2).setValue(error);
    sheet.getRange(row,3).setValue(code);
  
    ScriptProperties.setProperty("status", code);
    MailApp.sendEmail(email, site+" "+msg, site+" "+error);
  }
}