Waiting for questions to loadβ¦
Complete these steps once. Your questions live in a Google Sheet β no more editing JSON!
Open your Quiz Responses Google Sheet. Click the + tab at the bottom to add a new sheet. Name it exactly: Questions
In the Questions tab, add these column headers in row 1 (exact spelling):
Question | A | B | C | D | Correct | Completed
Fill in your questions starting from row 2. The Correct column should be one letter: A, B, C, or D. Leave the Completed column empty β the host will fill it in during the game.
Make sure the sheet is shared: Share β Anyone with the link β Viewer.
In your Sheet: click Extensions β Apps Script. Delete any existing code and paste in the script from the apps-script.gs file provided.
Click Deploy β New deployment β Web app. Set Execute as: Me. Set Who has access: Anyone. Click Deploy and copy the web app URL.
Paste that URL below.
Waiting for questions to loadβ¦