One-time setup required — Publish your Google Sheet
The sheet is currently private. Do this once to make the dashboard work:
- Open the Google Sheet
- Click
File → Share → Publish to web
- Under "Link", choose the sheet tab →
Comma-separated values (.csv)
- Click Publish → confirm
- Come back here and click Refresh — done!
Note: "Publish to web" makes the data readable — it does not allow anyone to edit the sheet.