A cached Google Spreadsheets table over segmentio/google-spreadsheets.
$ npm install segmentio/google-spreadsheets-table
var Table = require('google-spreadsheets-table');
var table = Table(worksheet)
.headerRow(1)
.idColumn(1)
.flushAt(ms('10s'));
table.set('hearthrob', { email: 'gordon@papyrushealth.com'});
table.set('hearthrob' { name: 'Gordon Hearthrob'});
table.set('calvin4', { email: 'calvin@segment.io'});
table.set('calvin4' { name: 'Calvin French-Owen'});
table.flush();
var spreadsheets = require('google-spreadsheets');
var Table = require('google-spreadsheets-table');
spreadsheets
.login('username', 'password')
.key('0AvP3ixW_RotVdHdnWDZvUHhnWWhHQy0xZFViN3hUSmc')
.open(function (err, spreadsheet) {
var worksheets = spreadsheet.worksheets;
var worksheet = spreadsheet.select(worksheets[0].id);
var table = Table(worksheet);
});
Create a cached Google Spreadsheet around a worksheet.
Set the attrs
on the spreadsheet row associated with id
.
Flushes the update changes to the spreadsheet.
WWWWWW||WWWWWW
W W W||W W W
||
( OO )__________
/ | \
/o o| MIT \
\___/||_||__||_|| *
|| || || ||
_||_|| _||_||
(__|__|(__|__|