Google Sheet to JSON broken?

#1

Hello, I have been using your spreadsheet feature perfectly for the last few weeks and it has successfully been pulling data from my spreadsheet. Today it has suddenly stopped working? Are you aware that it’s broken - the sheet that was working is now not pulling in any data
https://spreadsheet.glitch.me/?key=1JBbAHH1DFtO1r56lr94lUqd8H7qPcHncJskcPq0r96o

#2

Hi @ldthompson, welcome to the Glitch forum!

Thanks for the report and sorry for the bother! We’ll take a look and let you know what we find.

1 Like
#3

I am seeing an error starting the project, could this be affecting it?

#4

Hi Callum, this is what I’m referring to. Before today this was working fine and suddenly it stopped so I assumed it was a problem I couldn’t fix. I will test with a new spreadsheet

#5

can you invite me to the project so I could take a closer look?

#6

There’s some sort of issue with Tabletop loading the sheet, but I haven’t gotten to the bottom of it yet. @Callum-OKane this isn’t @ldthompson’s project; they’re just using it to get the JSON from the spreadsheet data.

1 Like
#7

Hi Cori, yes I have just made a new spreadsheet and same issue is present. Great that the issue has been identified tho! :grinning:

#8

It looks like this is a problem with Google Sheets: https://support.google.com/docs/thread/5152040?hl=en and https://issuetracker.google.com/issues/131613284. I’m seeing the same data (“Internal Error”) when viewing the json view of a public published sheet when not logged in.

I think we’ll just need to wait until Google notices this and works it out. Sorry for the bother!

#9

Hey folks, it looks like Google has fixed the issue, or at least my Remix appears to be operating correctly now. It’s probably worth another attempt.

Thanks for the report, and happy Glitching!