Overview¶

docs
tests

A library and driver to do additions or updates to Google spreadsheet given a stream of data

Free software: MIT license

Installation¶

pip install sync-google-spreadsheet

Examples¶

Download chromedriver for your system from here. And put it in ./assets folder.

Update spreadsheet of sleep tracking data from Beddit and Resmed (myAir)¶

pip install gspread oauth2client pandas beddit-python selenium PyYAML
python examples/update_sleep.py

Update and append to spreadsheet of exercise data from Peloton¶

pip install gspread oauth2client pandas selenium PyYAML
rm -rf tmp; mkdir tmp
python examples/update_peloton.py

Update and append to spreadsheet of finance data from Schwab and Chase credit card data¶

This currently doesn’t use selenium to scrape site and download.

pip install gspread oauth2client PyYAML
rm -rf tmp; mkdir tmp
# download csv export of transaction data to tmp
python examples/update_finance.py

Documentation¶

https://python-sync-google-spreadsheet.readthedocs.io/

Development¶

To run the all tests run:

tox

Note, to combine the coverage data from all the tox environments run:

Windows	set PYTEST_ADDOPTS=--cov-append tox
Other	PYTEST_ADDOPTS=--cov-append tox

Known issues¶

Sometimes there are two transactions on the same day from the same vendor for the same amount. The sheet adapter doesn’t handle the key uniqueness check in that case for the example update_finance script.