codigo-do-app-script.js

// Código do App Script:

var SS = SpreadsheetApp.openById('1xxxxxxxxxxxxxxM8E7wLwB7L2pU');  // id do link do google sheet 
var str = "";
 
 
function doPost(e) 
{

  var parsedData;
  var result = {};
   
  try
  { 
    parsedData = JSON.parse(e.postData.contents);
  } 
  catch(f)
  {
    return ContentService.createTextOutput("Error in parsing request body: " + f.message);
  }
    
  if (parsedData !== undefined)
  {
    var flag = parsedData.format;
    if (flag === undefined){
      flag = 0;
    }
     
    var sheet = SS.getSheetByName(parsedData.sheet_name);
    var dataArr = parsedData.values.split(",");
          
    var date_now = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), "dd/MM/yyyy");
    var time_now = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), "hh:mm:ss a");
     
    var value0 = dataArr [0];
    var value1 = dataArr [1];

     
     
    switch (parsedData.command) {
       
      case "insert_row":
          
         sheet.insertRows(2);
          
         sheet.getRange('A2').setValue(date_now);
         sheet.getRange('B2').setValue(time_now);
         sheet.getRange('C2').setValue(value0);  
         sheet.getRange('D2').setValue(value1);  
 
          
         str = "Success";
         SpreadsheetApp.flush();
         break;
          
      case "append_row":
          
         var publish_array = new Array();
          
         publish_array [0] = date_now;
         publish_array [1] = time_now;
         publish_array [2] = value0;  
         publish_array [3] = value1;  
   
          
         sheet.appendRow(publish_array);
          
         str = "Success";
         SpreadsheetApp.flush();
         break;     
  
    }
     
    return ContentService.createTextOutput(str);
  }
   
  else
  {
    return ContentService.createTextOutput("Error! Request body empty or in incorrect format.");
  }
}