GAS POSTMAN

function koneksi() {
  var dataExcel = SpreadsheetApp.openById("1AwuVYSWRHoAIWn0o9dl6FMgl7FUs4XVPU41jNOjXnO4");
  var namaData = dataExcel.getName();

  Logger.log(namaData);
  var sapaan = berbicara();
  Logger.log(sapaan);

  var sheetInfo = dataExcel.getSheetByName("nama siswa");
  var jumlahBaris = sheetInfo.getLastRow();
  Logger.log (jumlahBaris);
}

function berbicara(){
  return "Assalamu'alaikum Wr. Wb"
}

function getCell (){
  var dataExcel = SpreadsheetApp.openById("1AwuVYSWRHoAIWn0o9dl6FMgl7FUs4XVPU41jNOjXnO4");
  var sheetInfo = dataExcel.getSheetByName("nama siswa");
  var dataAlamat = sheetInfo.getRange(4,3).getValue();
  Logger.log(dataAlamat);
  
}

function doPost(e){
  var dataExcel = SpreadsheetApp.openById("1AwuVYSWRHoAIWn0o9dl6FMgl7FUs4XVPU41jNOjXnO4");
  
  var sheetName = e.parameter.sheetName;
  var sheet = dataExcel.getSheetByName(sheetName);
   var action = e.parameter.action;


  //filter request user

  switch(action){

    case "create":
      return createData (e,sheet);
      break;
    case "read":
      return readData();
      break;
  }
  
  
}

function createData(request,sheet){
var nama = request.parameter.nama;
var alamat = request.parameter.alamat;
sheet.appendRow([sheet.getLastRow(),nama,alamat]);

  var output =JSON.stringify({
    "hasil" : "sukses"
  });

  return ContentService
        .createTextOutput(output)
        .setMimeType(ContentService.MimeType.JSON);
}

GAS Pemula

function koneksi() {
  var dataExcel = SpreadsheetApp.openById("1AwuVYSWRHoAIWn0o9dl6FMgl7FUs4XVPU41jNOjXnO4");
  var namaData = dataExcel.getName();

  Logger.log(namaData);
  var sapaan = berbicara();
  Logger.log(sapaan);

  var sheetInfo = dataExcel.getSheetByName("nama siswa");
  var jumlahBaris = sheetInfo.getLastRow();
  Logger.log (jumlahBaris);
}

function berbicara(){
  return "Assalamu'alaikum Wr. Wb"
}