Sistem ini adalah aplikasi web sederhana berbasis Google Apps Script + Google Spreadsheet + GitHub Pages untuk:
- Antrian Verifikasi SPMB/PPDB
- Cetak Form Verifikasi Berkas
- Multi Operator/Loket
- Kuota Harian
- Dashboard Admin
- Hosting Gratis
- Custom Domain
Cocok digunakan untuk:
- SMA / SMK
- PPDB Sekolah
- Verifikasi Berkas
- Registrasi Event Sekolah
- Antrian Pelayanan Sekolah
✅ Form Antrian Online ✅ Multi Operator (Round Robin) ✅ Kuota Harian Otomatis ✅ Generate Form Verifikasi ✅ Print Layout F4 Resmi ✅ Admin Panel Setting ✅ Google Spreadsheet Database ✅ Hosting Gratis via GitHub Pages ✅ Bisa Pakai Domain Sendiri
User Browser
↓
GitHub Pages (iframe)
↓
Google Apps Script Web App
↓
Google Spreadsheet Database
📦 project
┣ 📄 Code.gs
┣ 📄 Index.html
┣ 📄 Admin.html
┣ 📄 Spreadsheet
┗ 📄 README.md
Contoh nama:
SPMB-2026
Isi:
| A | B |
|---|---|
| tanggalMulai | 2026-06-01 |
| kuotaHarian | 100 |
| jumlahOperator | 4 |
| namaSekolah | SMK Negeri 2 Purwodadi |
| footerTeks | SPMB 2026 - SMK Negeri 2 Purwodadi |
Header:
| Timestamp | NISN | NoHP | Nama | Asal | Tanggal | Nomor | KeyDate | Loket |
Extensions → Apps Script
Code.gsIndex.htmlAdmin.html
Paste semua source code ke file masing-masing.
Cari bagian ini:
SpreadsheetApp.openById("SPREADSHEET_ID")Ganti dengan ID spreadsheet Anda.
Contoh URL:
https://docs.google.com/spreadsheets/d/1ABCDEF123456789/edit
Ambil bagian:
1ABCDEF123456789
Klik:
Deploy → New Deployment
Type → Web App
| Setting | Value |
|---|---|
| Execute As | Me |
| Who Has Access | Anyone |
Deploy
Contoh:
https://script.google.com/macros/s/AKfycbxxxx/exec
Buat repository baru.
Contoh:
spmb-2026
Isi:
<!DOCTYPE html>
<html>
<head>
<title>SPMB 2026</title>
<style>
html,body{
margin:0;
padding:0;
width:100%;
height:100%;
overflow:hidden;
}
iframe{
width:100%;
height:100vh;
border:none;
}
</style>
</head>
<body>
<iframe
src="URL_WEB_APP_GOOGLE_SCRIPT">
</iframe>
</body>
</html>URL_WEB_APP_GOOGLE_SCRIPTdengan URL deploy Apps Script Anda.
Masuk:
Settings → Pages
Deploy from Branch
main
/ root
GitHub akan memberikan URL:
https://username.github.io/spmb-2026
spmb.sekolah.sch.id
Custom Domain
CNAME → username.github.io
Agar nomor antrian tidak double.
Minimal whitelist email:
Session.getActiveUser().getEmail()GitHub Pages otomatis HTTPS.
Sistem sudah support:
✅ Kertas F4/Folio ✅ Print Browser ✅ Form Verifikasi ✅ Checklist Berkas ✅ Multi Tanda Tangan
Sistem dapat dibuka melalui:
- HP Android
- iPhone
- Laptop
- Tablet
- QR Code Tiket
- WhatsApp Gateway
- Dashboard Statistik
- Upload Dokumen
- AI Chatbot Sekolah
- OCR KK / Akta
- Export PDF
- Sistem Login Admin
- Scan Barcode
Tambahkan:
?page=admin
Contoh:
https://script.google.com/macros/s/AKfycbxxxx/exec?page=admin
| Teknologi | Fungsi |
|---|---|
| Google Apps Script | Backend |
| Google Spreadsheet | Database |
| GitHub Pages | Hosting Frontend |
| HTML CSS JS | Frontend |
| Google Web App | API Server |
Developed for:
- Sistem SPMB / PPDB Sekolah
- Open Source Education Project
- Indonesia School Digitalization
Free to use for educational purposes.