Tosheets, utility to send stdin to Google sheets
1–10 of 30 posts
Re: Tosheets, utility to send stdin to Google sheets
#2very cool
Re: Tosheets, utility to send stdin to Google sheets
#3Nope, it sends stdout to sheets. Getting input from sheets would be cool, too.
Re: Tosheets, utility to send stdin to Google sheets
#4This is pretty great. It looks like it automatically writes to the next logical empty cell.
curl https://www.bitstamp.net/api/v2/ticker/btcusd \
| grep 'last": *"\d*\.\d*' -o | grep '\d*\.\d*' -o \
| tosheets -c A1 --spreadsheet=foo
Re: Tosheets, utility to send stdin to Google sheets
#5Nope, it sends stdout to sheets. Getting input from sheets would be cool, too.
It looks to me like you're being downvoted, but what you're saying looks correct to me. $PROGRAM sends to stdout what google sheets reads from "stdin"
Re: Tosheets, utility to send stdin to Google sheets
#6Nope, it sends stdout to sheets. Getting input from sheets would be cool, too.
Consider the command:
tosheets --spreadsheet=ABC Re: Tosheets, utility to send stdin to Google sheets
#7Nope, it sends stdout to sheets. Getting input from sheets would be cool, too.
tosheets definitely reads from stdin: https://github.com/kren1/tosheets/blob/8a853d2ebb722c474f5bb... :)
Re: Tosheets, utility to send stdin to Google sheets
#8Nope, it sends stdout to sheets. Getting input from sheets would be cool, too.
It looks to me like you're being downvoted, but what you're saying looks correct to me. $PROGRAM sends to stdout what google sheets reads from "stdin"
When you run this utility, it forwards stdin to Google Sheets.
Should you pipeline stdout from somewhere else to this utility, the contents of that stdout will be forwarded to Google Sheets.
It is correct to say either that you are forwarding stdin or that you are forwarding stdout. It is therefore not correct to say that it does not forward stdin, because the source code explicitly refers to stdin. That's likely the reason for the [Fight Club]s the GP is receiving.
Re: Tosheets, utility to send stdin to Google sheets
#9This is pretty great. It looks like it automatically writes to the next logical empty cell. curl https://www.bitstamp.net/api/v2/ticker/btcusd \ | grep 'last": *"\d*\.\d*' -o | grep '\d*\.\d*' -o \ | tosheets -c A1 --spreadsheet=foo ^ That will append the last BTC price to column A of sheet 'foo'
Can I nerd out over how unreasonably effective regexps are?
That's basically a mini JSON parser in 48 characters.
Re: Tosheets, utility to send stdin to Google sheets
#10I wrote something similar that will send stdin to Google Stackdriver Logging.