E Ahamed Foundation
APS Scholarship

⚙️ Setup Guide

1. Google Sheets → New blank spreadsheet
2. Row 1 headers: Timestamp | Course | Full Name | DOB | Gender | Email | Phone | WhatsApp | Aadhaar | Qualification | College | District | Pincode | Referred By
3. Extensions → Apps Script → Delete default code → Paste:

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);
  sheet.appendRow([
    new Date(),
    data.course,
    data.fullName,
    data.dob,
    data.gender,
    data.email,
    data.phone,
    data.whatsapp,
    data.aadhaar,
    data.qualification,
    data.college,
    data.district,
    data.pincode,
    data.referredBy
  ]);
  return ContentService
    .createTextOutput(JSON.stringify({status:"success"}))
    .setMimeType(ContentService.MimeType.JSON);
}

4. Deploy → New deployment → Web app
   Execute as: Me · Who has access: Anyone → Deploy
5. Copy the URL → HTML file-ൽ GOOGLE_SCRIPT_URL variable-ൽ paste ചെയ്യ്
6. Host the HTML: Netlify / Vercel / GitHub Pages (free!)