Create new spreadsheet via GDrive REST API in Javascript?

Question

I want to create a new spreadsheet in Google Drive, using the V4 REST API in Javascript. I can write data to an existing one, since I have an id, like this, once oauthed:

var accessToken=gapi.auth.getToken().access_token;
var str="https://sheets.googleapis.com/v4/spreadsheets/"+id+"/values/Sheet1!A1:E50?valueInputOption=USER_ENTERED";
var xhr=new XMLHttpRequest();
xhr.open("PUT",str);                                                                
xhr.setRequestHeader('Authorization','Bearer '+ accessToken);
xhr.send(JSON.stringify(data));

But I don't know how to create one from scratch in Javascript.

Tanaike · Accepted Answer · 2018-02-04 08:26:24Z

1

I understood that you want to create new Spreadsheet. If my understanding is correct, how about this modification?

Sample script :

var data = {"properties": {"title": "### filename of new spreadsheet ###"}}; // Added
var accessToken=gapi.auth.getToken().access_token;
var str="https://sheets.googleapis.com/v4/spreadsheets"; // Modified
var xhr=new XMLHttpRequest();
xhr.open("POST",str); // Modified
xhr.setRequestHeader('Authorization','Bearer '+ accessToken);
xhr.send(JSON.stringify(data));

Note :

If the error related to scopes occurs, please check the reference.
data in this sample is very simple. So please modify it for your environment.

Reference :

spreadsheets.create

If I misunderstand your question, I'm sorry.

answered Feb 4, 2018 at 8:26

Tanaike

203k12 gold badges126 silver badges222 bronze badges

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

Comments

MαπμQμαπkγVπ.0 · Accepted Answer · 2018-02-04 12:12:53Z

0

To create a new spreadsheet, you can follow this documentation.

Creates a spreadsheet, returning the newly created spreadsheet.

It requires one of the following OAuth scopes:

https://www.googleapis.com/auth/drive

https://www.googleapis.com/auth/drive.file

https://www.googleapis.com/auth/spreadsheets

For more information, see the Auth Guide.

For the sample code, see the example in the said documentation.

answered Feb 4, 2018 at 12:12

MαπμQμαπkγVπ.0

6,7831 gold badge29 silver badges82 bronze badges

Collectives™ on Stack Overflow

Create new spreadsheet via GDrive REST API in Javascript?

2 Answers 2

Sample script :

Note :

Reference :

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Sample script :

Note :

Reference :

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related