4 ms·
You can get a Google Sheet in JSON format just by adding alt=json to the URL. What do you do differently?
by onesmalluser 6y ago
You can get a Google Sheet in JSON format just by adding alt=json to the URL. What do you do differently?
- kabacha 6y agoHow do you do it? Seems like this feature has been shutdown?
- hanniabu 6y agoSubscribed comment because also curious
- theptrk 6y agohttps://www.freecodecamp.org/news/cjn-google-sheets-as-json-endpoint/ https://www.freecodecamp.org/news/cjn-google-sheets-as-json-... The output needs some parsing but I tried this and it works: Sheet:https://docs.google.com/spreadsheets/d/1Ze0mrYyT98Z3DupKiynCIXIy0FCLWgDk7CdzY_A3Y7U/edit#gid=0 https://docs.google.com/spreadsheets/d/1Ze0mrYyT98Z3DupKiynC... JSON:https://spreadsheets.google.com/feeds/cells/1Ze0mrYyT98Z3DupKiynCIXIy0FCLWgDk7CdzY_A3Y7U/1/public/full?alt=json https://spreadsheets.google.com/feeds/cells/1Ze0mrYyT98Z3Dup...
- richardARPANET 6y agoUnfortunately, you cannot. But don't worry we have sheet2api now for this :)