Setiap ada transaksi baru, PWA otomatis mengupdate Google Sheets Anda:
Cara Pasang Auto-Sync di Google Sheets:
- Buka spreadsheet Google Sheets Anda.
- Klik menu Extensions → Apps Script.
- Hapus kode lama dan tempel kode berikut:
function doPost(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = JSON.parse(e.postData.contents);
sheet.clear();
sheet.appendRow(["TANGGAL", "KETERANGAN", "STATUS", "KREDIT", "DEBET", "SALDO"]);
var saldo = 0;
data.rows.forEach(function(r) {
if (r.type === 'KREDIT') {
saldo += r.kredit;
sheet.appendRow([r.tanggal, r.keterangan, r.status, r.kredit, "", saldo]);
} else if (r.isHeader) {
sheet.appendRow(["", r.keterangan, "", "", "", ""]);
} else {
if (r.status !== 'by owner') saldo -= r.debet;
sheet.appendRow([r.tanggal, r.keterangan, r.status, "", r.status === 'by owner' ? 0 : r.debet, saldo]);
}
});
return ContentService.createTextOutput(JSON.stringify({status: "OK"})).setMimeType(ContentService.MimeType.JSON);
}
4. Klik Deploy → New deployment → Web app (Who has access: Anyone), lalu tempel URL-nya ke kotak di atas.