Jump to content

Welcome to Smart Home Forum by FIBARO

Dear Guest,

 

as you can notice parts of Smart Home Forum by FIBARO is not available for you. You have to register in order to view all content and post in our community. Don't worry! Registration is a simple free process that requires minimal information for you to sign up. Become a part of of Smart Home Forum by FIBARO by creating an account.

 

As a member you can:

  •     Start new topics and reply to others
  •     Follow topics and users to get email updates
  •     Get your own profile page and make new friends
  •     Send personal messages
  •     ... and learn a lot about our system!

 

Regards,

Smart Home Forum by FIBARO Team


  • 0

Send info to a Google spreadsheet from Fibaro Lua


xirilius

Question

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

- ......

 

 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

 

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 

 

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...