If you’re building a home automation system for yourself then you really should consider going down the Node-Red route. It make this data consolidation process much simpler, and it allows you to build your own rules engine within Node-Red, as well as adding Alexa or Google Home voice assistant integration in a very simple and effective way.