Thanks for the idea.
I was looking to do exactly the same, but was not sure how to drive the door.
Copied most of your idea with the Linear Actuator, but used a different ESP relay module with ESPhome and HA + NodeRed integration. Vacuum is a Roborock S50 running ValetudoRE.
Mine drives to the bin after cleaning if the vacuum’s bin is full or is in for more than 10000 seconds while working.
Mounting the hinges and actuator on the underside of the cabinets was pain in the ass btw…
(Apparently the video is sped up by imgur. It is a little bit slower in real life)
Works awesome!