Expose actual values (e.g. temperature / heat / light)

[cybernard]

Description

First, thanks for your time and effort in creating this plugin, it just worked.

If I do an export from google, I actually get temperatures, humidity and etc as numeric values. Is there any plan to give access to these values? Right now it just says "Normal", and I would like to have the actual values.

Device (optional)

Nest Protect wired

Additional information

No response

[iMicknl]

Can you tell a bit more about how you can do this export? As far as I am aware, there is no way to access these values.

It is not present in the API we currently use at least. And the Homebridge-nest plug-in doesn't have this as well.

[cybernard]

Yes, I can. Goto http://takeout.google.com
2. Sign in with your google account
3. Select "Deselect all"
4. Scroll down, and check Nest
5. Here select the frequency and type
6. It defaults to once and zip so I just leave it
7. Create Export
8. Wait between 10 minutes and 12 hours depending on how heavily loaded the google servers.
9. download the ZIP file
10. open the zip file
11. There are folders for each nest product
12. there are subfolders for each year
13. Each month has a CSV file contain all the data.

[iMicknl]

Time	Event Description	MaxValue
2022-01-11T12:30Z	AmbientLightSensorbucket	63.000000
2022-01-11T12:30Z	Humiditybucket	52.400000
2022-01-11T12:30Z	Passiveinfraredbucket	214.000000
2022-01-11T12:30Z	Temperaturebucket	20.800000

Interesting (and creepy) to see that Google collects the raw values, even though they currently don't offer a way to retrieve them in real-time. Just via the batch data collection form that you shared above.

If someone knows where to gather this information, I am happy to implement it. But until we figure this out, we are blocked.

[iMicknl]

2022-01-23T19:13:00.931Z	2022-01-23T19:13:04.811Z	Pathlight	Duration milliseconds: 3880
2022-01-23T19:13:08.061Z	2022-01-23T19:13:11.360Z	Pathlight	Duration milliseconds: 3299
2022-01-23T19:13:18.540Z	2022-01-23T19:13:37.365Z	Pathlight	Duration milliseconds: 18825
2022-01-23T19:13:39.392Z	2022-01-23T19:13:42.044Z	Pathlight	Duration milliseconds: 2652
2022-01-23T19:13:50.042Z	2022-01-23T19:13:52.027Z	Pathlight	Duration milliseconds: 1985

Interesting that they are also able to detect the duration of the pathligh (occupancy), which is currently not possible to retrieve via the API as well.

[cybernard]

I guess as a temporary measure would it be reasonable to allow the import of said files into Home Assistant? They are after all just CSV files. Especially since the CSV file contain a complete record of all the data.

[iMicknl]

What would be the use-case? Since you will only have historical data at that point.

[cybernard]

While, yes it is historical data, I personally am trying to get ALL my house data into a single place. However, to be fair some of the data is only a few hours old. Now if I have to have 90% their and 10 percent in csv files it defeats the point. Plus Home Assistant generates graphs automatically, and that is one thing I really want. Also I want to compare the temperature at ceiling level and shoulder or lower level to see what kind of difference exist. The other thing is I can graph nest protect with all my ecobee sensors and compare them side by side.

While everyone wants real time data until that happens I would happy to just have all the data in one place.

If you have any new versions you want me to test I would be happy to test them.

[iMicknl]

I will leave this issue open for others, since I won't be implementing this 🙂. It is quite some hassle and I won't have the time to implement this. I can imagine your use-case and perhaps you can do something with https://www.home-assistant.io/integrations/file/#sensor.

New versions will be posted as release on GitHub, or as pre-release.

[fokcuk]

Very interesting info, but as mentioned not much use if you cannot get the live data. You will probably be able to if they ever decided to have proper api access. But with some confusing articles that I have read, it looks as though they have abandoned Nest protect

[iMicknl]

Even when they add it to the SDM API, I don't think they will directly expose these values. They currently don't expose these values in their Nest app as well..

[OscarHanzely]

Hmm, Google is gathering more data about us every day and we don't even know it. Like presence in individual rooms.. I am wondering which terms and conditions section said they can sell that data :D or how hot is it in my house over time.

[cybernard]

I am not so concerned with Google selling as the 100,000 other companies who have already done it. To single Google out over an industry standard practice, seems ridiculous. My biggest problem is that they make it difficult for ME to get for legitimate reasons. Jonathan

…

On Thu, Mar 10, 2022 at 11:51 AM OscarHanzely ***@***.***> wrote: Hmm, Google is gathering more data about us every day and we don't even know it. Like presence in individual rooms.. I am wondering which terms and conditions section said they can sell that data :D or how hot is it in my house over time. — Reply to this email directly, view it on GitHub <#22 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADSYRWPBJIDTFUCL6RN4DTDU7IZAJANCNFSM5OZWZFFQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.***>