https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get has the browser code for making the API call.
It seems like it's important to initiate and authorize client before making requests now.

Noting a few important changes:

• You need an API key irrespective of the visibility of the spreadsheet
• The spreadsheet needs to be viewable by anyone with link, instead of published

bpk68/g-sheets-api#97 (comment) has highlighted and explained things in a great way 🙌🏽

Ah! There may be a way to get just CSV (via bpk68/g-sheets-api#97):

Another option is to use the Publish to Web option and select CSV.
This doesn't require a key:
https://docs.google.com/spreadsheets/d/e/2PACX-1vTkCHOZXGAAoL4mMNQLUKfOKzLHCcf9XhdvQhV_cXOwgFWTWw4M-_L9SdkPJlNvYHwVvy4D_xqS5na9/pub?output=csv

We could parse that, it wouldn't be too hard!

We'd have to link people to this page to show how to Publish to Web: https://support.google.com/docs/answer/183965?hl=en&co=GENIE.Platform%3DDesktop and include a screenshot in the docs.

Maybe using this? https://csv.js.org/parse/

Ohh, I used the CSV to make a copy, but it didn't cross my mind that we can use it in the code too 😅 Looking into it, thank you.

https://github.com/fureweb-com/public-google-sheets-parser Found this npm package, seems like it's returning the data in a very nice way. Tried it out at https://api.fureweb.com/#/spreadsheets/spreadsheetId

Noting also that the FracTracker layer uses a spreadsheet and is also failing: #668

@jywarren and @TildaDares I'm looking foward to work on my contributions. Just looking for a second issue to solve. I found this one and wondering can I claim this issue?

Hi @julianavmgiusti I appreciate it -- it's probably a pretty complex issue, but if you'd like to try using https://github.com/fureweb-com/public-google-sheets-parser, we would love your help! Thank you!

Hi @jywarren ok I'm outreachy applicant, so the project that is on the program is Improve MapKnitter Lite for mapmaking with aerial photos as a lightweight web service and I just found one, I metioned you on comment, can you help me to contribute to this project?