I am trying to find the same but it appears that it isn't possible. Nest doesn't officially offer a public API for their Nest Aware platform, which includes security camera footage and activity data, due to privacy and security concerns. Since Google acquired Nest and integrated it into Google’s ecosystem, they’ve significantly limited third-party access, moving most device management to the Google Home API.

But if you found a solution!