How to create JSON feed from Google Sheets Data
Create a Google Sheet Under File Menu Select ‘Publish to the web” Select under Link Sheet and as Web Page – Click Publish Check the URL provided to ensure page is visible on the web Copy Sheet ID Place the id in the JSON URL ‘https://spreadsheets.google.com/feeds/list/’+id+’/1/public/values?alt=json’; const id = ‘1H2xq8J5uZKDABgu1JlvV-nVWKqZoV8_UpB_D_snOrLo’; const url = ‘https://spreadsheets.google.com/feeds/list/’+id+’/1/public/values?alt=json’; 7. … Read more