วิธีดึงรูปแบบ JSON มาบันทึกลง Sheet

function saveTransferData() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("TransferLog");
  
  const data = {
    bank: "Bangkok Bank",
    status: "รายการสำเร็จ",
    date: "2568-06-05",
    time: "22:52",
    amount: 1000.00,
    currency: "THB",
    from: {
      name: "นาย ศราวุธ",
      account_number: "285-7-xxx106",
      bank: "ธนาคารกรุงเทพ"
    },
    to: {
      name: "ทรูมันนี่ วอลเล็ท",
      service_code: "TMNTOPUP",
      phone_number: "0908364901"
    },
    fee: 0.00,
    reference: {
      reference_number: "347854",
      transaction_id: "2025060522523423000810008"
    }
  };
  
  sheet.appendRow([
    data.date,
    data.time,
    data.amount,
    data.from.name,
    data.from.account_number,
    data.from.bank,
    data.to.name,
    data.to.phone_number,
    data.reference.reference_number,
    data.reference.transaction_id
  ]);
}