From Dev.to
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 respo...