JSFiddle - React, Tailwind, and code Playground
HTML
<input id="sID" style="width: 350px;" type="text" placeholder="Spreadsheet ID" />
<input id="wID" style="width: 100px;" type="text" placeholder="Worksheet ID" value="default" />
<input id="r" style="width: 50px;" type="number" placeholder="Row" />
<input id="c" style="width: 50px;" type="number" placeholder="Col" />
<button onclick="getCell();">Go</button>
<h3>Results</h3>
<div style="margin: 10px;" id="results">
</div>
JavaScript
getCell = function(){
var api = 'https://spreadsheets.google.com/feeds/cells/';
var spreadsheet = $('#sID').val();
var worksheet = $('#wID').val();
var row = $('#r').val();
var col = $('#c').val();
var url = api+spreadsheet+'/'+worksheet+'/public/basic/R'+row+'C'+col+'?alt=json';
$.getJSON(url)
.done(function(data){
console.log(data)
if(data.entry){
$('#results').prepend(data.entry.title['$t']+': '+data.entry.content['$t']+' <br />');
}else{
$('#results').prepend('Failed to fetch data <br />');
}
})
.fail(function(){
$('#results').prepend('Failed to fetch data <br />');
});
}