function doGet(e) { const ss = SpreadsheetApp.openById('1yZ_ZAGxw04Z5PMT8x8oV0u5BoqfBzwV1Vf-lYQbjVRs'); const sh = ss.getSheetByName('Sheet1'); // ganti sesuai nama sheet const data = sh.getDataRange().getValues(); const header = data.shift(); const obj = data.map(r => Object.fromEntries(header.map((h,i) => [h, r[i]]))); return ContentService .createTextOutput(JSON.stringify(obj)) .setMimeType(ContentService.MimeType.JSON); } let siswa = []; fetch('YOUR_WEBAPP_URL') .then(r => r.json()) .then(data => { siswa = data.filter(s => s.Kelas === '9D'); }); function login() { const nama = trim(document.getElementById('nama').value); const nis = trim(document.getElementById('nis').value); const siswaLogin = siswa.find(s => s.Nama.toLowerCase() === nama.toLowerCase() && s.NIS === nis); if(!siswaLogin) { alert('Login salah'); return; } ... } function getRekap(nis, { mode, tahun, bulan }) { const absens = JSON.parse(localStorage.getItem(`absen-${nis}`)) || []; return absens.filter(a => { const d = new Date(a.tanggal); if(mode === 'bulan') return d.getFullYear()===tahun && d.getMonth()+1===bulan; const weekStart = new Date(tahun, bulan-1, 1); ... }); } @media print { body { background-color: #6a0dad; color: white; } button, input { display: none; } }