NFL Pick'em Pool

🔧 Debug: Test Pick Submission

Use this to test if picks can be written to the sheet:

Debug Pick (bypass validation) Test Regular Pick (with validation)

Debug = bypasses validation. Regular = uses exact same format as real picks. Check Apps Script logs for errors!

🧪 Test Mode (Off-Season Testing)

Use this to create fake game data for testing when the season is over:

How to use:

1. Click "Generate & Preview" to create test games and see them below
2. Click "Send to Google Sheet" to automatically add them to your Games sheet
3. Or manually copy the data and paste into your Google Sheet

Test games start 1 hour from now, spaced 30 minutes apart. Perfect for testing deadline enforcement!

📋 Setup Instructions

Step 1: Set up Google Apps Script (one-time)

1. Open your Google Sheet
2. Click Extensions → Apps Script
3. Delete any existing code
4. Copy the code from google-apps-script.js file
5. Paste it into Apps Script and click Save
6. Click Deploy → New deployment
7. Select type: Web app
8. Execute as: Me
9. Who has access: Anyone
10. Click Deploy and authorize the script
11. Copy the Web App URL

Step 2: Configure this website

1. Get your Google Sheet ID from the URL (the long string between /d/ and /edit)
2. Open index.html in a text editor
3. Find the CONFIGURATION section at the top of the script
4. Replace YOUR_SHEET_ID_HERE with your Sheet ID
5. Replace YOUR_APPS_SCRIPT_URL_HERE with your Web App URL
6. Save and re-upload to GitHub

Step 3: Share your Google Sheet

1. Click the Share button in your Google Sheet
2. Change to "Anyone with the link" can VIEW
3. The Apps Script handles all writing

🏈 How to Use (Weekly Workflow)

Before the week starts:

1. Open your Google Sheet
2. Click the 🏈 NFL Pick'em menu at the top
3. Click Scrape Lines from ESPN
4. Enter the week number (1-18)
5. ✅ Games automatically populate with spreads!

Users make picks:

1. Users visit this website
2. Enter their name
3. Select 3 games against the spread
4. Click "Submit Picks"
5. ✅ Picks automatically saved to Google Sheet!

After games finish:

1. In Google Sheet, update the Winner column in "Games" tab
2. Enter "away" or "home" for each completed game
3. Click 🏈 NFL Pick'em → Calculate Scores
4. ✅ Standings update automatically!

✅ Fully Automated! Everything happens in Google Sheets or automatically from the website. No manual data entry needed!

🎯 Scoring System

• 1 point for each correct pick
• +1 bonus point if all 3 picks are correct
• Total possible: 4 points per week (3 wins + 1 parlay bonus)

📊 Current Configuration

Sheet ID:

${SHEET_ID}

Apps Script URL:

${SCRIPT_URL}

To change these, edit the HTML file and re-upload to GitHub.