NFL Pick'em Pool

📋 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.