Google spreadsheet - script to call HTTP Post api and update the response

googlesheet-post-api.gs

function autoLogin() {
 
  /*
 //Trying to do the below curl request as google spreadsheet scheduler
  curl -X POST \
  http://myserver.compute.amazonaws.com/api/users/login \
  -H 'cache-control: no-cache' \
  -H 'content-type: application/json' \
  -d '{
"email" : "emailid@gmail.com",
"password" : "mysecretpassword",
"type": "user"
}'
  */
  

 var formData = {
   'email': 'emailid@gmail.com',
   'password': 'mysecretpassword',
   'type': 'user'
 };
 
 var options = {
   'method' : 'post',
   'payload' : formData
 };
  
  var start = new Date();
  Logger.log('Before calling api: ' + start)
 
  var response = UrlFetchApp.fetch('http://myserver.compute.amazonaws.com/api/users/login', options);
  
  var end = new Date();
  Logger.log('After calling api: ' + end)
  var responseCode = response.getResponseCode()
  Logger.log(responseCode)
  

  addRow(start,end,responseCode)
  
 
  
}


function addRow(start,end,response){
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.appendRow([start,end,response]);
}

Trigger to run function every 15 min

Output spreadsheet

Red cells are result of conditional formatting (non 200 response)