Below is a simple code to read data from google spreadsheet using javascript.
<!doctype html><html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script type="text/javascript"> var headers =["name","age"];//change this to fit the headers in the spreadsheet // ID of the Google Spreadsheet var spreadsheetID = "1uOlGdHyBcVKh3HB9-N_vkpzjyfbf5jp06Q0kjjIn-qA"; // Make sure it is published var url = "https://spreadsheets.google.com/feeds/list/" + spreadsheetID + "/od6/public/values?alt=json"; $.getJSON(url, function(json) { var placeholder = document.getElementById("placeholder"); var innerHTML = "<TABLE border='1'>"; var data = json.feed.entry; for(var r=0; r<data.length; r++) { innerHTML = innerHTML + "<TR>"; innerHTML = innerHTML + "<TD>"+r+"</TD>"; for(c=0;c<headers.length;c++) { var value = data[r]["gsx$"+headers[c]]["$t"]; innerHTML = innerHTML + "<TD>"+value+"</TD>"; } innerHTML = innerHTML + "</TR>"; } innerHTML = innerHTML + "</TABLE>"; placeholder.innerHTML = innerHTML; }); </script> </head> <body> <h1>Parse Google Spreadsheet with JavaScript</h1> <div id="placeholder"/> </body></html>