miku miku - 10 months ago 125
JSON Question

google spreadsheet json format (How to open)

I have a publicly shared excel sheet which i want to retrieve in JSON format. I tried following instruction here but it didn't work.
Can somebody please guide me on this.
My sheet: https://docs.google.com/spreadsheets/d/1PDKO3PK-ZvRmZddpqMlEdjsOhXAJngw7ajU3opY-J1M/pubhtml

any tutorial on the latest way of doing something like :

Thank you in advance :)


I just tried it with my own spreadsheet, and this seems to work:


Just insert your spreadsheet ID from your spreadsheet:


EDIT: Tried it with yours as well - works!