append google sheet with value

[hansib 2]

I have looked a bit around, but could not find an "easy" way to do an append on a google sheet with a value.. As this could come in handy for a bunch of logging-reasons. 

 

Does anyone have a lua code snippet that I could start out with?

[hansib 2]

Anyone have a hint?

[ianakapilotlight 21]

You could look at IFTTT for that sort of thing. There is a connector to Fibaro.

[hansib 2]

On 2/22/2019 at 11:29 AM, ianakapilotlight said:

You could look at IFTTT for that sort of thing. There is a connector to Fibaro.

Yes, but none that can take values from a scene.. only for logging when something runs etc.

 

I am looking for something you can run in lua that will pass the new value to a google sheet.. But of course any other solution that works would be awesome.

[ianakapilotlight 21]

Hmmm,

 

How about using an IFTTT web hook, that could be initiated using lua code, the IFTTT web hook could then update a google sheet.

 

[hansib 2]

Yes! managed to make it work!

 

Followed this tutorial:  

 

Then created a webhook trigger in IFTTT, and an event that posted the values to my sheet. And voila!

[hansib 2]

If you need more values passed to the sheet, you can format one of the values sent as comma delimited text: value1 ..",".. value2 .. "," ..value3 etc

then in google sheets you can use Split(<cell>,",",true,false) to make them into individual cells.