Connect Your Google Sheet
Follow these steps to link your schedule spreadsheet to this site. Once connected, any changes you make in Google Sheets will automatically appear here within 5 minutes.
Create your Google Sheet
Open Google Sheets and create a new spreadsheet. Your sheet must have these columns in this exact order — row 1 should be your header row.
Format your columns
Add a header row with these column names (spelling doesn't matter — only the column order matters):
Publish your sheet to the web
In Google Sheets, go to File → Share → Publish to web. In the dialog, select your sheet tab, choose "Comma-separated values (.csv)" format, then click Publish. This makes your data publicly readable — no login required.
Copy your Sheet ID
Look at your Google Sheet's URL in the browser address bar. The Sheet ID is the long string of letters and numbers between /d/ and /edit.
Paste your Sheet ID into the code
Open src/pages/index.tsx in the code editor. Near the top of the file, find the line that says const SHEET_ID = 'YOUR_SHEET_ID_HERE' and replace YOUR_SHEET_ID_HERE with your actual Sheet ID.
Required column format
| Col | Name | Example | Notes |
|---|---|---|---|
| A | Date | 2026-08-01 | Any date format works |
| B | Time | 7:00 PM | Free text |
| C | Sport | Soccer | Used for color badges |
| D | Home Team | LA Galaxy | |
| E | Away Team | LAFC | |
| F | Channel | ESPN | Free text |
| G | Link | https://espn.com | Full URL — shows Watch button |
| H | Notes | Rivalry game | Optional |
Tips for best results
- Keep row 1 as your header row — the site skips it automatically.
- Leave the Link column empty if there's no watch link — the Watch button won't appear.
- Sport names like Soccer, Football, Basketball, and Baseball get automatic color badges.
- The schedule auto-refreshes every 5 minutes, so updates appear quickly without reloading.
- You can add or remove rows at any time — changes sync automatically.