SGStatsGuy

Google Sheets Integration

StatsGuy can export a complete game box score — team stats, player stats by category, scoring summary — directly into a Google Sheet with one click.

Connecting Your Google Account

  1. Go to Dashboard → Integrations → Google Sheets
  2. Click Connect Google Account
  3. Authorize StatsGuy to manage your Google Sheets (read/write spreadsheets only — we never access your Gmail, Drive files, or other services)
  4. You'll be redirected back to StatsGuy with a "Connected" confirmation

Your Google token is stored encrypted and is scoped only to Sheets access. You can revoke access at any time from the Integrations page.

Exporting a Game Box Score

  1. Open the game you want to export
  2. Click the Export to Sheets button in the toolbar
  3. Choose Create new spreadsheet or paste the ID of an existing one
  4. Optionally set the sheet tab name (default: "Game Stats")
  5. Click Export

The exported spreadsheet includes tabs for: Team Stats, Passing, Rushing, Receiving, Defense, Special Teams, and Scoring Summary.

Spreadsheet Structure

Each export produces a sheet with clearly labeled sections:

  • Game header (teams, date, location, final score, status)
  • Team comparison table
  • Passing stats table
  • Rushing stats table
  • Receiving stats table
  • Defensive stats table
  • Special teams table

All columns include headers. Averages are pre-calculated. The sheet is ready to share with coaches or media immediately.

Via the API

You can trigger a Sheets export programmatically:

POST /api/v1/sheets/export/game
Content-Type: application/json
X-API-Key: sg_your_key

{
  "gameId": "your-game-id",
  "spreadsheetId": "optional-existing-sheet-id",
  "sheetName": "Week 5 Box Score"
}

The response includes the spreadsheet ID and a direct URL:

{
  "spreadsheetId": "1BxiMV...",
  "url": "https://docs.google.com/spreadsheets/d/1BxiMV..."
}

Disconnecting

Go to Dashboard → Integrations and click Disconnect Google Account. This revokes StatsGuy's access token. Your previously exported spreadsheets remain in your Google Drive unaffected.