Build an online exam (CBT) app with Google Apps Script
A proper exam screen for your school or training, with the questions and every answer kept in a Google Sheet you own.
Free to start. Your projects stay in your own Google Drive.

What you get
- A question bank in a Google Sheet, shuffled for each student
- A timer, question numbers, and flags to review later
- Scores worked out right away and saved to a Results sheet
- Students sign in with their Google accounts
- Works on laptops, tablets and phones
How it works
1Describe itWrite what the app should do, or press the button and start from the request below.
2The AI builds itIt creates the project in your Google account, with a Google Sheet as the database, then writes and runs the code.
3Try it and publishCheck it in the preview with real data, ask for changes, then publish it with a link.
The request to start with
An online exam app: questions from a sheet shuffled per student, a 60 minute timer, question numbers and flags, automatic scoring, and results per class.
Code it uses
Who is using the app, and their roleAdd a row safely when many people save at onceRun a function every day at a set hourSend an HTML email from a template
Questions
How is it different from Google Forms?
It is a real exam screen: a timer, moving between numbers, flags, shuffled questions per student, and your own scoring rules.
Can teachers add questions without touching code?
Yes. Questions are rows in a Google Sheet, so teachers edit them like any spreadsheet.
Can students cheat by opening another tab?
The app can record when a student leaves the exam tab, and close the exam at a set time.
More things you can build

Build a POS app on Google SheetsA cashier screen for your shop or café that runs on Google Apps Script, with every sale saved to a Google Sheet you own.

Build an inventory app on Google SheetsKnow what is in stock, where it is and what to reorder, in an app your team opens from a link, with the data in your own Google Sheet.

Build a sales CRM on Google SheetsSee every deal from lead to won, never miss a follow-up, and keep your customers in a Google Sheet your team already knows.

Turn a Google Sheet into a web appYour spreadsheet becomes an app people open from a link: forms to add rows, tables to search, a dashboard on top, and nothing to host.

Make a quiz game from a Google SheetType the questions in a sheet, pick a game, and share a link. Scores go back to the same Google Sheet.