Google Sheets
Sports data as a live table in your sheet.
Type =SDHQ("dunkapi","get_standings") and the answer fills the cells: a header row, then one row per record. Every tool of every SportsDataHQ API works this way.
Make a copy of the template sheet · Source code
A copied sheet runs the add-on under its own script project, so the first run shows “Google hasn't verified this app”: choose Advanced, then Go to SportsDataHQ. The add-on only reads the sheet you are in and calls the SportsDataHQ APIs (privacy policy, source).
How it works
- Copy the template sheet. The add-on comes with the copy.
- Extensions, SportsDataHQ, Set API keys. Paste a free key for the API you want (500 credits a month, no card).
- Type a formula, for example
=SDHQ("endzoneapi","get_player_stats","player_id","00-0033873","season",2025).=SDHQ_TOOLS("puckapi")lists every tool and what it costs.
Each call uses credits from that API's account, at the same price as a REST call. Results are cached for an hour so a sheet that recalculates does not pay again; =SDHQ_REFRESH() clears the cache. Your keys are saved to your own Google account, never into the sheet, so sharing a sheet never shares a key.
APIs
puckapifor PuckAPIendzoneapifor EndzoneAPIfighterapifor FighterAPIdunkapifor DunkAPIfastballapifor FastballAPIstrikerapifor StrikerAPIacesapifor AcesAPIbirdieapifor BirdieAPIyorkerapifor YorkerAPI
Privacy and terms
Add-on privacy policy · Add-on terms. Questions: hello@sportsdatahq.com.