Send info to a Google spreadsheet from Fibaro Lua

[xirilius 0]

Hello,

 

Is it posible to send text to a cell in a Google spreadsheet from Fibaro Lua?

 

My central heating is a zone-heating controlled bij a Fibaro HC2 with zwave Secure thermostats in every room in my house.

The heating works by a central gas boiler and electric Heimeier valves with Fibaro relais

 

I like to log the on/off times (then i can calculate the heating minutes per day) so that i can show it in a graph according to the room temperature and outside temperature.

With this information i can make my heating even smarter, i can automatically calculate the starting time to heat in the morning depending on the room and outside temperature to reach a certain temp at 9:00

 

If sending text to a external document is possible it can be used for a lot of other things:

 

- Temperature logs (pir/smoke sensor)

- Room usage (pir)

- Usage of devices (koffeemachine, radio, tv, computer, lights, .....)

- Graphical views

- ......

 

 

[10der 831]

 

http://192.168.1.36/api/panels/event?from=1&deviceID=526

 

where 192.168.1.36 HC ip address 

deviceID - temperature (etc) sensor.

 

result

Please login or register to see this image.

 

 

you can pass "from time" in "from" parameter in ms 

 

 

 

[rls46 19]

maybe you're interested

Please login or register to see this link.