POKTAN AKUR XIV

Salin kode di bawah ini ke menu Extensions > Apps Script di Google Sheets Anda, lalu klik Deploy > New Deployment > Web App (Anyone).

function doGet(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheetBKU = ss.getSheetByName("BKU") || ss.insertSheet("BKU");
  var data = sheetBKU.getDataRange().getValues();
  return ContentService.createTextOutput(JSON.stringify(data)).setMimeType(ContentService.MimeType.JSON);
}

function doPost(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheetBKU = ss.getSheetByName("BKU");
  var request = JSON.parse(e.postData.contents);
  
  if(request.action == "addBKU") {
    sheetBKU.appendRow([new Date(), request.jenis, request.kategori, request.keterangan, request.nominal, request.pj]);
    return ContentService.createTextOutput(JSON.stringify({status: "success"})).setMimeType(ContentService.MimeType.JSON);
  }
}