Running HASS in Docker on Synology NAS. Thinking out loud here, maybe this is somehow possible. I have a Smart Electricity meter. I could hook it up to a Pi and then send data to HASS via MQTT.
However, I already have an account at a portal (https://www.slimmemeterportal.nl/) where the data is sent anyway. When I login there I get all the insights and there’s a (daily updated) link to excel files to download.
Would it be possible to automate a process (all from within HASS preferably) that logs in to the site daily, downloads the excel file and processes the data in the excel file into HASS sensors?