google-spreadsheets-table

A cached Google Spreadsheets table over segmentio/google-spreadsheets.

Install

$ npm install segmentio/google-spreadsheets-table

Example


$3

``js
var Table = require('google-spreadsheets-table');

var table = Table(worksheet)
.headerRow(1)
.idColumn(1)
.flushAt(ms('10s'));
`

$3

`js
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'});
`

$3

`js
table.flush();
`

$3

`js
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);
});
`

API

$3

Set the attrs on the spreadsheet row associated with id.

$3

Flushes the update changes to the spreadsheet.

License

`
WWWWWW||WWWWWW
W W W||W W W
||
( OO )__________
/ | \
/o o| MIT \
\___/||_||__||_|| *
|| || || ||
_||_|| _||_||
(__|__|(__|__|
``