Below is how I attempted to fetch data from Google Sheets. However, this method seems to be deprecated in Sheets V4 API. It was no longer working. There might be other ways to get the data from Google Sheet.
var url = "https://spreadsheets.google.com/feeds/cells/1hA4LKZn9yKoqnSzaI6_73GQSj_ZVpB3O0kC93QM98Vs/od6/public/basic?alt=json";
$.ajax({
url:url,
dataType:"jsonp",
success:function(data) {
// data.feed.entry is an array of objects that represent each cell
},
});
How do I fetch Google Spreadsheet data from Javascript in Sheets v4 API as JSON?
feeds is deprecated in V4. See this post 404 while trying to fetch sheet data as json
function getJson(id,gid){
var txt = UrlFetchApp.fetch(`https://docs.google.com/spreadsheets/d/${id}/gviz/tq?tqx=out:json&tq&gid=${gid}`).getContentText();
var jsonString = txt.match(/(?<="table":).*(?=}\);)/g)[0]
var json = JSON.parse(jsonString)
return(json)
}