https://www.freecodecamp.org/news/cjn-google-sheets-as-json-... The output needs some parsing but I tried this and it works:

Sheet:https://docs.google.com/spreadsheets/d/1Ze0mrYyT98Z3DupKiynC... JSON:https://spreadsheets.google.com/feeds/cells/1Ze0mrYyT98Z3Dup...