2UPiiFrC

1function initClient() {
2  var API_KEY = 'Your google api key';  
3  var CLIENT_ID = 'Your google Client id';
4
5  var SCOPE = 'https://www.googleapis.com/auth/spreadsheets';
6
7  gapi.client.init({
8    'apiKey': API_KEY,
9    'clientId': CLIENT_ID,
10    'scope': SCOPE,
11    'discoveryDocs': ['https://sheets.googleapis.com/$discovery/rest?version=v4'],
12  }).then(function() {
13    gapi.auth2.getAuthInstance().isSignedIn.listen(updateSignInStatus);
14    updateSignInStatus(gapi.auth2.getAuthInstance().isSignedIn.get());
15  });
16}
17
18function handleClientLoad() {
19    gapi.load('client:auth2', initClient);
20}
21
22function updateSignInStatus(isSignedIn) {
23  if (isSignedIn) {
24    makeApiCall();
25  }
26}
27
28function handleSignInClick(event) {
29  gapi.auth2.getAuthInstance().signIn();
30}
31
32function handleSignOutClick(event) {
33  gapi.auth2.getAuthInstance().signOut();
34}
35 
36function handleSaveClick() {
37  makeApiCall(action="write");
38} 
39
40function populateSheet(result) {
41  for(var row=0; row< 6; row++) {       //row<result.values.length
42    for(var col=0; col< 3; col++) {           //col<result.values[0].length;
43      document.getElementById(row+":"+col).value = result.values[row][col];
44    }
45  }
46}