Admission trend analysis and counselor performance
Admission Trend
Monthly admissions
Batch Group
Counselor Performance
Academics
Test performance, attendance and syllabus tracking · AY 2026–27
Connect Google Sheets via Apps Script
Deploy a Google Apps Script Web App for your Academics sheet and paste the URL below. View setup guide ↓
Apps Script Setup (5 min):
1. Open your Academics Google Sheet → Extensions → Apps Script
2. Paste the code below, save (Ctrl+S), then click Deploy → New deployment → Web App
3. Set: Execute as: Me · Who has access: Anyone, even anonymous → Deploy
4. Copy the Web App URL and paste it above
function doGet(e){
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sh = ss.getSheetByName("Test Performance");
if(!sh) return out({tests:[]});
const d = sh.getDataRange().getValues();
const h = d[0];
const tests = d.slice(1).filter(r=>r[0]).map(r=>{
const o={}; h.forEach((k,i)=>o[k]=r[i]); return o;
});
return out({tests});
}
function out(obj){
return ContentService.createTextOutput(JSON.stringify(obj))
.setMimeType(ContentService.MimeType.JSON);
}
Required sheet columns (row 1 headers): Date | Batch | Subject | Test Name | Student Name | Score | Max Score | Present Present column: use Y for present, N for absent
Sample data — Configure Google Sheets above to see live academic data