Google Sheets to HTML

HTML_Content_From_gSheet.html

<style>
	body {
		font: 16px/24px Helvetica, Sans-Serif;
		padding: 30px;
	}
</style>

<script
src="https://code.jquery.com/jquery-2.2.4.min.js"
integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44="
crossorigin="anonymous"></script>

<h2>Google Sheet to HTML</h2>
<p>
	The following page content is generated from a google sheet using google sheet's json feed url for a publicly published document.
</p>
<p>
	Original Google Sheet Document: <a href="https://docs.google.com/spreadsheets/d/1ZmdmQm3sVlGcUpiQBOd9JRFCSQJ5_HLeUjUXfvNic_I/edit#gid=0">https://docs.google.com/spreadsheets/d/1ZmdmQm3sVlGcUpiQBOd9JRFCSQJ5_HLeUjUXfvNic_I/edit#gid=0</a>
</p>

<hr>

<div class="results"></div>

<script>

 // ID of the Google Spreadsheet
 var spreadsheetID = "1ZmdmQm3sVlGcUpiQBOd9JRFCSQJ5_HLeUjUXfvNic_I";

 // Make sure it is public or set to Anyone with link can view
 var url = "https://spreadsheets.google.com/feeds/list/" + spreadsheetID + "/od6/public/values?alt=json";

 $.getJSON(url, function(data) {
 	console.log('--> data', data)
 	var entry = data.feed.entry;

 	$(entry).each(function(){
	    // Column names are name, age, etc.
	    $('.results').append('<h2>'+this.gsx$title.$t+'</h2><p>'+this.gsx$description.$t+'</p>');
	});
});

</script>