google-spreadsheets-table

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

google-spreadsheets-table

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 (errspreadsheet) {
    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     \
    \___/||_||__||_|| *
         || ||  || ||
        _||_|| _||_||
       (__|__|(__|__|