// Google Apps Script — deploy as Web App → Anyone function doGet(e) { const email = e.parameter.email; const ss = SpreadsheetApp.openById('YOUR_SHEET_ID'); // 1. Authenticate: find student row const student = findStudent(ss, email); if (!student) return json({ error: 'not_found' }); // 2. Get enrolled domains/programs e.g. ['cep','live'] and ['mclp','flp_er'] const domains = student.domains.split(',').map(d => d.trim()); const programs = student.programs.split(',').map(p => p.trim()); // 3. Build one bundle — filter all sheets by domains const bundle = { student, recordings : getSheet(ss,'Recordings').filter(r => domains.includes(r.domain)), schedule : getSheet(ss,'Schedule').filter(s => domains.includes(s.domain)), resources : getSheet(ss,'Resources').filter(r => domains.includes(r.domain)), progress : getSheet(ss,'Progress').filter(p => p.student_email === email), projects : getSheet(ss,'Projects').filter(p => programs.includes(p.program_key) && p.status !== 'inactive'), }; // 4. Return everything — 1 API call total per login return json(bundle); } function json(data) { return ContentService .createTextOutput(JSON.stringify(data)) .setMimeType(ContentService.MimeType.JSON); }