Setup

Settings

Keep credentials server-side, share Scott's sheet with the service account, and verify readiness before live sync.

Environment checklist
No secret values are shown. Only boolean readiness leaves the server.
DATABASE_URLConfigured
GOOGLE_SHEETS_SPREADSHEET_IDConfigured
GOOGLE_SHEETS_DAILY_CHECKIN_SHEET_NAMEConfigured
GOOGLE_SERVICE_ACCOUNT_EMAILConfigured
GOOGLE_PRIVATE_KEYConfigured
INTERVALS_API_KEYConfigured
INTERVALS_ATHLETE_IDConfigured
Google Sheets setup
Scott's sheet sync uses a Google service account.
  1. Create or choose a Google Cloud project.
  2. Enable the Google Sheets API.
  3. Create a service account and JSON key.
  4. Set the email and private key as environment variables.
  5. Share Scott's spreadsheet with the service account as editor.
Go to imports
Intervals.icu setup
Training and wellness sync uses a personal API key.
  1. Create an API key in Intervals.icu Developer Settings.
  2. Set `INTERVALS_API_KEY` on the server or in Vercel env vars.
  3. Optionally set `INTERVALS_ATHLETE_ID`; it defaults to `0` for your API key.
  4. Use dry run on the integrations page before storing records.
Go to integrations