21–25 of 25 posts
It has worked pretty well for a few years now, and it allows ordinary humans to filter and review in a familiar format. (With the risk that they start messing with stuff enough to break its DB-ness.)
We used to use the excellent Xero for our accounts, but it couldn't handle international business (exchange rates, different tax regimes etc)well. So we rolled our own system of python scripts and Google sheets. The python scripts use gspread to import and process bank data from eight accounts around the world. Summary sheets pull that data together into real-time profit and loss, position statements, and tax summari…
I used Google Sheets as the database for a neighbourhood association, written in Python, running on Google App Engine. https://github.com/adam-p/danforth-east It has worked pretty well for a few years now, and it allows ordinary humans to filter and review in a familiar format. (With the risk that they start messing with stuff enough to break its DB-ness.)
Google Spreadsheets and Python | https://news.ycombinator.com/item?id=13668916 (2017Feb:140comments) ・SQL into Sheets - http://pastebin.com/ACwqc5um ・LibreOffice Calc server - https://github.com/robsco-git/spreadsheet_server ・Sheets API (JS) - http://chriszarate.github.io/sheetrock/ | https://github.com/theoephraim/node-google-spreadsheet ・Grunt / Jekyll - https://github.com/stpe/grunt-gss-to-json ・simple read-only (…
We used to use the excellent Xero for our accounts, but it couldn't handle international business (exchange rates, different tax regimes etc)well. So we rolled our own system of python scripts and Google sheets. The python scripts use gspread to import and process bank data from eight accounts around the world. Summary sheets pull that data together into real-time profit and loss, position statements, and tax summari…
Sounds awesome! We are in the process of revamping our sheets internally and would love to do something similar. Anything you could share on the subject?