News for hackers. Stuff that matters.

A comment on Show HN: SheetUI – Turn Google Sheets into Web Pages. Parent comment

Re:Show HN: SheetUI – Turn Google Sheets into Web Pages by chris_st on Tuesday July 07, 2020 @08:57PM (#23765942)
I have a personal website backed by a Google sheets page; however, it started not handing out proper CORS headers on the request, so it no longer works for me.

Have you run across this? How did you solve it? Thanks!

[ Parent | on HN ]
Re:Show HN: SheetUI – Turn Google Sheets into Web Pages by tjchear on Wednesday July 08, 2020 @01:46AM (#23767230)
I have not run across this issue before. How are you accessing the sheets though? Cloud Sheets API, or the json-in-script endpoint?
[ Parent | on HN ]
Re:Show HN: SheetUI – Turn Google Sheets into Web Pages by chris_st on Wednesday July 08, 2020 @08:38AM (#23769258)
From the File menu, choose "Publish to the web", and then choose ".csv" format. This gives you a URL that (up until recently) you could pull with either "curl" (etc.) or from a web page (e.g., an SPA). Now the SPA thing fails with a CORS error. Other people on the web have seen it too.

Thanks!

[ Parent | on HN ]