This content originally appeared on DEV Community and was authored by Rajesh Singh
The Problem: Quizzes are Fun, Making Them is Not
Let’s be real, creating quizzes in Google Forms is fine the first time. But after we’ve clicked that purple “+” button a hundred times, added multiple choice answers manually, and squinted at points for each question, the fun evaporates very soon.
Teachers, trainers, even techies - we all love quizzes. But nobody loves repetitive data entry.
So, why not automate the Google Sheets to do the boring stuff?
The Idea: Sheet In, Quiz Out
The concept is simple:
- Write the quiz questions in a Google Sheet.
- Click a shiny new menu option called Form Builder.
- Watch as a fully published Google Forms Quiz appears - sections, points, correct answers, everything.
So simple, that’s right! ✨
The Stack
This project builds on:
- Google Sheets (where the questions live)
- Google Apps Script (the automation brains)
- Google Forms (the end product: quizzes!)
And of course, it’s all open-source on GitHub: 👉 Google Forms Quiz Builder Repo
The Sheet Format (Where the Magic Begins)
The sheet starts with a few metadata rows:
| Key | Value | Notes |
|---|---|---|
FormTitle |
Math Assignment 1 | Quiz title |
FormDescription |
Maths quiz for beginner | Optional |
LimitOneResponse |
FALSE | TRUE/FALSE |
Then we add a blank row, followed by the question table:
| Section | Question | Type | Points | AnswerA | AnswerB | AnswerC | AnswerD |
|---|---|---|---|---|---|---|---|
| Easy | Which is larger: 0.3 or 0.25? | MCQ | 2 | 0.3 | 0.25 | ||
| Easy | Explain steps to get 25% as a decimal | SA | 2 | ||||
| Medium | Mark all that equal 2/3. | MSQ | 3 | *2/3 | *0.6667 | 0.65 | *0.666... |
👉 See the full format guide here: Questions.sheet-format.md
👉 The sample quiz sheet data can be found at sample_questions.csv
Oh, and notice the * before some answers? That’s how you mark the correct ones for MSQs. Sneaky but simple.
The Script
At the heart of this project is a neat Apps Script file (Code.gs).
What it does:
Reads the Sheet data.
- Creates a Google Form (from the forms template with settings or freshly generated).
- Adds sections with total points.
- Supports SA, PARA, MCQ, MSQ question types.
- Publishes the quiz automatically so students don’t get the dreaded
We’re sorry, this document is not publishederror.
Full code here: src/Code.js
The Output
Run the script and boom 💥 a new Google Form quiz is ready to go:
- Sections clearly separated with total points.
- Auto-collected emails.
- A required “Student Name” field.
- MCQs and MSQs shuffled for fairness.
- Linked responses back into the same spreadsheet.
The Demo Video
Why read when you can watch?
I recorded a full walkthrough of the project
Setup in 3 Steps
- Copy the quiz data into then google Sheet.
- Open Extensions → Apps Script, paste the code from the repo.
- Reload the sheet, click
Form Builder→Create Form (Confirm).
For the detailed step-by-step process follow: SETUP.md
Why This Matters
- For teachers: less manual and smart automation.
- For devs: a nice Apps Script case study.
🎉 Wrap Up
This was one of those projects where a tiny bit of scripting makes a huge difference.
From “ugh, more manual quiz creation” to “click and done”.
If you liked this, do me a favor:
- ⭐ Star the repo
- 📺 Watch the demo
- 🔗 Share it with someone who still builds Google Forms by hand (and save them some pain!)
This content originally appeared on DEV Community and was authored by Rajesh Singh
Rajesh Singh | Sciencx (2025-09-29T11:01:01+00:00) From Sheets to Quizzes: Automating Google Forms Like a Pro. Retrieved from https://www.scien.cx/2025/09/29/from-sheets-to-quizzes-automating-google-forms-like-a-pro/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.