No code · free
Live odds and player props in Google Sheets
Type =PROPLINE_ODDS("football_nfl") in a cell and get every sportsbook's line. 25+ books and 7 exchanges, player props included. Build your own line-shopping sheet in minutes.
Set up in 2 minutes
- Get a free API key at prop-line.com (1,000 requests a day, no card).
- Open a Google Sheet and go to Extensions → Apps Script. Delete what's there, paste the script, and click Save.
- Reload the sheet. A PropLine menu appears. Choose Set API key and paste your key. Google will ask you to allow the script to reach prop-line.com the first time.
- Type a formula in any cell. That's it.
Formulas
=PROPLINE_EVENTS("football_nfl")Upcoming games with their event IDs.
=PROPLINE_ODDS("baseball_mlb", "h2h,spreads,totals")Moneyline, spread and total for every game, one row per book. Add a third argument like "draftkings,fanduel" to pick books.
=PROPLINE_PROPS("football_nfl", 32663, "player_pass_yds,player_rush_yds")Player props for one game across every book.
=PROPLINE_BEST("football_nfl", 32663, "player_reception_yds")The best price and which book has it, for every line. (Hobby plan and up.)
=PROPLINE_SCORES("baseball_mlb")Live and final scores.
Sport and market keys are listed in the docs. Answers are cached for 60 seconds; each formula refresh uses one request from your daily allowance.
Ideas
- A line-shopping sheet: one tab per sport, conditional formatting on the best price.
- A bet tracker that pulls tonight's scores next to the bets you placed.
- A props board for your group chat — share the sheet as view-only.
Your key is saved with the spreadsheet. Anyone you give edit access can read it, so share view-only if the key is on a paid plan.