Read and modify Google Spreadsheets
A simple to use library for interacting with Google Spreadsheets.
var gsheets = require'google-sheets';// authorize your accountgsheetsauthemail: <YOUR GOOGLE USERNAME>password: <YOUR GOOGLE PASS>if errthrow err;// list spreadsheets in the accountgsheetslist// sheets is an array of Spreadsheet objects;// load a specific sheetgsheetsgetSpreadsheet<YOUR SPREADSHEET KEY HERE>if errthrow err;// sheet is a Spreadsheet object....lets list all its worksheetssheetgetWorksheetsif errthrow err;// loop over the worksheets and print their titlesArrayforEachworksheetsconsole.log'Worksheet : ' + worksheetgetTitle;;// set size of first worksheetworksheets0setrows: 50cols: 50;// save itworksheet0save// worksheet now refers to the updated worksheet object// lets get its rows and add some new onesworksheetgetRowsrowscreateid: 1date: toUTCStringvalue: 'A new value'// now delete it againrowsremoverow// remove succeeded;;;;;;;
Current Google Sheets only supports authorized usage via GoogleClientLogin. It also only supports accessing spreadsheets through the private urls with the full projection. If this doesn't make any sense go read the Google Spreadsheets API documentation.
var gsheets = require'google-sheets';// authorize your accountgsheetsauthemail: <YOUR GOOGLE USERNAME>password: <YOUR GOOGLE PASS>
Rows support is operational, but is not yet stable. The interface is likely to change as I don't like the architecture currently, however it does all currently work.
Cells support is not currently implemented but is planned.