Google Forms Quiz Builder + Google Classroom

Turn a Google Sheet of questions into a fully published Google Forms Quiz with points, sections, and answer keys, then post it directly to Google Classroom — all generated automatically using Apps Script.

---

✨ Features

• Define quizzes in a simple Google Sheet (Questions.sheet-format.md)
• Supports multiple question types:
  • SA – Short Answer
  • PARA – Paragraph
  • MCQ – Multiple Choice (one correct)
  • MSQ – Multiple Select (checkboxes, multiple correct)
• Image support
  • ImageURL embeds a question image
  • AnswerAImageURL..AnswerDImageURL enables image-choice mode for MCQ/MSQ (labeled A-D images + selectable A-D choices)
• Metadata support (FormTitle, FormDescription, LimitOneResponse)
• Points system with section totals
• Google Classroom integration — post quizzes as graded assignments or class materials
  • Select course, topic, due date, max points
  • One-click or two-step workflow
• Automatically:
  • Creates quiz form (from template or fresh)
  • Publishes & shares student link
  • Collects student name + email
  • Links responses to the same Sheet

🎥 Demo Video

📂 Repo Structure

google-forms-quiz-builder
├── docs
│   ├── screenshots
│   │   ├── app-script-codejs.jpg
│   │   ├── gform-quiz-generated.jpg
│   │   └── maths-assignment-sheet.jpg
│   └── SETUP.md
├── README.md
├── sample
│   ├── math_assignment1_questions.csv
│   └── Questions.sheet-format.md
└── src
    ├── appsscript.json
    └── Code.js

🚀 Quick Start

1. Open a Google Sheet and add rows as per Questions.sheet-format.md.
   (Try the sample: assignment1_questions.csv)

2. Go to Extensions => Apps Script.

   • Create a new file Code.gs
   • Paste in src/Code.js

3. Optionally enable Drive API in Advanced Services.
   See SETUP.md for details.

4. Reload the Sheet => Use the new Form Builder menu => Create Form (Confirm).

5. A fully published quiz is created 🎉

🤝 Contributing

Contributions are welcome!
Fork the repo, create a feature branch, and open a PR.

📜 License

This project is licensed under the MIT License.

Acknowledgements

• Built with Google Apps Script + Google Forms API
• Inspired by teachers wanting faster quiz creation