JSFiddle - React, Tailwind, and code Playground

Retrieve JSON data from Google Spreadsheet

by tonytlwu

HTML

<pre id="debug"></pre>

JavaScript

/*
	See https://coderwall.com/p/duapqq/use-a-google-spreadsheet-as-your-json-backend for instructions
*/

var key = '11ipH-ih6ObZVGZHOUkSjh1YJVu2fLk0VVJ9W_9bnLbM';
var url = 'https://spreadsheets.google.com/feeds/list/'+key+'/od6/public/values?alt=json';
var webpageUrl = 'https://docs.google.com/spreadsheets/d/'+key+'/pubhtml';

var composedData = [];

$.getJSON({
	url : url,
  success : function(data){
  	for (var i in data.feed.entry) {
    	var entry = {};
    	for (var key in data.feed.entry[i]) {
      	if (key.indexOf('gsx') > -1) {
        	entry[key.split('$')[1]] = data.feed.entry[i][key]['$t'];
        }
      }
      composedData.push(entry);
    }
    $('#debug').html(JSON.stringify(composedData,'','  ')).before('<a href="'+webpageUrl+'" target="_blank">See spreadsheet data</a>');
  }
});