How to get public google spreadsheet data as .json from frontend?

Question

Google

Hello. There is a Google spreadsheet, which is given access to "everyone who has a link."
How to get its data as .json using XMLHttpRequest() from the frontend?

Answer 1

According to the first link in Google, it turned out that the tables have this route:
https://spreadsheets.google.com/feeds/cells/YOURGO...
Replace YOURGOOGLESHEETCODE and SHEETPAGENUMBER with yours. For example:
https://spreadsheets.google.com/feeds/cells/1g4FBk...