function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);
  sheet.appendRow([new Date(), data.name, data.phone, data.type, data.emailStatus || "대기"]);
  return ContentService.createTextOutput(JSON.stringify({result: "success"})).setMimeType(ContentService.MimeType.JSON);
}

function doGet(e) {
  var password = e.parameter.password;
  // 관리자 검증 비밀번호 (기본값: 3323)
  if (password !== "3323") {
    return ContentService.createTextOutput(JSON.stringify({result: "unauthorized"})).setMimeType(ContentService.MimeType.JSON);
  }
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var rows = sheet.getDataRange().getValues();
  var results = [];
  for (var i = 1; i < rows.length; i++) {
    results.push({
      index: i,
      timestamp: rows[i][0],
      name: rows[i][1],
      phone: rows[i][2],
      type: rows[i][3],
      emailStatus: rows[i][4]
    });
  }
  return ContentService.createTextOutput(JSON.stringify(results)).setMimeType(ContentService.MimeType.JSON);
}