How to Make a Exam Result Web App with Google AppScript & Sheets | D10

A hall ticket result lookup modelled on the government examination portals students already know how to use. One field, one number, one marksheet — reading live from a Google Sheet instead of a state server.

Familiar by design

Students arriving at a result page know the pattern: enter your hall ticket number, get your marks. Copying that convention is the point — nobody needs instructions, and there are no accounts to create, distribute or reset for a cohort that may only use the page twice a year.

What comes back

A full marksheet for the matching student with subject-wise marks in a clean table. The search runs against the sheet at request time, so marks corrected by staff appear on the next lookup with nothing to redeploy.

Works where students actually are

The layout is responsive, which matters because results get checked on phones, usually several at once the moment they are published. The page stays readable at that size rather than forcing a pinch and zoom.

Who it suits

Boards, colleges and institutes publishing exam results to a large cohort, schools wanting a public results page without a management system behind it, and developers who want a clean example of a searchable Google Sheets database served as a web app.

Setup

Copy the sheet, paste in your marks, deploy as a web app and publish the link. Google Sheets is the only database. The video covers the build end to end, and support is free if you get stuck.