Selamat pagi, Bu Emily!
☁️Semua soal Google Form guru terhubung ke 1 Master Spreadsheet & tersimpan di Supabase!
Form Ter-generate
24
+4 paket soal hari ini
Ujian Berlangsung
7
184 siswa sedang aktif
Jawaban Masuk
56
Di 1 Master Spreadsheet
Tersinkron Supabase
100%
+Real-time Webhook
Overview Trafik Jawaban & Soal
Aliran respon Google Form masuk ke Master Spreadsheet & Supabase
Progres Mapel (GForm)
Live Soal & Jawaban
Mei 2026
Jadwal & Trigger Sync
Klik + untuk generate GForm guru
Bulk Generate GForm Guru
Hari ini, 08:00 WIB • Template #01
Pengawasan Live B. Inggris XI
Sedang berjalan • 34/36 Siswa
Auto-Backup ke Supabase DB
Setiap jawaban masuk • Webhook Aktif
Sistem Ujian Berjalan Lancar, Emily!
Semua soal GForm & jawaban siswa di Spreadsheet sudah aman di Supabase ๐
Generator Soal Google Form Otomatis (Operator)
Operator cukup memasukkan daftar Nama Guru & Mata Pelajaran, lalu klik Generate! Setiap guru otomatis dibuatkan Google Form dari Template (1OBy8Wgsq8JV_RQa17E8WLqXOVbXjVEc1RtWvAJbhOKo), disimpan ke Folder Drive, ditautkan ke 1 Master Spreadsheet, dan masuk ke Supabase.
๐ก Mengapa muncul "Maaf. Dokumen ini tidak diterbitkan." saat klik Link Siswa?
Google Forms versi terbaru menyetel hasil copy form (`makeCopy`) sebagai Belum Diterbitkan (Unpublished). Kami sudah menambahkan kode otomatis form.setPublished(true), form.setAcceptingResponses(true), dan DriveApp.Access.ANYONE_WITH_LINK di Script GAS.
Cara mengaktifkannya: Copy ulang Script GAS di tab Integrasi Supabase ➔ Deploy New Version ➔ lalu klik tombol "๐ Terbitkan (Publish) Semua Form" di kanan atas!
๐ฉ๐ป Panel Operator: Input Daftar Guru & Mapel (Generate Sekaligus)
Tambahkan baris guru & mata pelajaran di bawah ini, lalu klik Generate Semua Google Form.
1OBy8Wgs...bhOKo • Drive Folder: 1uYPG6Bw...Fp6c
| # | Nama Guru Pengampu | Mata Pelajaran | Kelas / Rombel | Kode Mapel | Target Siswa | Aksi |
|---|
LANGKAH 1
Template Google Form
LANGKAH 2
Guru Isi / Generate Soal
LANGKAH 3
1 Master Spreadsheet
LANGKAH 4
Monitoring & Supabase
Master Spreadsheet Ujian Terpusat
Seluruh Google Form guru menggunakan perintah form.setDestination(SpreadsheetApp, MASTER_SHEET_ID) sehingga soal & jawaban berkumpul di 1 file ini.
| Kode Soal | Form / Mapel | Guru Pengampu | Pertanyaan Soal (Generated di GForm) | Opsi Jawaban | Kunci | Status DB |
|---|
| Timestamp | NISN / Nama Siswa | Kelas | Mapel (GForm) | Rekaman Jawaban (Q1..Qn) | Skor | Sync Supabase |
|---|
Monitoring Jawaban Siswa & Butir Soal Real-Time
Pantau langsung setiap jawaban siswa beserta bunyi soal yang di-generate dari Google Form dan status penyimpanannya di Supabase.
๐ Daftar Soal yang Di-generate
๐ฏ Live Jawaban Siswa Masuk
Auto-Grading AktifDaftar Guru Penerima Template GForm
Setiap guru di bawah ini mendapatkan link Google Form hasil generate yang otomatis terhubung ke Master Spreadsheet.
Koneksi Database Supabase & Script Otomasi
Kredensial Supabase & ID Google Form Template Anda sudah tertanam. Untuk menyimpan ke Google Spreadsheet secara langsung, pasang kode GAS di bawah dan tempel URL Web App-nya.
-- Jalankan di SQL Editor Supabase (https://hjomdexijrnbkpblxmgz.supabase.co)
CREATE TABLE IF NOT EXISTS public.exam_forms (
id TEXT PRIMARY KEY,
kode_mapel TEXT UNIQUE,
subject_name TEXT NOT NULL,
teacher_name TEXT NOT NULL,
class_name TEXT NOT NULL,
form_id TEXT,
form_url TEXT,
form_edit_url TEXT,
sheet_tab TEXT,
total_questions INT DEFAULT 0,
total_students INT DEFAULT 36,
submitted_count INT DEFAULT 0,
created_at TIMESTAMPTZ DEFAULT NOW()
);
CREATE TABLE IF NOT EXISTS public.exam_questions (
id TEXT PRIMARY KEY,
form_id TEXT,
subject_name TEXT,
teacher_name TEXT,
question_text TEXT NOT NULL,
options_json JSONB DEFAULT '{}'::jsonb,
correct_answer TEXT,
created_at TIMESTAMPTZ DEFAULT NOW()
);
CREATE TABLE IF NOT EXISTS public.student_submissions (
id TEXT PRIMARY KEY,
form_id TEXT,
student_nisn TEXT,
student_name TEXT NOT NULL,
class_name TEXT,
subject_name TEXT,
answers_json JSONB DEFAULT '[]'::jsonb,
score INT DEFAULT 0,
synced_to_supabase BOOLEAN DEFAULT TRUE,
submitted_at TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE public.exam_forms ENABLE ROW LEVEL SECURITY;
ALTER TABLE public.exam_questions ENABLE ROW LEVEL SECURITY;
ALTER TABLE public.student_submissions ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Public Access Forms" ON public.exam_forms FOR ALL USING (true) WITH CHECK (true);
CREATE POLICY "Public Access Questions" ON public.exam_questions FOR ALL USING (true) WITH CHECK (true);
CREATE POLICY "Public Access Submissions" ON public.student_submissions FOR ALL USING (true) WITH CHECK (true);
// PENTING: Tempel kode ini di Extensions > Apps Script pada Spreadsheet Anda
// Lalu klik Deploy > Manage deployments > klik ikon Pensil (Edit) > Version: "New version" > Deploy!
const CONFIG = {
SUPABASE_URL: 'https://hjomdexijrnbkpblxmgz.supabase.co',
SUPABASE_KEY: 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6Imhqb21kZXhpanJuYmtwYmx4bWd6Iiwicm9sZSI6ImFub24iLCJpYXQiOjE3OTQ4NTI3MzgsImV4cCI6MjExMDQyODczOH0.TzSArvRGJeU09kq7NcgihrvdsL0UeBZlhzki0ez7fq4',
MASTER_SS_ID: SpreadsheetApp.getActiveSpreadsheet().getId(),
TEMPLATE_FORM_ID: '1OBy8Wgsq8JV_RQa17E8WLqXOVbXjVEc1RtWvAJbhOKo',
FOLDER_DRIVE_ID: '1uYPG6BwhGE3MQEHgkSHUY6VeZ_76Fp6c'
};
function ensureSheet(ss, name, headers) {
let sheet = ss.getSheetByName(name);
if (!sheet) {
sheet = ss.insertSheet(name);
sheet.appendRow(headers);
sheet.getRange(1, 1, 1, headers.length).setFontWeight('bold').setBackground('#EFE8FC');
sheet.setFrozenRows(1);
}
return sheet;
}
function formatResponderHeaderUrl(rawPubUrl, fallbackFormId) {
let u = String(rawPubUrl || '').trim();
if (!u && fallbackFormId) {
try {
u = FormApp.openById(fallbackFormId).getPublishedUrl();
} catch (e) {
u = 'https://docs.google.com/forms/d/' + fallbackFormId + '/viewform';
}
}
if (u) {
u = u.split('?')[0].replace(/\/edit$/, '/viewform');
if (!u.endsWith('/viewform')) u = u.replace(/\/+$/, '') + '/viewform';
return u + '?usp=header';
}
return '';
}
function publishAndShareForm(form, formFileId) {
try {
const file = DriveApp.getFileById(formFileId);
file.setSharing(DriveApp.Access.ANYONE_WITH_LINK, DriveApp.Permission.VIEW);
} catch (e) {}
try { form.setRequireLogin(false); } catch (e) {}
try { form.setAcceptingResponses(true); } catch (e) {}
try {
if (typeof form.setPublished === 'function') form.setPublished(true);
} catch (e) {}
}
// CEK APAKAH FORM DENGAN KODE MAPEL / JUDUL YANG SAMA SUDAH ADA (ANTI-DUPLIKAT)
function findExistingFormByKode(ss, kodeMapel, copyTitle) {
const sheet = ss.getSheetByName('Daftar_Form_Guru');
if (sheet) {
const rows = sheet.getDataRange().getValues();
for (let i = 1; i < rows.length; i++) {
const r = rows[i];
const isOldLayout = String(r[6] || '').length > 20 && String(r[7] || '').startsWith('http');
const rowKode = String(isOldLayout ? r[1] : (r[2] || r[1])).trim();
const rowFormId = String(isOldLayout ? r[6] : (r[7] || r[6])).trim();
const rowEdit = String(isOldLayout ? r[7] : (r[8] || r[7])).trim();
const rowView = String(isOldLayout ? r[8] : (r[9] || r[8])).trim();
if (rowKode === kodeMapel && rowFormId && rowFormId !== CONFIG.TEMPLATE_FORM_ID) {
return {
form_id: rowFormId,
edit_url: rowEdit || ('https://docs.google.com/forms/d/' + rowFormId + '/edit'),
view_url: formatResponderHeaderUrl(rowView, rowFormId)
};
}
}
}
// Cek juga langsung di Folder Google Drive jika sudah pernah ter-copy
try {
const folder = DriveApp.getFolderById(CONFIG.FOLDER_DRIVE_ID);
const files = folder.getFilesByName(copyTitle);
if (files.hasNext()) {
const existingFile = files.next();
const fId = existingFile.getId();
const form = FormApp.openById(fId);
return {
form_id: fId,
edit_url: form.getEditUrl(),
view_url: formatResponderHeaderUrl(form.getPublishedUrl(), fId)
};
}
} catch (e) {}
return null;
}
// FUNGSI PEMBERSIH OTOMATIS FILE DUPLIKAT DI GOOGLE DRIVE & SPREADSHEET
function cleanupDuplicateForms() {
const ss = SpreadsheetApp.openById(CONFIG.MASTER_SS_ID);
let trashedDriveFiles = 0;
let removedSheetRows = 0;
// 1. Hapus file Google Form kembar di Folder Drive (sisakan 1 yang paling pertama/utama)
try {
const folder = DriveApp.getFolderById(CONFIG.FOLDER_DRIVE_ID);
const files = folder.getFiles();
const seenTitles = {};
while (files.hasNext()) {
const file = files.next();
const name = file.getName().trim();
if (name.startsWith('[')) {
if (!seenTitles[name]) {
seenTitles[name] = file.getId();
} else {
file.setTrashed(true);
trashedDriveFiles++;
}
}
}
} catch (e) {}
// 2. Hapus baris kembar di tab Daftar_Form_Guru pada Spreadsheet
const sheet = ss.getSheetByName('Daftar_Form_Guru');
if (sheet) {
const rows = sheet.getDataRange().getValues();
const seenKodes = {};
for (let i = rows.length - 1; i >= 1; i--) {
const r = rows[i];
const isOldLayout = String(r[6] || '').length > 20 && String(r[7] || '').startsWith('http');
const kode = String(isOldLayout ? r[1] : (r[2] || r[1])).trim();
if (kode) {
if (seenKodes[kode]) {
sheet.deleteRow(i + 1);
removedSheetRows++;
} else {
seenKodes[kode] = true;
}
}
}
}
return {
status: 'success',
trashed_drive_files: trashedDriveFiles,
removed_sheet_rows: removedSheetRows
};
}
function publishAllExistingForms() {
const ss = SpreadsheetApp.openById(CONFIG.MASTER_SS_ID);
let count = 0;
try {
const tplForm = FormApp.openById(CONFIG.TEMPLATE_FORM_ID);
publishAndShareForm(tplForm, CONFIG.TEMPLATE_FORM_ID);
} catch (e) {}
const sheet = ss.getSheetByName('Daftar_Form_Guru');
if (sheet) {
const rows = sheet.getDataRange().getValues();
for (let i = 1; i < rows.length; i++) {
const r = rows[i];
const isOldLayout = String(r[6] || '').length > 20 && String(r[7] || '').startsWith('http');
const formId = String(isOldLayout ? r[6] : (r[7] || r[6] || '')).trim();
if (formId && formId.length > 20) {
try {
const f = FormApp.openById(formId);
publishAndShareForm(f, formId);
count++;
} catch (err) {}
}
}
}
return { status: 'success', published_count: count };
}
function getAllGeneratedFormsFromSheet() {
const ss = SpreadsheetApp.openById(CONFIG.MASTER_SS_ID);
const sheet = ss.getSheetByName('Daftar_Form_Guru');
if (!sheet) return [];
const rows = sheet.getDataRange().getValues();
const list = [];
const seenKodes = {};
for (let i = 1; i < rows.length; i++) {
const r = rows[i];
const isOldLayout = String(r[6] || '').length > 20 && String(r[7] || '').startsWith('http');
const kodeMapel = String(isOldLayout ? r[1] : (r[2] || r[1])).trim();
const namaMapel = isOldLayout ? r[2] : (r[3] || r[2]);
const namaGuru = isOldLayout ? r[3] : (r[4] || r[3]);
const kelas = isOldLayout ? r[4] : (r[5] || r[4]);
const target = isOldLayout ? r[5] : (r[6] || 36);
const formId = isOldLayout ? r[6] : (r[7] || r[6]);
const editUrl = isOldLayout ? r[7] : (r[8] || r[7]);
const rawView = isOldLayout ? r[8] : (r[9] || r[8]);
if (formId && !seenKodes[kodeMapel]) {
seenKodes[kodeMapel] = true;
const viewUrl = formatResponderHeaderUrl(rawView, String(formId));
list.push({
kode_mapel: kodeMapel,
subject_name: String(namaMapel || ''),
teacher_name: String(namaGuru || ''),
class_name: String(kelas || ''),
total_students: Number(target || 36),
form_id: String(formId),
edit_url: String(editUrl || ('https://docs.google.com/forms/d/' + formId + '/edit')),
view_url: String(viewUrl)
});
}
}
return list;
}
function processIncomingPayload(body) {
const ss = SpreadsheetApp.openById(CONFIG.MASTER_SS_ID);
const action = body.action || '';
if (action === 'list_forms') {
return { status: 'success', forms: getAllGeneratedFormsFromSheet() };
}
if (action === 'cleanup_duplicates') {
return cleanupDuplicateForms();
}
if (action === 'publish_all_forms') {
return publishAllExistingForms();
}
if (action === 'bulk_generate' || action === 'add_single_form' || action === 'generate_form') {
// Gunakan LockService agar request beruntun tidak menduplikasi form
const lock = LockService.getScriptLock();
lock.tryLock(10000);
try {
const list = body.teachers || (body.form ? [body.form] : (body.payload ? [body.payload] : []));
const sheetGuru = ensureSheet(ss, 'Daftar_Form_Guru', [
'Timestamp', 'Kode_Mapel', 'Nama_Mapel', 'Nama_Guru', 'Kelas', 'Target_Siswa', 'Form_ID', 'URL_Edit_Guru', 'URL_Ujian_Siswa', 'Status_Sync'
]);
const createdForms = [];
list.forEach(item => {
const subject = item.subject_name || item.nama_mapel || 'Mapel Ujian';
const teacher = item.teacher_name || item.nama_guru || 'Guru';
const kelas = item.class_name || item.kelas || 'XII';
const kode = item.kode_mapel || 'MPL-01';
const target = Number(item.total_students || item.target_siswa || 36);
const copyTitle = '[' + kode + '] ' + subject + ' - ' + teacher;
// 1. CEK DULU APAKAH SUDAH PERNAH DIBUAT (JANGAN DUPLIKASI LAGI!)
const existing = findExistingFormByKode(ss, kode, copyTitle);
if (existing) {
createdForms.push({
kode_mapel: kode,
subject_name: subject,
teacher_name: teacher,
class_name: kelas,
form_id: existing.form_id,
edit_url: existing.edit_url,
view_url: existing.view_url,
reused_existing: true
});
return;
}
let gFormId = CONFIG.TEMPLATE_FORM_ID;
let viewUrl = 'https://docs.google.com/forms/d/e/1FAIpQLSeQM7TUjyRj0S4AkgmwXG3Eqt6996w5sv0dQghCtq_QuJOECQ/viewform?usp=header';
let editUrl = 'https://docs.google.com/forms/d/' + CONFIG.TEMPLATE_FORM_ID + '/edit';
if (body.create_drive_copy !== false) {
try {
const templateFile = DriveApp.getFileById(CONFIG.TEMPLATE_FORM_ID);
const folder = DriveApp.getFolderById(CONFIG.FOLDER_DRIVE_ID);
const copied = templateFile.makeCopy(copyTitle, folder);
gFormId = copied.getId();
const form = FormApp.openById(gFormId);
form.setTitle(copyTitle)
.setDescription('Mata Pelajaran: ' + subject + '\nGuru: ' + teacher + '\nKelas: ' + kelas)
.setIsQuiz(true)
.setDestination(FormApp.DestinationType.SPREADSHEET, CONFIG.MASTER_SS_ID);
publishAndShareForm(form, gFormId);
editUrl = form.getEditUrl();
viewUrl = formatResponderHeaderUrl(form.getPublishedUrl(), gFormId);
} catch (errDrive) {}
}
sheetGuru.appendRow([
new Date(), kode, subject, teacher, kelas, target, gFormId, editUrl, viewUrl, 'Synced'
]);
createdForms.push({
kode_mapel: kode,
subject_name: subject,
teacher_name: teacher,
class_name: kelas,
form_id: gFormId,
edit_url: editUrl,
view_url: viewUrl
});
});
const first = createdForms[0] || {};
return {
status: 'success',
kode_mapel: first.kode_mapel,
form_id: first.form_id,
edit_url: first.edit_url,
view_url: first.view_url,
forms: createdForms
};
} finally {
lock.releaseLock();
}
}
return { status: 'success', action: action };
}
function doGet(e) {
let result = { status: 'ok', forms: getAllGeneratedFormsFromSheet() };
if (e && e.parameter && e.parameter.payload) {
try {
const body = JSON.parse(e.parameter.payload);
result = processIncomingPayload(body);
} catch (err) {
result = { status: 'error', message: err.message };
}
}
const jsonStr = JSON.stringify(result);
if (e && e.parameter && e.parameter.callback) {
return ContentService.createTextOutput(e.parameter.callback + '(' + jsonStr + ');')
.setMimeType(ContentService.MimeType.JAVASCRIPT);
}
return ContentService.createTextOutput(jsonStr)
.setMimeType(ContentService.MimeType.JSON);
}
function doPost(e) {
const body = JSON.parse(e.postData.contents);
return ContentService.createTextOutput(JSON.stringify(processIncomingPayload(body)))
.setMimeType(ContentService.MimeType.JSON);
}