kren1 / Tosheets
Licence: mit
Send your stdin to google sheets
Stars: ✭ 536
Programming Languages
python
139335 projects - #7 most used programming language
Projects that are alternatives of or similar to Tosheets
Rust cmd lib
Common rust command-line macros and utilities, to write shell-script like tasks in a clean, natural and rusty way
Stars: ✭ 604 (+12.69%)
Mutual labels: command-line, pipe
Ipt
Interactive Pipe To: The Node.js cli interactive workflow
Stars: ✭ 783 (+46.08%)
Mutual labels: command-line, pipe
Onhold
🔊 Play sounds while and after shell jobs complete
Stars: ✭ 146 (-72.76%)
Mutual labels: command-line, pipe
Node.cli Progress
⌛️ easy to use progress-bar for command-line/terminal applications
Stars: ✭ 466 (-13.06%)
Mutual labels: command-line
Cz Conventional Changelog
A commitizen adapter for the angular preset of https://github.com/conventional-changelog/conventional-changelog
Stars: ✭ 477 (-11.01%)
Mutual labels: command-line
Wow
😮❗️❗️ Wow❗️ now my Go commandline app is spinning with 🌈 and 🐴
Stars: ✭ 494 (-7.84%)
Mutual labels: command-line
Git Labelmaker
🎏 Manage your GitHub labels from the command line!
Stars: ✭ 534 (-0.37%)
Mutual labels: command-line
Build A Bot With Zero Coding
An example of using Google Sheets to create a Viber survey chat bot without a backend server
Stars: ✭ 460 (-14.18%)
Mutual labels: google-sheets
Jrnl
Collect your thoughts and notes without leaving the command line.
Stars: ✭ 5,126 (+856.34%)
Mutual labels: command-line
Xonsh
🐚 Python-powered, cross-platform, Unix-gazing shell
Stars: ✭ 5,327 (+893.84%)
Mutual labels: command-line
Cbt
CBT - fun, fast, intuitive, compositional, statically checked builds written in Scala
Stars: ✭ 489 (-8.77%)
Mutual labels: command-line
Cabal Cli
Terminal client for Cabal, the p2p chat platform.
Stars: ✭ 479 (-10.63%)
Mutual labels: command-line
Ncbi Genome Download
Scripts to download genomes from the NCBI FTP servers
Stars: ✭ 494 (-7.84%)
Mutual labels: command-line
Instainsane
Multi-threaded Instagram Brute Forcer (100 attemps at once)
Stars: ✭ 475 (-11.38%)
Mutual labels: command-line
Telegram Send
Send messages and files over Telegram from the command-line.
Stars: ✭ 519 (-3.17%)
Mutual labels: command-line
A simple command line utility that sends your stdin to sheets.
Available on pip by pip install tosheets
(python3+ only)
NOTE: On first use, tosheets will open a browser window to authorize OAuth2 token.
tosheets
Using Pipe a local file to a new spreadsheet.
cat data.csv | tosheets -c A1 -d , --new-sheet="tosheetsSheet"
Pipe a local file to an existing spreadsheet:
(Given a URL like https://docs.google.com/spreadsheets/d/sample-spread-sheet-id-23sdf32543fs/edit#gid=0
)
cat data.csv | tosheets -c B4 -d , --spreadsheet=sample-spread-sheet-id-23sdf32543fs
Send sequence from 1 to 10 to a column starting at B4:
seq 1 10 | tosheets -c B4 --spreadsheet=sample-spread-sheet-id-23sdf32543fs
Send a matrix:
1 2
3 4
To the same location:
echo -e '1 2\n3 4' | tosheets -c B4 --spreadsheet=sample-spread-sheet-id-23sdf32543fs
To sheets has a variety of other options listed:
tosheets, send stdin to your google sheets
Usage:
tosheets -c <cell> [-u] [-k] [-s <sheet>] [--spreadsheet=<spreadsheet>] [--new-sheet=<name>] [-d <delimiter>] [-q <quote char>]
tosheets (-h | --help)
tosheets --version
Options:
-h --help Prints help.
--version Show version.
-i CSV Read this CSV instead of stdin
-u Update CELL(s) instead of appending.
-k Keep fields as they are (do not try to convert int or float).
-c CELL Start appending to CELL.
-s SHEET Use sheet name SHEET, otherwise tries to use
TOSHEETS_SHEET (default: first visible sheet).
-d DELIMITER Use DELIMITER to split each line (default: whitespace).
-q QUOTE_CHAR A one-character string used to quote fields containing special characters,
such as the delimiter or quotechar, or which contain new-line characters.
(default: '"').
--spreadsheet=<spreadsheet> Send to the spreadsheet identified by spreadshetId
(ie. docs.google.com/spreadsheets/d/<spreadsheetId>/...),
if empty uses TOSHEETS_SPREADSHEET enviroment variable.
--new-sheet=<name> Create a new spreadsheet with the chosen name. Prints the
spreadsheetId so it can be piped/stored.
--open Open a browser with the newly created sheet
Distribution
python setup.py sdist bdist_wheel
twine upload dist/*
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].