View the json output of a google sheet using these steps:
- Share so anyone with the link can view
- Copy the sheet ID from the share link
- Note your sheet tab (they are numerical values ie 1, 2, 3, etc)
- Use the URL below to to build the JSON link
https://spreadsheets.google.com/feeds/cells/YOURGOOGLESHEETCODE/SHEETPAGENUMBER/public/full?alt=json