I managed to install the app with no problems but the only thing is that it creates 2 times:
time and LastTime when I select the interval to push data to google higher than 0 minutes. Any idea why? I would be expecting only one time:
Hi Chuck, just finished my little project to monitor some temperature sensors with Google Sheets and Google Data Studio for the dashboard. The installation of Google Sheets Logging was a breeze and I'm very pleased with the final result. Thank so much for this great tool. Let me know where I can send my contribution
Greetings,
I had a script running on SmartThings to do this, but finally kicked the SmartThings completely to the curb. I set this up on one of my Hubitat Hubs and everything is working well, with one issue. The logging spreadsheet will only log to 100 rows and then overwrites. Is there anyway to increase the number of rows that the script will write to? I looked through the code and couldn't find anything that looked obvious, mind you I am a novice at scripts. I have extended the spreadsheet to over 10,000 rows, but it only writes the 1st 100.
Any help is much appreciated!
1 Like
This is a fab app - just got installed and logging humidity/temperatures nicely for an Aqara sensor in a cold frame in the garden (where I'll be moving our tortoise in the Spring).
Question from a Hubistat novice: Is there a straight-forward way to adjust the frequency of logging? Ideally I would record one reading per hour.
I haven't come up against the 100 row limit yet, but I wonder if this is an issue, and if there is a work around?
@jtmpush18, I'm getting the same error you had, did you ever figure out what caused this? I tried going through the instructions (some have change in the script editor) but it does look ok, but for some reason I keep getting this error that I just can't find an answer of to why?
Wow...
That was a long time ago...
Yes, I did eventually get it working, but how, I don't really remember.
May I suggest, by the way, instead the activity viewer driver?
I think that it does more or less the same thing.
LOL ya I figured but took a chance 
I'll check that out and see if that would suit my needs, thanks!!!
@nclark Did you find an answer to this. I ran into the same issue and its because I didnt use the code snippet on github. The example in the image is just of what needs to be changed. Not the entire code. Check out the code.gs file. Got mine logging fine yesterday but still trying to figure out the fields and how it writes the date/ time.
@daniel.schaff_hubita, no gave up on it for now, not really sure what the problem is but it's most likely user error because of the options that changed on Google's side or something because most of the procedure described on the Github page does not match at all what I'm seeing on my screen. Also yes I did copy the Code.GS file from the Github page as you asked.
Thanks for the help anyway.
Is anyone still using it successfully? I Had mine paused and now that I wanted to activate it again, it does not look to work anymore
I had this working a year or so back. In Smartthings and then for short time in Hubitat before I changed some devices and screwed it up.
Wife wanted to know how her green house was preforming compared to outside temp.
I set up a day ago and got it working after a couple of attemps. I got erros for a couple of attemps, but finally was able to make step 16 work.
Now have to remember how to format data to make a graph for her.
I used the code and recomendations from [chuck.schwer]
Thanks for the tip, will retry now that someone got it working again, if it works, I'll do a step by step with current info!
I have this running on my hub. I've logged 25000 rows of temp readings since January.
(that's my github in post #3; I just resurrected this on SmartThings back in 2016 after Chuck pulled support for it)
Just to add my thanks - I used this in ST, logging around 2.5 million data points a year (I needed to archive the sheet off each year).
I've just moved it over to HE, and am starting to add data to it as I move things over - it seems to be working fine (once I put my deployment ID in to the app, rather than the sheet ID D'Oh).
Best,
James
I deployed this app a while ago. Testing out in Step 16 was successful. Putting parameters into the URL results in data being logged in the sheet. I have the script key (not the sheet key) entered in the app, I have the right sensors selected (I'm using Aeotec MultiSensor 6) and trying to log humidity and temp.
However, only Temp is being logged and not humidity.
How can I troubleshoot?
Also, how do I adjust the frequency of the logging?
Can you show a screenshot of your app settings (but not the script URL key), specifically the temp/hum section?
You can adjust the time to keep events queued in the app, near the bottom. It looks like this:
The app receives events as they happen and queues them up. At the end of this period, it sends a new row to the sheet. Make this value larger to let more events get logged to one row. Make this value smaller to get events logged more immediately.
Here are the screenshots
And here's what the data structure looks like:
And a screenshot of my sensor settings:
So then I will need to change how frequently the sensor reports events, is it?
You've got values for both temp and humidity. They don't come at the same time -- the device sends a value and Hubitat turns it into an event. This gets collected by the app and put in the queue. When the queue time expires, the app sends a POST event to the Sheet with all the values it has queued -- values that aren't updated are left blank. If your Time To Queue is 1 minute (as you have it), then you're more likely to get single values. If your queue time was larger (15 minutes), then you'd have a few rows with two values.
This is how Chuck wrote the code.
When you are logging many temperatures, this makes lots of sense. Here's a part of my sheet for temps/humidity (you may notice you can format the first row and it keeps working):
Okay so if this is intended behaviour, then this is not the right app for what I need. Thanks for the clarification 
I'll go with a Rule Machine & Google Forms based approach.
