12/26/2023 0 Comments Download google nest thermostatP.S: Do not ask me to give you the permission to edit this file. Start with my shared google sheet linked below (Open that file and click File and then "make a copy" and save in your google drive). Keywords: Nest Thermostat History, Nest Heat, Nest Temperature History, Nest Thermostat Hack, Nest Thermostat Tips, Nest Energy History, Nest Daily Use, Nest Daily Usage, Download nest thermostat data I just made a few edits to suit my needs. Script checks the last row and if it is the same day, then it appends the data to the same row rather than adding a new row.Ĭredit for the original script. I updated the original script to still ping Nest every 5 mins, and but collect data in 1 row per day. After some google searching, I realized that one row every 5 minute for google spreadhseet means hitting the max limit of cells a google spreadsheet can accomodate. I wanted to collect historical data (>10 days) and came across google spreadheets script that pings nest every set time and also gets local weather data from and saves in the spreadsheet.Įverything was going well for a year, and the script suddenly stopped collecting data. Nest thermostat tracks temperature, humidity and furnace/AC usage and users are able to see historical data only for 10 days.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |