Masukkan akun admin resmi OSIS/MPK
| ID Order | Nama & Status | No. WA | Kategori & Paket | Metode | Status Pembayaran | Gate Masuk | Aksi |
|---|---|---|---|---|---|---|---|
| Memuat data pesanan... | |||||||
Unggah data resmi Siswa, Guru, atau Panitia langsung dari file spreadsheet Excel.
.xlsx, .xls, atau .csv.
| No | Nama Lengkap | Kelas / Unit | Absen / NIP | Role Target |
|---|
| Nama Lengkap | Role | Kelas / Unit / ID | Status Verifikasi | Aksi |
|---|---|---|---|---|
| Memuat whitelist... | ||||
Hubungkan database tiket ini langsung ke Google Spreadsheet panitia secara real-time. Setiap ada pesanan masuk, pembayaran tunai/QRIS, atau check-in gerbang, data di spreadsheet akan terisi otomatis.
Ikuti 6 langkah mudah berikut untuk menghubungkan sheet Anda secara gratis tanpa setup API rumit.
/exec dan tempelkan ke kolom Webhook di atas, kemudian klik Simpan URL. Selesai!/* SCRIPT WEBHOOK GOOGLE SPREADSHEET GRESMAFEST 2027 */
function doPost(e) {
try {
var data = JSON.parse(e.postData.contents);
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Data Pesanan") || ss.getActiveSheet();
// Inisialisasi Header otomatis jika sheet masih kosong
if (sheet.getLastRow() === 0) {
sheet.appendRow([
"Waktu Order",
"ID Order",
"Kode Tiket",
"Nama Lengkap",
"Role / Kelas",
"No. Absen",
"WhatsApp",
"Kategori Tiket",
"Metode Bayar",
"Nominal (Rp)",
"Status Pembayaran",
"Waktu Lunas",
"Status Gate Masuk",
"Waktu Check-In"
]);
sheet.getRange(1, 1, 1, 14).setFontWeight("bold").setBackground("#dbeafe").setFontColor("#1e3a8a");
sheet.setFrozenRows(1);
}
if (data.action === "sync_order" || data.action === "update_order") {
var order = data.order;
var values = sheet.getDataRange().getValues();
var rowIndex = -1;
for (var i = 1; i < values.length; i++) {
if (values[i][1] === order.order_id) {
rowIndex = i + 1;
break;
}
}
var rowData = [
order.created_at || new Date().toLocaleString("id-ID"),
order.order_id,
order.ticket_code || "-",
order.full_name,
order.class_name || "-",
order.attendance_no || "-",
"'" + (order.whatsapp_no || ""),
order.tier_name || "Reguler",
order.payment_method || "CASH",
order.amount || 0,
order.status || "PENDING",
order.paid_at || "-",
order.check_in_status || "BELUM MASUK",
order.check_in_at || "-"
];
if (rowIndex > 0) {
sheet.getRange(rowIndex, 1, 1, rowData.length).setValues([rowData]);
} else {
sheet.appendRow(rowData);
}
return ContentService.createTextOutput(JSON.stringify({ success: true, message: "Order berhasil disimpan" })).setMimeType(ContentService.MimeType.JSON);
}
if (data.action === "batch_sync") {
var orders = data.orders || [];
var values = sheet.getDataRange().getValues();
var idMap = {};
for (var j = 1; j < values.length; j++) {
if (values[j][1]) idMap[values[j][1]] = j + 1;
}
for (var k = 0; k < orders.length; k++) {
var o = orders[k];
var rData = [
o.created_at || "",
o.order_id,
o.ticket_code || "-",
o.full_name,
o.class_name || "-",
o.attendance_no || "-",
"'" + (o.whatsapp_no || ""),
o.tier_name || "Reguler",
o.payment_method || "CASH",
o.amount || 0,
o.status || "PENDING",
o.paid_at || "-",
o.check_in_status || "BELUM MASUK",
o.check_in_at || "-"
];
var exRow = idMap[o.order_id];
if (exRow) {
sheet.getRange(exRow, 1, 1, rData.length).setValues([rData]);
} else {
sheet.appendRow(rData);
}
}
return ContentService.createTextOutput(JSON.stringify({ success: true, count: orders.length })).setMimeType(ContentService.MimeType.JSON);
}
if (data.action === "ping") {
return ContentService.createTextOutput(JSON.stringify({ success: true, message: "Koneksi Google Spreadsheet Aktif & Siap!" })).setMimeType(ContentService.MimeType.JSON);
}
return ContentService.createTextOutput(JSON.stringify({ success: false, message: "Aksi tidak dikenal" })).setMimeType(ContentService.MimeType.JSON);
} catch (err) {
return ContentService.createTextOutput(JSON.stringify({ success: false, error: err.toString() })).setMimeType(ContentService.MimeType.JSON);
}
}