The Super Bowl squares game has been a popular tradition for years, but traditional methods often lead to confusion, lack of transparency, and manual errors. I created an automated Super Bowl Squares system using Google Forms, Google Sheets, and Apps Script to streamline the process and ensure fairness.

Overview of the Automated Process

1. Sign Up via Google Form:
– Participants enter their name, email, and phone number.
– They select either $10 or $20 squares.
– Available squares are displayed, and they choose their spots.
– A security question (generated via Apps Script) ensures valid submissions.

2. Complete Payment:
– Payments are processed through Cash App or Zelle.
– Squares are held for 30 minutes until payment is verified.

3. Live Board Updates:
– Google Sheets automatically updates purchased squares.

Conditional formatting highlights

✅ Green = Available
❌ Red (Bold) = Taken

Participants can check live availability before making a selection.

Admin Automation & Tracking

– Payments are logged with timestamps.
– Names replace “OPEN” automatically in the live board.
– Reduces manual work and ensures full transparency.

Why This Solution is a Game-Changer

✅ No More Confusion – Everything updates in real-time.
✅ Fair & Transparent – All squares are publicly visible.
✅ Easy to Use – Participants simply fill out a form and pay.
✅ Scalable – Can be applied to any sports event.