Google Sheet to JSON broken?

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

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

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

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

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

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

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

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!

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!

Hmm, this looks to be broken again. Seeing that the " Site didn’t respond" message.

Hi @gspncr, welcome to the Glitch forum!

I’m not seeing any problems right now; can you help us understand exactly what you’re seeing?