Code.gs

// ============================================================================
// Microlearning Content Reviewer — Sheets Web App perantara
//
// Cara pasang:
// 1. Buka Google Sheet tujuan.
// 2. Menu Extensions > Apps Script.
// 3. Hapus isi default, paste seluruh isi file ini.
// 4. Ganti SHARED_SECRET di bawah dengan string acak buatanmu sendiri
//    (perlakukan seperti password — jangan dibagikan).
// 5. Sesuaikan SHEET_NAME kalau nama tab sheet tujuan bukan "Sheet1".
// 6. Klik Deploy > New deployment > pilih tipe "Web app".
//      - Execute as: Me
//      - Who has access: Anyone
// 7. Klik Deploy, izinkan akses saat diminta otorisasi.
// 8. Salin "Web app URL" yang muncul, tempel ke pengaturan extension
//    bersama SHARED_SECRET di atas.
// ============================================================================

const SHARED_SECRET = "GANTI_DENGAN_SECRET_RAHASIA_KAMU";
const SHEET_NAME = "Sheet1";

function doPost(e) {
  try {
    const payload = JSON.parse(e.postData.contents);

    if (payload.secret !== SHARED_SECRET) {
      return jsonResponse({ ok: false, error: "Unauthorized: secret tidak cocok." });
    }

    const columns = payload.columns;
    const rows = payload.rows;
    if (!Array.isArray(columns) || !Array.isArray(rows)) {
      return jsonResponse({ ok: false, error: "Payload tidak valid: columns/rows harus array." });
    }

    const ss = SpreadsheetApp.getActiveSpreadsheet();
    let sheet = ss.getSheetByName(SHEET_NAME);
    if (!sheet) {
      sheet = ss.insertSheet(SHEET_NAME);
    }

    if (payload.includeHeader && sheet.getLastRow() === 0) {
      sheet.appendRow(columns);
    }

    rows.forEach((row) => sheet.appendRow(row));

    return jsonResponse({ ok: true, appended: rows.length });
  } catch (err) {
    return jsonResponse({ ok: false, error: String(err) });
  }
}

// Buka URL Web App langsung di browser (GET) untuk cek deployment hidup.
function doGet(e) {
  return jsonResponse({ ok: true, message: "Web app aktif. Gunakan POST untuk mengirim data." });
}

function jsonResponse(obj) {
  return ContentService.createTextOutput(JSON.stringify(obj)).setMimeType(
    ContentService.MimeType.JSON
  );
}