This sounds like the kind of thing you could use Huginn for… I’m still picking up how to use it expediently but it does sound possible.
Update: I have since abandoned Huginn due to an incredible amount of instability when using it with an external Postgres instance. Can’t say I would recommend it unfortunately
In all likelihood the water system would probably stop working at some point, so whenever that goes plus two or three days is likely an upper bound on how long I could survive for. It’s pretty dry here so that would be a lethal problem.
If somehow it stays working, I could probably survive for a few months… basically until society and the supply chains completely break down and stop functioning followed by a period of mass starvation