search

brown-SSW / brown-solar-charger

This program monitors a solar power system and runs a physical and online dashboard.
https://brown-ssw.github.io/brown-solar-charger/
4 stars 1 forks source link

make google sheet record all data #27

Closed joshua-8 closed 3 years ago

joshua-8 commented 3 years ago

can this be done by making a periodically running google sheet script that checks the json for new data and adds it to the sheet? Other than logging the daily arrays (and keeping it longer than 24 hours) could it also log some values from live data or even debug?

lrandall521 commented 3 years ago

https://docs.google.com/spreadsheets/d/1-D1cuN569Oko7t2OFXpSDvPqCG6O4iQV2vTHWb0dfH4/edit?usp=sharing

lrandall521 commented 3 years ago

For syncing with firebase: https://websiddu.com/blog/sync-data-from-firebase-to-google-sheets.html

Requires data is stored in cloud firestore first.

sfsw-brown-solar-charger commented 3 years ago

https://docs.google.com/spreadsheets/d/125tzejewiulYwVp-gOtJQhKFdyUY960JVkXAU_3bh_U/edit#gid=0

https://github.com/brown-SSW/brown-solar-charger/wiki/google-apps-script-for-importing-json-data-into-spreadsheet