// AI news · 2026-11-08 · Dev.to AI
Read public Google Sheets as JSON without OAuth or API key
Public Google Sheets can be read as JSON via Google Visualization API without OAuth or API key, using a shared link with 'Anyone with the link can view' access.
Published 2026-11-08 01:52 (Beijing time)Source Dev.to AIAuto-summarised, fact-checked against source
01Summary
The response is wrapped in JavaScript and requires parsing. Apify provides an Actor that handles header cleanup, date conversion, empty column removal, and row size limits.
Summarised from the original article by an open-source model, then checked automatically: every number and English name must appear in the source. The original article is authoritative.
02Key points
- Works only for publicly shared sheets with view access
- Response is JSON wrapped in JavaScript; must be stripped first
- Dates arrive as strings like Date(2024,0,15) and need conversion
- Apify Actor handles parsing, formatting, and row size limits
03Source
How to read a public Google Sheet as JSON without OAuth or an API key (2026)
Dev.to AI · published 2026-11-08 01:52 Beijing time
05Related news
- Same source · A world grows from two people in EON2026-11-08 · Dev.to AI
- Same source · Ask for a Ledger, Not a Demo2026-11-08 · Dev.to AI
- Same topic · LLM Judge Evolves from Laptop to Under ₹1 per Chat2026-11-08 · Dev.to LLM
- Same topic · Google Messages Homepage Redesign2026-11-08 · 9to5Google
- Same day · Cost Model Based on Slot Time for Free AI Lanes2026-11-08 · Dev.to AI
From AIMap AI news: collected from 1,100+ official and media sources. Summaries only restate the original article; follow the link for the full story. All stories of 2026-11-08 · Archive by date · All AI news · Today