Google Drive API
Go to: https://console.developers.google.com/
Create a new project
Enable Google Drive API
Create credentials
Which API are you using? Google Drive API
Where will you be calling the API from? Web Server
What data will you be accessing? Application Data
Are you planning to use this API with App Engine to Compute Engine? No
Click: What credentials do I need?
Name: Sheets
Role: Project Editor
Download JSON
Copy JSON file to project folder
Init NPM: init npm –yes
npm install google-spreadsheet
https://github.com/googleapis/google-api-nodejs-client/tree/master/samples
https://github.com/gsuitedevs/solutions
https://github.com/gsuitedevs/solutions/tree/master/calendar-timesheet
https://github.com/gsuitedevs/solutions/tree/master/timesheets
Resources and References:
https://developers.google.com/drive/v3/web/simple-upload
Setup API
Google Sheets and JavaScript with Node.js:
https://www.youtube.com/watch?v=UGN6EUi4Yio