I've published a working guide for this — covers Enbridge Gas (Green Button XML) and Milton Hydro (hourly Excel) with Python scripts to import directly into InfluxDB and Grafana: Unlocking Green Button Data for Home Assistant Includes TOU rate calculations and the Milton Hydro portal bug workaround as of July 2026