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

  1. Copy the template sheet. The add-on comes with the copy.
  2. Extensions, SportsDataHQ, Set API keys. Paste a free key for the API you want (500 credits a month, no card).
  3. 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

Privacy and terms

Add-on privacy policy · Add-on terms. Questions: hello@sportsdatahq.com.