CODEWITHSUNDEEP
node.jsgoogle-sheetsgoogle-sheets-api
Anand Sunderraman
Anand Sunderraman

Reputation: 8148

Google Spreadsheet Creation - Node.js

I am trying to create new google spreadsheet using the google spreadsheet api using node.js

I have managed to get the Google OAuth 2.0 working, where I am getting the access tokens for the clients.

Now on searching the Google API docs there are example using the gData client library but nothing giving me pointers to node.js

Here are my findings for creating a new google spreadhseet

  1. Upload a spreadsheet manually OR
  2. Use a resumable upload link

There is not much information on the resumable upload link.

I can see the HTTP Post Request and Response but I do not understand how to construct the post request in node.js

EDIT--

I am reading Google Apps Platform

Upvotes: 1

Views: 2181

Answers (4)

Rohit Parte
Rohit Parte

Reputation: 4076

If you are new and want to get and add data to Google spreadsheets, please refer below link to get step-by-step guide.

https://www.twilio.com/blog/2017/03/google-spreadsheets-and-javascriptnode-js.html

I was tested same in recent nodejs project

Upvotes: 0

Daniel Apt
Daniel Apt

Reputation: 2658

Here is how to do it with the create method of the Google Sheets API (currently v4).

This code examples does not use any 3rd party libraries, it uses googleapis: Google API's official Node.js client

const google = require('googleapis');
const sheets = google.sheets('v4');

// authenticate, and store that authentication, in this example
// it is stored in a variable called `auth`. I am using JWT 
// authentication, but you can use the any form of authentication

const auth = new google.auth.JWT(
  key.client_email,
  null,
  key.private_key,
  ['https://www.googleapis.com/auth/spreadsheets'], // make sure that your auth scope includes `spreadsheets`, `drive` or `drive.file`
  null
);

sheets.spreadsheets.create({
  auth: auth,
  resource: {
    properties: {
      title: 'Title of your new spreadsheet'
    }
  }
}, (err, response) => {
  if (err) {
    console.log(`The API returned an error: ${err}`);
    return;
  }

  console.log('Created a new spreadsheet:')
  console.log(response);
});

Upvotes: 2

jpillora
jpillora

Reputation: 5262

Checkout

https://github.com/EastCloud/node-spreadsheets/

EastCloud has written a friendly-ish wrapper around the Google Docs/Drive API

Upvotes: 0

vinayr
vinayr

Reputation: 11244

If all you want to know is how to construct post request, then check this example

http://nodejs.org/api/http.html#http_http_request_options_callback

Upvotes: 0

Related Questions