uptimerobot:webhook > google sheets

AppsScript.js

function timeConverter(ts){
  var a = new Date(ts * 1000);
  var months = ['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'];
  var year = a.getFullYear();
  var month = months[a.getMonth()];
  var date = a.getDate();
  var hour = a.getHours();
  var min = a.getMinutes();
  var sec = a.getSeconds();
  var time = date + ' ' + month + ' ' + year + ' ' + hour + ':' + min + ':' + sec ;
  return time;
}


function req (e) {
  if (typeof e === 'undefined') { e = { parameter: { alertDateTime: '1646388087'} } }
  var qs = e.parameter;
  // Logger.log(qs);
  var ss = SpreadsheetApp.getActive();
  var sheet = ss.getSheets()[0];
  var ts = parseInt(qs.alertDateTime);
  if (typeof ts === 'number') {
    var row = [
      qs.alertTypeFriendlyName, 
      qs.monitorFriendlyName,
      qs.monitorID,
      qs.alertDetails, 
      qs.alertDuration, 
      timeConverter(ts), 
      qs.alertDateTime, 
    ];
    sheet.appendRow(row);
  }
  // return ContentService.createTextOutput(JSON.stringify(qs)).setMimeType(ContentService.MimeType.JSON)
}


function doGet (e) {
  return req(e)
}


function doPost(e) {
  return req(e);
}

duration seconds to HMS =ARRAYFORMULA(IF(ISBLANK(E2:E), , TEXT(E2:E /86400, "HH:MM:ss")))