NYRB AMS Dashboard — Vercel Deployment Guide
What This Does
Google Sheets → Vercel API → Dashboard (live data, auto-refreshes)
Staff paste data into Google Sheets. The dashboard fetches it through
Vercel serverless functions. No API keys needed — the sheet just needs
to be set to "Anyone with the link can view."
Step 1 — Upload to GitHub
- Go to github.com and click New repository
- Name it:
nyrb-ams
- Set to Private (recommended) or Public
- Click Create repository
- On the next screen, click uploading an existing file
- Drag and drop ALL files from this folder:
nyrb-ams/
├── package.json
├── vercel.json
├── api/
│ ├── _sheet.js
│ ├── gps.js
│ ├── cmj.js
│ ├── nordbord.js
│ ├── hipforce.js
│ ├── sprint.js
│ ├── 505.js
│ ├── broad.js
│ ├── mas.js
│ └── movement.js
└── public/
└── index.html
- Click Commit changes
Step 2 — Deploy on Vercel
- Go to vercel.com → click Add New Project
- Click Import next to your
nyrb-ams repo
- Leave all settings as default (Vercel auto-detects the setup)
- Click Deploy
- Wait ~60 seconds for the first deploy
Your dashboard will be live at a URL like:
https://nyrb-ams-xxxxxxxxx.vercel.app
Step 3 — Add Your Sheet ID (Environment Variable)
The Sheet ID is already hardcoded as a fallback, but for security
it's better to set it as an environment variable:
- In Vercel, go to your project → Settings → Environment Variables
- Add:
- Name:
SHEET_ID
- Value:
1FNDKb6Vdjbq8g8RruMjrNMbhmejtmOE3tAsl5NhtP38
- Click Save
- Go to Deployments → click Redeploy
Step 4 — Verify Google Sheet is Public
- Open your Google Sheet
- Click Share (top right)
- Under "General access" → select Anyone with the link
- Set role to Viewer
- Click Done
Google Sheet Tab Names Required
| Tab Name | Data |
|---|
GPS_Daily | GPS session data |
VALD_CMJ | CMJ jump testing |
VALD_NordBord | NordBord hamstring |
VALD_HipForce | Hip abduction/adduction |
Sprint_Testing | 30m sprint splits |
505_Testing | 5-0-5 agility |
Broad_Jump | Standing broad jump |
MAS_Testing | MAS aerobic test |
Movement_Screen | Movement screen scores |
3 RPM Testing | Rep-max strength testing (Est. 1RM) |
Tab names must match exactly (case-sensitive).
Required Column Names Per Tab
GPS_Daily
Player, Date, Session, MD, Position, Total Distance, HSR, Sprint, Explosive, Dist/Min, Max Speed, Acc, Dec, HML, Minutes
VALD_CMJ
Player, Date, Age Group, Jump Height, RSI, Power
VALD_NordBord
Player, Date, Age Group, Left, Right
VALD_HipForce
Player, Date, Age Group, HAb Left, HAb Right, HAd Left, HAd Right
Sprint_Testing
Player, Date, Age Group, 0-10m, 10-20m, 20-30m, Total
505_Testing
Player, Date, Age Group, Time
Broad_Jump
Player, Date, Age Group, Distance
MAS_Testing
Player, Date, Age Group, Distance, Time, MAS
Movement_Screen
Player, Date, Session, LB Squat, LB Hinge, LB Split Squat, UB Push-up, UB Squat, UB Hinge, UB Split Squat, Notes
3 RPM Testing
Age Group, Date, GivenName, FamilyName, Exercise, Reps, Weight (lbs)
Estimated 1RM is calculated with the Epley formula: Weight × (1 + Reps / 30).
Rankings and Player Compare auto-populate one option per distinct Exercise
value found in the sheet — no code changes needed to add a new lift.
Refreshing Data
- The dashboard auto-loads fresh data every time the page opens
- Click the ↻ Loading… button in the top bar to refresh manually
- Vercel caches API responses for 60 seconds, so changes in the sheet
will appear within about 1 minute
Updating the Dashboard
Any time you change the code:
- Update the file on GitHub (drag & drop again, or use GitHub editor)
- Vercel auto-deploys within ~30 seconds
Troubleshooting
"Could not load data" error:
- Check the sheet is set to "Anyone with the link can view"
- Verify tab names match exactly (case-sensitive)
- Check Vercel function logs: Vercel dashboard → your project → Functions tab
Data shows but is empty/wrong:
- Check column header names in your sheet match the required names above
- The API is flexible with alternatives (e.g. "Name" works instead of "Player")
Testing the API directly:
Visit https://your-vercel-url.vercel.app/api/gps in a browser.
You should see JSON data. If you see an error, the sheet sharing
or tab name is the issue.
