Description
A complete quiz platform on Google Sheets, with the parts that usually get skipped: OTP verification at sign-in, a question timer, a leaderboard and an admin panel for the question bank. No backend server anywhere — Sheets holds the users, the questions and the results.
What it does
Users sign in with email, password and PIN, and an OTP is emailed to verify them, which matters the moment a quiz counts for something. Questions are organised into categories, can be served in random order, and run against a timer. Results feed a leaderboard and a progress chart, and a summary goes out by email. Administrators manage users and questions from their own panel, and profile photos and files upload to Google Drive. The interface is Bootstrap 5 and works on a phone, which is where most people will take the quiz.
Highlights
- Email, password and PIN login with OTP verification
- Admin panel for users and questions
- Category-based access, random mode and a timer
- Leaderboard and progress chart
- Email alerts and quiz summary
- Profile photo and file uploads to Drive
Who it is for
Teachers, trainers, HR teams running assessments, and course creators who need a quiz that cannot simply be shared around — and developers who want a worked example of OTP verification in Apps Script.
@irfanchauhan495
via YouTube
