evanrinehart / append_to_sheet Goto Github PK

Appends a row of data to a google spreadsheet. Specify which sheet and what data to append on stdin in JSON form.

ruby -I. append_to_sheet.rb
{
  "sheet_id": "the sheet ID",
  "rows": ["apple", "pear", "banana", "blueberry"]
}
<CTRL+D>

Requires google-api-client gem, a client_secret.json file containing the oauth2 client_id and client_secret for the user who has access to the sheet. The file must be in the same directory as the program. Authorization will store extra oauth credentials in a file tokens.yaml in the same directory.