How to make POST requests to google spreadsheets using JavaScript?

Question

I am trying to post some data from the client side to the google spreadsheet. After looking hard through their documentation for v4 I haven't found a way.

Which server side language you use? They have given some language options but php and java script developers.google.com/sheets/quickstart/php , developers.google.com/sheets/quickstart/js might help? — Jitesh Sojitra
– Jitesh Sojitra, Commented Aug 9, 2016 at 18:28
Im using javascript, however those links have very limited methods and no POST option. — psheth
– psheth, Commented Aug 9, 2016 at 19:38

gazdagergo · Accepted Answer · 2019-12-19 08:39:07Z

11

How to Write to to a Cell Using Spreadsheet API in JS

In essence, you have to know XHR. I'll give you an example. Let's say you want to write to A1:B1 range of your spreadsheet, say [A1]Hello [B1]World.

Your URI request would look like this:

PUT https://sheets.googleapis.com/v4/spreadsheets/{SPREADSHEET_ID}/values/Sheet1!A1:B1?valueInputOption=USER_ENTERED

request body:

{
           "range":"Sheet1!A1:B1",
           "majorDimension": "ROWS",
           "values": [
           ["Hello"," World"]
          ]
}

Did this in oauthplayground using Google Sheetsv4 and it worked.

How to apply this in JS?

After setting up the JS Quickstart find a way to call this inside a function:

var params = {
           "range":"Sheet1!A1:B1",
           "majorDimension": "ROWS",
           "values": [
           ["Hello","World"]
          ],
     }
  var xhr = new XMLHttpRequest();
  xhr.open('PUT', 'https://sheets.googleapis.com/v4/spreadsheets/{SPREADSHEET_ID}/values/Sheet1!A1:B1?valueInputOption=USER_ENTERED');
  xhr.setRequestHeader('Authorization', 'Bearer ' + access_token);
  xhr.send(JSON.stringify(params));

Also read Reading & Writing cells in Sheets v4. Hope this crash course helps.

edited Dec 19, 2019 at 8:39

gazdagergo

6,7811 gold badge36 silver badges50 bronze badges

answered Aug 10, 2016 at 10:58

ReyAnthonyRenacia

17.7k6 gold badges42 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Beckham_Vinoth Over a year ago

While Trying your code am Getting error as ReferenceError: access_token is not defined How can i solve that @noogui

ReyAnthonyRenacia Over a year ago

@Becky that's because access_token is my user-defined variable. var access_token = 'ya29.CabcdabcdefgkMHMeDNxC1koDhrS3fM-7pjzMFAfCgVPxnNM2dAxyzaldlRBvxKLcyA'; ..You have to find a way to generate your own.

Beckham_Vinoth Over a year ago

Thanks....and I don't know how to create my own access_token ? How can i make that ? Any idea's ?

ReyAnthonyRenacia Over a year ago

@Becky follow my other guide here.

ReyAnthonyRenacia Over a year ago

Remember, that access token from oAuthPlayground is good for only 1 hour.

|

Collectives™ on Stack Overflow

How to make POST requests to google spreadsheets using JavaScript?

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related