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 ‘’+id+’/1/public/values?alt=json’; const id = ‘1H2xq8J5uZKDABgu1JlvV-nVWKqZoV8_UpB_D_snOrLo’; const url = ‘’+id+’/1/public/values?alt=json’; 7. … Read more

WP Twitter Auto Publish Powered By :