function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data  = JSON.parse(e.postData.contents);
  if(sheet.getLastRow() === 0) {
    sheet.appendRow(['Timestamp','App No','Class','Board','Stream',
      'Year','Student Name','Father Name','Mother Name','DOB',
      'Mobile','Email','Address','Roll No','School/College',
      'University','Percentage','Total Marks','Max Marks']);
  }
  sheet.appendRow([
    new Date().toLocaleString(),
    data.appNo, data.cls, data.board, data.stream, data.year,
    data.name, data.father, data.mother, data.dob,
    data.mobile, data.email, data.address, data.roll,
    data.school, data.univ||'', data.percent,
    data.totalMarks||'', data.maxMarks||''
  ]);
  return ContentService
    .createTextOutput(JSON.stringify({status:'success',appNo:data.appNo}))
    .setMimeType(ContentService.MimeType.JSON);
}
function doGet(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var vals  = sheet.getDataRange().getValues();
  if(vals.length < 2) return ContentService
    .createTextOutput(JSON.stringify({status:'success',data:[]}))
    .setMimeType(ContentService.MimeType.JSON);
  var headers = vals[0];
  var rows = vals.slice(1).map(function(row){
    var obj={};
    headers.forEach(function(h,i){obj[h]=row[i];});
    return obj;
  });
  return ContentService
    .createTextOutput(JSON.stringify({status:'success',data:rows}))
    .setMimeType(ContentService.MimeType.JSON);
}