Kode Google Apps Script (`doPost`):
Salin kode berikut ke Apps Script di Spreadsheet Anda (Extensions > Apps Script):
function doPost(e) {
try {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = JSON.parse(e.postData.contents);
if (sheet.getLastRow() === 0) {
sheet.appendRow(["Timestamp", "Tanggal", "Nama", "No HP", "Pekerjaan", "Jenis Layanan", "Alamat", "Komentar"]);
}
sheet.appendRow([
new Date(),
data.tanggal || '',
data.nama || '',
data.hp || '',
data.pekerjaan || '',
data.layanan || '',
data.alamat || '',
data.komentar || ''
]);
return ContentService.createTextOutput(JSON.stringify({'result': 'success'}))
.setMimeType(ContentService.MimeType.JSON);
} catch(err) {
return ContentService.createTextOutput(JSON.stringify({'result': 'error', 'error': err.toString()}))
.setMimeType(ContentService.MimeType.JSON);
}
}