Import E.ON W1000 energy meter data to Home Assistant with Spook integration
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 32 nodes and runs on a schedule (every day at 14:00) (plus 2 other triggers). Along the way it connects Gmail and Home Assistant.
How it runs
Trigger: On a schedule (every day at 14:00) (plus 2 other triggers).
- Get last 5 messages (Gmail): get many
- Check Email Subject (If): checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- Aggregate: combines items into one
- Extract from File: extracts data from a file (xlsx)
- Get a message[0] (Gmail): get
- Extract default data from source (+A) (Split Out): splits a list into separate items
- Extract '*_1' data from source (-A) (Split Out): splits a list into separate items
- Extract '*_2' data from source (1_8_0) (Split Out): splits a list into separate items
- Extract '*_3' data from source (2_8_0) (Split Out): splits a list into separate items
…plus 18 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Gmail Trigger).
Nodes used (15)
- Extract from File
n8n-nodes-base.extractFromFile - Rename Keys
n8n-nodes-base.renameKeys - Gmail
n8n-nodes-base.gmail - Aggregate
n8n-nodes-base.aggregate - Split Out
n8n-nodes-base.splitOut - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Home Assistant
n8n-nodes-base.homeAssistant - Edit Fields (Set)
n8n-nodes-base.set - Gmail Trigger
n8n-nodes-base.gmailTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Email Trigger (IMAP)
n8n-nodes-base.emailReadImap - Date & Time
n8n-nodes-base.dateTime
From the author
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…