Send to Google Sheets / save all data

[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?

[Mierzen]

Bump

[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

[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

[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

[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

[shkaff]

Just accidentally found another approach for Google Docs

https://github.com/jpmens/mqttwarn#gss