Admin Panel

Commissioner tools · Google Sheets setup · Data management · Season 51

🤖 AI Import Setup (Required for Import Wizard)

Add your Anthropic API key to Netlify

The Import Wizard uses Claude AI to read your scoresheets. The AI key lives securely on Netlify — never in the site files. You only set this up once.

This is required for the Import Wizard to work. Without it you will see "Failed to fetch" errors.
  1. Get an Anthropic API key — go to console.anthropic.com, sign in, click "API Keys" in the sidebar, then click "Create Key." Copy the key — it starts with sk-ant-.
  2. Open your Netlify site settings — go to netlify.com, click your TSL site, then go to Site Settings → Environment Variables.
  3. Add the variable — click "Add variable." Set the key name to exactly: ANTHROPIC_API_KEY. Paste your API key as the value. Click Save.
  4. Redeploy the site — in Netlify go to Deploys and click Trigger deploy → Deploy site. Takes about 30 seconds.
  5. Test it — open the Import Wizard, paste a game score like "Rebels 7 Strokers 3 W: Skenes L: Snell" and click Read My Files. If it works, you are all set.
Cost: The API costs a few cents per import session. A full season of imports would cost less than $1 total.
☁️ Google Sheets Connection

Connect to Google Sheets for real-time sync

When connected, all 12 managers see the same data the moment you save it — no emailing files, no "whose version is right?" confusion. Setup takes about 5 minutes and you only do it once.

Not connected

Step-by-step setup (plain English)

  1. Open Google Sheets — go to sheets.google.com and create a new blank spreadsheet. Name it TSL Season 51.
  2. Copy the Sheet ID — look at the URL in your browser. It will look like:
    docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms/edit
    The long string between /d/ and /edit is your Sheet ID. Copy it.
  3. Get a Google API Key — go to console.cloud.google.com, create a project, enable the Google Sheets API, then go to Credentials → Create API Key. Copy the key.
  4. Share the sheet — click Share in Google Sheets, set it to "Anyone with the link can view." This lets the site read it.
  5. Paste both values below and click Save & Test Connection.
The long ID from the sheet URL
From Google Cloud Console
Only needed if you want the tracker to write back to Sheets automatically. Leave blank to use manual export.
👤 Team Personas

All 12 franchises

Each manager selects their team on the landing page and gets a personalized view. No passwords needed — the site is designed to be open for all league members.

💾 Data Management

Export all game data

Download a full backup of everything entered so far. Keep this somewhere safe — it's your record of the season.

Import / restore data

Paste previously exported data here to restore it — or use the Import Wizard for uploading scoresheets.

Data summary

Danger zone

Permanently delete all entered game data. This cannot be undone. Export a backup first.

🚀 Deploying to Netlify

How to put this site on the internet (takes 3 minutes)

  1. Download the site files — on this page, click Download Site Package below. You'll get a ZIP file called tsl-season51.zip.
  2. Go to netlify.com — create a free account if you don't have one. It's free forever for sites like this.
  3. Drag and drop — on the Netlify dashboard, there's a big box that says "Drag and drop your site folder here." Unzip the file, then drag the tsl-season51 folder into that box.
  4. It's live — Netlify gives you a URL like amazing-einstein-123abc.netlify.app. Share that link with all 12 managers.
  5. Custom name (optional) — in Netlify settings, you can change it to something like tsl-season51.netlify.app.
Note: Each manager's browser stores data locally. To share data across all managers, connect Google Sheets above — or use the Import Wizard to distribute a JSON file to everyone.