Event Quiz 🎉

"Who knows the star of the night best?" A party quiz that everyone plays from their phone, in Hebrew or English.

You make a quiz about the star of your event: the birthday person, the couple, the kid, the parents-to-be. At the party, the star secretly answers each question on their phone. Every guest answers the same question on their own phone and tries to guess what the star picked. The TV reveals the answer, everyone who matched gets a point, every few questions there's a funny race to the top, and at the end a podium shows who knows the star best.

Who	Opens	What they see
🎛️ Host	the website → sign in with Google → My quizzes	All quizzes, the links to send, and each quiz's control page
📺 TV	/screen/CODE	Lobby with QR code + link + code, the questions, the reveals, the leaderboard shows and the podium
📱 Guests	/join/CODE (scan the QR on the TV)	Name and selfie or emoji, big answer buttons, emoji reactions to the TV
🌟 The star	/star/CODE?token=… (secret link)	The question and their answers. They never see what guests picked

Templates set the look, the fonts, the decorations, the confetti and the starter questions: 🎂 Birthday · 🎈 Kid's birthday · 🦖 Kids · 💍 Wedding · ✡️ Bar / Bat Mitzvah · 🍼 Baby shower · 🥂 Anniversary · 🪩 Party / any event.

---

Contents

1. One-time setup: database and website
2. Turn on "Sign in with Google"
3. Turn on the AI quiz builder (Gemini, free)
4. Making a quiz
5. On the day
6. If something breaks during the party
7. Running it on your own computer
8. Decisions I made
9. How it works (for developers)

---

1. One-time setup: database and website

You need free accounts on Supabase (database, sign-in, live updates, photos) and Vercel (hosting), and this code on GitHub.

Database. Create a Supabase project, then open SQL Editor → New query and run each file in supabase/migrations/ in order of their names (open the file on GitHub → Raw → copy → paste → Run). Each should say "Success. No rows returned". Developers can instead run npx supabase link --project-ref … and npx supabase db push.

Keys. In Supabase, Project Settings → API Keys / Data API:

Supabase calls it	Environment variable
Project URL (https://abcd.supabase.co)	NEXT_PUBLIC_SUPABASE_URL
anon / Publishable key	NEXT_PUBLIC_SUPABASE_ANON_KEY
service_role / Secret key	SUPABASE_SERVICE_ROLE_KEY ⚠️ private

Website. In Vercel, import the GitHub repository, add those three variables plus APP_BASE_URL (your site's address, no trailing /), and deploy. Whenever you change a variable in Vercel, redeploy for it to take effect. The server region is in vercel.json (sin1, next to this project's Supabase); pick the region closest to your Supabase project.

2. Turn on "Sign in with Google"

Hosts sign in with Google to create and keep their quizzes. Guests, the TV and the star never need an account. This takes about 10 minutes, once.

A. Google Cloud: create the sign-in client

1. Go to https://console.cloud.google.com, sign in, and create a project (top bar → project picker → New project, name it e.g. Event Quiz).
2. Open APIs & Services → OAuth consent screen (newer consoles call it Google Auth Platform → Branding / Audience):
   • App name: Event Quiz. User support email and developer contact: your email.
   • Audience: External.
   • Under Audience, click Publish app so anyone with a Google account can sign in (not only test users). The app only asks for name, email and profile picture, so Google doesn't require a review.
3. Open APIs & Services → Credentials → Create credentials → OAuth client ID:
   • Application type: Web application.
   • Authorized JavaScript origins: your site, e.g. https://eventquiz-party.vercel.app.
   • Authorized redirect URIs: https://YOUR-PROJECT.supabase.co/auth/v1/callback (your Supabase Project URL + /auth/v1/callback).
   • Click Create and copy the Client ID and Client secret.

B. Supabase: connect it

1. Authentication → Sign In / Providers → Google: turn it on, paste the Client ID and Client secret, Save.
2. Authentication → URL Configuration:
   • Site URL: your site, e.g. https://eventquiz-party.vercel.app.
   • Redirect URLs: add https://eventquiz-party.vercel.app/** (and http://localhost:3000/** if you develop locally).

Done. Open the site and click Sign in with Google.

Quizzes made before accounts existed can be added to your list: open their admin link while signed in and press Add to my quizzes, or paste the admin link at the bottom of My quizzes.

3. Turn on the AI quiz builder (Gemini, free)

The 🤖 builder chats with you (what's the event, who's the star, who's the crowd, what kind of questions, how many) and then writes up to 30 questions plus a practice question. You untick what you don't want and create the quiz, or add them to an existing quiz from its Questions tab. It uses Google's Gemini API on the free tier.

This is the beginning of the README. Read the rest at the original. Read the full README ↗