In https://developers.google.com/gdata/samples/spreadsheet_sample
it gives a way to get access to a google sheet. ERROR: The current sample URL is not working reliably. (sometimes it works, sometimes it doesn't) === Furthermore, this "feed" url has been used for a while an in several places to get a JSON representation of a worksheet. See https://cwestblog.com/2018/03/25/google-sheets-data-as-json-jsonp/ The examples in item #8 are not working anymore. === I'm using this related to this javascript package: https://github.com/bpk68/g-sheets-api/ I made a simple notebook that uses this feed url here: https://observablehq.com/d/ba380d098775fcd0#cell-85 If the list of classes loads, then the https://spreadsheets.google.com/feeds/cells/1_IpENDkoujmWr-B0M2ZVcyvgPQGeKwYxfHX_JYTDtRc/1/public/values?alt=json works. It it gives an error, then there is likely a 404 error. See also https://github.com/bpk68/g-sheets-api/issues/97 -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/8a49f295-1ec4-4820-a6cd-687347329bbdn%40googlegroups.com.
