How to read a public Google Sheet as JSON without OAuth or an API key (2026)
Short answer: for a sheet shared as "Anyone with the link can view", call https://docs.google.com/spreadsheets/d/SHEET_ID/gviz/tq?tqx=out:json&headers=1 . It answers without a login or a key. The response is JSON wrapped in a JavaScript call, so strip the wrapper first. Below is working code, four traps we measured on 8 November 2026 (Bangkok time; the image shows the same run in UTC), and a…
We haven't written up this one. Dev.to has the full story — the link below goes straight to it.