Page 1 of 1
Send to Google Sheets / save all data
Posted: Friday 10 June 2016 13:08
by Mierzen
Hi!
I would like to save all the data that my Domoticz system captures. I.e. the daily temperature profiles.
It does not have to be saved on my Raspberry Pi - maybe I can have the Pi send it to Google Sheets as they come in/twice daily.
Is that possible?
Any tips?
Re: Send to Google Sheets / save all data
Posted: Thursday 30 June 2016 9:53
by Mierzen
Bump
Re: Send to Google Sheets / save all data
Posted: Thursday 30 June 2016 11:00
by dervogt
this is not relate to Google Spreadsheets, but definitely a way of getting all your data out of domoticz:
http://www.domoticz.com/wiki/HttpLink
I myself followed this tutorial to a great extend and I am now using node-RED, MQTT, InfluxDB and Grafana to do my reportings.I am pretty sure,w ith enough (time)investment, you can create a nice scripting solution with parts of the mentioned solution to get your data into Google Spreadsheets
Re: Send to Google Sheets / save all data
Posted: Monday 12 September 2016 12:02
by Mierzen
Thank you!
It seems my email notifications are turned off, so I did not get your reply.
I'll go through your link and post what I have done if I decide to try and succeed
Re: Send to Google Sheets / save all data
Posted: Wednesday 14 September 2016 15:09
by shkaff
It's possible. I went this way but be prepared for challenges
https://github.com/burnash/gspread
This is Python API so you will have to use python scripting. I am personally don't know python so I had to heavily abuse Google search to make every little step ahead.
I used python 2.7
My script reads my google spreadsheet on a schedule and writes back statuses of lines processing
Re: Send to Google Sheets / save all data
Posted: Friday 16 September 2016 20:10
by Mierzen
@dervogt, I'm missing something here - I can't even do step 1 of the tutorial. I can't install InfluxDB, I get this:
Code: Select all
pi@raspberrypi:~$ sudo dpkg -i influxdb_1.0.0_amd64.deb
dpkg: error processing archive influxdb_1.0.0_amd64.deb (--install):
package architecture (amd64) does not match system (armhf)
Errors were encountered while processing:
influxdb_1.0.0_amd64.deb
Re: Send to Google Sheets / save all data
Posted: Wednesday 21 September 2016 14:45
by shkaff
Just accidentally found another approach for Google Docs
https://github.com/jpmens/mqttwarn#gss