Home | Professional Portfolio | Automations
Professional Portfolio: Super Bowl 2025 Squares
- Google Forms. User input collection & validation
- Google Sheets. Data automation & real-time updates
- Apps Script. Custom security question & automated updates
- Array Formulas. Live board synchronization
- Conditional Formatting. Instant visual feedback on availability.
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
- 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.
- Complete Payment
- Payments are processed through Cash App or Zelle.
- Squares are held for 30 minutes until payment is verified.
- 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.