Zaini's-Blog

function buatSpreadsheetOtomatis() { // 1. Membuat file Spreadsheet Baru di Google Drive const namaFile = "Database Kelas 5 MI Hidayatul Mubtadi'in Weding"; const ss = SpreadsheetApp.create(namaFile); // 2. Setup Sheet "Siswa" (Menggunakan sheet bawaan yang pertama) const sheetSiswa = ss.getSheets()[0]; sheetSiswa.setName("Siswa"); sheetSiswa.appendRow(["NIS", "Nama Siswa"]); // Menambahkan data awal siswa const dataSiswa = [ ["1001", "Ahmad Muzakki"], ["1002", "Budi Santoso"], ["1003", "Citra Kirana"], ["1004", "Dewi Lestari"], ["1005", "Eko Patrio"] ]; sheetSiswa.getRange(2, 1, dataSiswa.length, 2).setValues(dataSiswa); // 3. Setup Sheet "Absensi" const sheetAbsen = ss.insertSheet("Absensi"); sheetAbsen.appendRow(["Waktu", "NIS", "Nama", "Status", "Foto (Base64)"]); // 4. Setup Sheet "Tabungan" const sheetTabungan = ss.insertSheet("Tabungan"); sheetTabungan.appendRow(["Waktu", "NIS", "Nama", "Jenis", "Nominal", "Keterangan"]); // 5. Setup Sheet "Jadwal_Pelajaran" const sheetJadwal = ss.insertSheet("Jadwal_Pelajaran"); sheetJadwal.appendRow(["Hari", "Jam Ke", "Mata Pelajaran"]); const dataJadwal = [ ["Senin", "1", "Upacara Bendera"], ["Senin", "2", "Matematika"], ["Senin", "3", "Bahasa Indonesia"], ["Selasa", "1", "Akidah Akhlak"], ["Selasa", "2", "IPA"], ["Rabu", "1", "Fiqih"], ["Rabu", "2", "Bahasa Arab"] ]; sheetJadwal.getRange(2, 1, dataJadwal.length, 3).setValues(dataJadwal); // 6. Setup Sheet "Jadwal_Piket" const sheetPiket = ss.insertSheet("Jadwal_Piket"); sheetPiket.appendRow(["Hari", "Nama Siswa"]); const dataPiket = [ ["Senin", "Ahmad Muzakki, Dewi Lestari"], ["Selasa", "Budi Santoso, Citra Kirana"], ["Rabu", "Eko Patrio"], ["Kamis", "Ahmad Muzakki"], ["Jumat", "Semua Siswa"], ["Sabtu", "Libur"] ]; sheetPiket.getRange(2, 1, dataPiket.length, 2).setValues(dataPiket); // 7. Mempercantik Tampilan Header (Warna background & Bold) const allSheets = ss.getSheets(); allSheets.forEach(sheet => { const lastCol = sheet.getLastColumn(); if (lastCol > 0) { const headerRange = sheet.getRange(1, 1, 1, lastCol); headerRange.setFontWeight("bold"); headerRange.setBackground("#d9ead3"); // Warna hijau muda sheet.setFrozenRows(1); // Kunci baris pertama agar tidak ikut ter-scroll } }); // 8. Menampilkan ID Spreadsheet dan Link di Log Eksekusi Logger.log("========================================="); Logger.log("✅ SPREADSHEET BERHASIL DIBUAT!"); Logger.log("========================================="); Logger.log("NAMA FILE : " + namaFile); Logger.log("URL FILE : " + ss.getUrl()); Logger.log("-----------------------------------------"); Logger.log("👇 COPY ID DI BAWAH INI DAN PASTE KE Code.gs ANDA 👇"); Logger.log(ss.getId()); Logger.log("1uveReTbxutkcHYCr3XKUUVbRahsVik2F3YVeZlbHu7A"); }