Google Sheet mapping guide
How to fill the sheet so tips, stats, and categories appear correctly on BetWise Pro.
History & archive
Move row to yesterday (hide from today)
Set column Y to V or TRUE. The row leaves today's categories. For Yesterday Results, column X must be a winning pick (e.g. 1X - V).
Y = V | TRUE
Stats page (/stats)
A row appears when the category is active AND the pick has result V (win) or X (loss) — either as suffix on the bet (e.g. - V) or in the result column.
Win / loss (V / X)
- On the bet cell: add - V or - X at the end (e.g. 1X - V).
- Or put only V or X in the dedicated result column for that category.
- Win (V) / Loss (X)
Main columns
| Col | Name | Use |
|---|---|---|
| A | Match | Required — match name |
| L | Date / time | Display & stats date filter |
| X | Top Picks | Bet text; not FALSE |
| Y | Yesterday | V or TRUE = archive |
| P | Over 2.5 | TRUE, V, TRUE-, or - V / - X |
| T | BTTS | TRUE, V, or TRUE- |
| AB | Draw Hunter | TRUE, TRUE-, - V, - X |
| AK | Home ticket | TRUE or V to include |
| AL | Ticket text | Per-match pick text |
| AP | Ticket odds | Odds per leg |
| AM | Live bet | Any non-empty text |
| AN | Safe bet | V or TRUE |
| AO | Safe bet text | Display label |
| AR | Simon picks | TRUE or V |
| AS | Simon bet | Bet text + optional - V/- X |
| AW | Winner tips | TRUE or V |
| AZ | Basketball | Match name if active |
| BD | Tennis | Match name if active |
Category rules
TOP PICKS
Column X not empty and not FALSE. Hidden if Y = V.
Columns: X, Q, AG
OVER 2.5
P = TRUE, V, TRUE-, or contains - V / - X.
Columns: P, R, AC
BTTS
T = TRUE, V, or starts with TRUE-.
Columns: T, Z, AE
DRAW HUNTER
AB = TRUE, TRUE-, or contains - V / - X.
Columns: AB, AA, AF
LIVE BET
AM not empty.
Columns: AM, AQ
SAFE BET
AN = V or TRUE.
Columns: AN, AO
REST OF WORLD
AR = TRUE or V.
Columns: AR, AS, AV
WINNER TIPS
AW = TRUE or V.
Columns: AW, AX, AY
BASKETBALL
AZ not empty.
Columns: AZ, BB, BC
TENNIS
BD not empty.
Columns: BD, BF, BG, BH
HOME TICKET
AK = TRUE or V (same as High Odds page).
Columns: AK, AL, AP
YESTERDAY RESULTS
Y = V/TRUE, X has pick, X is a win.
Columns: Y, X, Q
Quick actions
- Today's Top Pick: fill X, leave Y empty.
- Archive after match: Y = V.
- Stats win/loss: add - V or - X, or result column V/X.
- Home ticket / High odds: AK = TRUE, text in AL, odds in AP.
- Safe bet: AN = V or TRUE, display text in AO.