Output Sheets as JSON in WebApp
The code below will output content from a Google Sheet – as JSON into a Webapp URL which is perfect to be used from any website to connect via AJAX to get the JSON data. function doGet(e) { const id = ‘1zydy1wJynoC*****7ZFzx1t7B452UdSFqSe0E3I’; const ss = SpreadsheetApp.openById(id); const sheet = ss.getSheetByName(‘data’); const rows = sheet.getDataRange().getValues(); const … Read more