Setup Required: Connect to Google Sheets
To enable cross-device sync, follow these steps:
- Create a Google Sheet with headers: FirstName, LastName, StudentID, GraduationYear, Occupation, CurrentLocation, Email, Phone, CurrentJob, Company, Address, Notes, RegistrationDate
- Publish the sheet to the web (File → Publish to the web → Entire Document → CSV)
- Get the CSV URL and replace SHEET_URL in the code
- Set up a Google Apps Script for form submissions
Once configured, registrations will sync across mobile, PC, and all devices!
Your Privacy is Protected
Data is stored in a secure Google Sheet. Only your name and graduation year are visible in the public directory.
-
Registered Alumni
Public Directory
Showing names and graduation years only. Complete data is stored securely in Google Sheets.
Loading Alumni Directory...
Please wait while we load the latest data from Google Sheets.
Google Sheets Setup Guide
Step 1: Create Google Sheet
Create a new Google Sheet with these exact column headers in row 1:
FirstName | LastName | StudentID | GraduationYear | Occupation | CurrentLocation | Email | Phone | CurrentJob | Company | Address | Notes | RegistrationDate
Step 2: Publish Sheet
- In your Google Sheet, go to File → Publish to the web
- Select "Entire Document" and "Comma-separated values (.csv)"
- Click "Publish" and copy the CSV URL
- Replace SHEET_URL in the JavaScript code with your CSV URL
Step 3: Create Apps Script (for form submissions)
- Go to script.google.com
- Create a new project
- Replace the code with the provided Apps Script code
- Deploy as a web app with "Anyone" access
- Copy the web app URL and replace SCRIPT_URL in the code
Benefits of Google Sheets Backend:
- True cross-device synchronization
- Real-time data updates
- Easy admin access through Google Sheets
- Automatic backup and version history
- Export capabilities built into Google Sheets