Hi,
My goal is simply to read cells in a Google sheet of my account and display
them in a html block of a Wordpress website so that anyone can see the
values of the cells.
I have set up a "service account" on *console.developers.google.com*, and
my code is the following, but it doesn't work :
<html>
<head>
<script type="text/javascript">
function loadSheetsAPI() {
gapi.client.setApiKey('my-api-key');
var discoveryUrl =
'https://sheets.googleapis.com/$discovery/rest?version=v4';
gapi.client.load(discoveryUrl).then(getCounter);
}
function getCounter() {
gapi.client.sheets.spreadsheets.values.get({
spreadsheetId: 'my-sheet-id',
range: '!H2:I2',
}).then(function(response) {
var range = response.result;
if (range.values.length > 0) {
for (i = 0; i < range.values.length; i++) {
var row = range.values[i];
appendPre(row[1] + '\n' + row[0]);
}
} else {
appendPre('No data found');
}
}, function(response) {
appendPre('Error: ' + response.result.error.message);
});
}
function appendPre(message) {
var pre = document.getElementById('output');
var textContent = document.createTextNode(message + '\n');
pre.appendChild(textContent);
}
</script>
<script src=
"https://apis.google.com/js/client.js?onload=loadSheetsAPI";>
</script>
</head>
<body>
<pre id="output"></pre>
</body>
</html>
Could someone help me please ?
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
