Import E.ON W1000 energy meter data to Home Assistant with Spook integration

UPDATES: 2025-12-03 fix JS code in calculate hourly sum node

E.ON W1000 → n8n → Home Assistant (Spook) “Integration”

This workflow processes emails from the E.ON portal containing 15-minute +A -A (import/export) data and daily 1.8.0 2.8.0 meter readings. It extracts the required columns from the attached XLSX file, groups the 15-minute values by hour, then:

updates the Spook/Recorder statistics under the IDs sensor.gridenergyimport and sensor.gridenergyexport, and sets the current meter readings for the entities inputnumber.gridimportmeter and inputnumber.gridexportmeter.

> You may need to modify the workflow if there are changes in how E.ON sends scheduled exports. If the exported data format changes, please report it on [Github](https://github.com/Netesfiu/EON-W1000-n8n)!

Requirements

n8n (cloud or self-hosted) HACS addon available here: [Rbillon59/home-assistant-addons](https://github.com/Rbillon59/home-assistant-addons) [Official n8n Docker Compose template](https://docs.n8n.io/hosting/installation/server-setups/docker-compose/6-create-docker-compose-file) Simplified n8n Docker Compose template available on [Github](https://github.com/Netesfiu/EON-W1000-n8n/blob/main/n8n-docker-compose.yaml) (For Gmail) Gmail API authentication (OAuth2) read-only email access to the account receiving the messages Setup guide available [here](https://docs.n8n.io/integrations/builtin/credentials/google/oauth-single-service/) (For IMAP) IMAP provider credentials Home Assistant access via Long-Lived Access Token or API key Setup guide available [here](https://docs.n8n.io/integrations/builtin/credentials/homeassistant/) Spook integration Documentation and installation guide available [here](https://spook.boo)

E.ON Portal Setup