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");
}
Postingan
