Before I embark on writing up this process, I'd like to know if any audience members are excited (or even interested) by the prospect of pulling information from your Hubitat C7 directly into Google Sheets, using a simple, automated process.
I'm hoping to craft this tutorial in the same vein as my well-received HOW-TO Store data in Google Sheets directly from RM5 – let's call that the "push" method – only this time using function calls from within the Spreadsheet itself (the "pull" method).
Well, that's refreshing (and I dare say not at all surprising) to hear! I'd like to assume -- without actually installing and testing that user app myself -- that it exposes all of a given (or multiple) device's attributes, so they can be hand picked cell-by-cell for use in formulae, reports, etc. If so, that's essentially the same road I was heading down (albeit with nothing needed to be installed on the HE side, since I was aiming for a "pull" solution vs the "push" method this app surely employs).
The weak link in the process turns out to be Rule Machine 5.1, who's basic action GET HTTP refuses to populate a variable (for me), despite extensive testing. To date, nobody has been able to show me a working example, so I cannot incorporate it into my planned tutorial about extracting values from Google spreadsheets.
Inquiry is rarely, if ever, dissuaded here. It’s not like this online forum dedicated to home automation is the CIA, or the Nixon administration or something.
Sorry to ressurect an old thread @jlv but I'm looking for help with @krlaframboise Simple event Logger deployment, I've followed the instructions (which are somewhat out of date now when it comes to options in G.Sheets etc) and think I got everything setup ok, but alas the spreadsheet does not populate when the app runs and seemingly that's to do with an authorisation issue. The log error states:
Unexpected error from Google Sheets Web App: Forbidden
...I'm assuming that maybe it's to do with the web app url and authorisation to view it - I have currently set the G.Sheets deployment to run as 'me' and be accessible by 'anyone' but when I test the web app url I get a 'you need access' message, so maybe the same thing is happening when Hubitat is running the app?
I'm also not sure whether i need to do anything more with the Oath element, I don't really understand it but the app told me a token had been generated so assume it is ok and I've done all I need to do there?
Anyway, any suggestions on how to resolve would be appreciated. Thank you in advance.