Google-Sheet-Quiz is a Quiz Generator that serves as a free alternative to "Form Builder for Google Sheets™". This project utilizes vanilla HTML, CSS, and JavaScript to create quizzes from data stored in Google Sheets.
- Vanilla JS: I thought it would be a useful excercise to avoid any frameworks for this simple project.
- Google Sheets Integration: Store quiz questions and answers directly in Google Sheets for easy management.
- Local Storage: Retains previous quiz data in localStorage, enabling users to resume quizzes later from the same browser and device without hardcoding links in the HTML or relying on a backend.
- Add, Edit and Delete quizzes, saved in your device web browser.
...More features to come!
Find the site online hosted on Netlify.
You can also download or clone this repo, and run the site locally straight out of the box.
- Create a New Google Sheet using headers found in the template. Enter your quiz data including: questions, answers, and correct answers. Images and Points are optional (defaults to 1 point per question).
- When you are happy with the data, click the Extensions tab, and select Apps Script.
- Add the code from the code.gs file found in the repo. Name the project if desired.
- Now click Deploy and select New deployment
- Click the cog icon and select Web appropriate
- Give the deployment a description if desired, set 'Who has access' to 'Anyone', then click Deploy.
- You will receive a prompt asking for authorization. Select Authorize access.
- Select your google account.
- If presented with the 'Google hasn't verified this app' screen, to proceed click Advanced.
- Then click the link 'Go to [name here] (unsafe)'
- Click Allow
- Finally we have our Web app link! Click copy.
- Navigate to the quiz app and add a new quiz. Enter your new link in the 'Google Sheets Link' field on the Add New Quiz page on the site.
Give your quiz a name, a passing score, and submit.
Enjoy your new quiz!
Adding a quiz on mobile can be done, but it's trickier due to the lack of certain features in the Googlesheet mobile app.
I reccomend following the above steps on a desktop computer, then when you get to Step 13 send the link from the desktop device to your phone via a cross platform app.
You could do this in many ways, for example:
- Send a Whatsapp message to yourself.
- Use a note taking app like Google Keep.
- This project is a fork of subhranshuchoudhury's Google-Sheet-Quiz Project
- I created the favicon on Icons8.