hss

hubot-script-spreadsheet

hubot plugin: (query) interface to google spreadsheet (*with* authentication)

Showing:

Popularity

Downloads/wk

4

GitHub Stars

13

Maintenance

Last Commit

1yr ago

Contributors

1

Package

Dependencies

0

License

BSD-2-Clause

Type Definitions

Tree-Shakeable

No?

Categories

Readme

hubot-script-spreadsheet

hubot (query) interface to google spreadsheet (with authentication)

A cat gif, no project can live without it!

Example

Simple:

hubot> hubot spreadsheet myspreadsheet
Product Id  Description            Price, USD
----------  ---------------------  ----------
123123      Something awesome         1000.00
245452      Very interesting book       11.45
232323      Yet another product        555.55

source: https://docs.google.com/spreadsheet/ccc?key=sdfsdfsdfsdf..

regex searchquery:

hubot> hubot spreadsheet myspreadsheet awesome|book
Product Id  Description            Price, USD
----------  ---------------------  ----------
123123      Something awesome         1000.00
245452      Very interesting book       11.45

source: https://docs.google.com/spreadsheet/ccc?key=sdfsdfsdfsdf..

Why

A spreadsheet is an awesome userinterface+database in one view. Its easy for everybody to use, so referencing/querying spreadsheets can be very handy during text teamcommunication.

Configuration:

GOOGLE_SPREADSHEET_LOGIN="you@gmail.com"
GOOGLE_SPREADSHEET_PASSWD="somepassword"

Commands:

add a spreadsheet first:

hubot spreadsheet save myspreadsheet spreadsheetname|sheet1|2|http://....

then:

 hubot spreadsheet                                 # shows usage + available sheets
 hubot spreadsheet myspreadsheet                   # displays sheet
 hubot spreadsheet myspreadsheet <regex>           # displays sheet entries which match "foo"
 hubot spreadsheet del myspreadsheet               # delete

Rate & Review

Great Documentation0
Easy to Use0
Performant0
Highly Customizable0
Bleeding Edge0
Responsive Maintainers0
Poor Documentation0
Hard to Use0
Slow0
Buggy0
Abandoned0
Unwelcoming Community0
100