Skip to content
FlowHub
FluxonLab
Gmail
AI Agents & Chatbotsfree

Import E.on W1000 Energy Meter Data to Home Assistant with Spook Integration

by András FarkasUpdated Aug 2026
RequiresGmailGmailEmail (IMAP)Email (IMAP)
Share Post Share
EFExtract from FileExtract from Fi…RKRename "*_1" keys for mergeRename "*_1" ke…Get last 5 messagesGet last 5 mess…AgAggregate_idGet a message[0]RKRename "*_1" keys for merge1Rename "*_1" ke…RKRename "*_1" keys for merge2Rename "*_1" ke…SOExtract default data from source (+A)Extract default…SOExtract '*_1' data from source (-A)Extract '*_1' d…SOExtract '*_2' data from source (1_8_0)Extract '*_2' d…SOExtract '*_3' data from source (2_8_0)Extract '*_3' d…MeMerge (+A; -A)RKRename "*_1" keys for merge3Rename "*_1" ke…MeMerge (+A; -A)1MeMerge (+A; -A)2CoCalculate hourly sum andCalculate hourl…HASpook: update +A hitorical data1Spook: update +…HASpook: update -A hitorical data1Spook: update -…SeGenerate 1_8_0 list for statsGenerate 1_8_0 …SeGenerate 2_8_0 list for statsGenerate 2_8_0 …AgGenerate 1_8_0 statsGenerate 1_8_0 …AgGenerate 2_8_0 statsGenerate 2_8_0 …HAUpdate input_number.exportt entity state1Update input_nu…HAUpdate input_number.import entity state1Update input_nu…Gmail TriggerScSchedule TriggerIfIf attachment_0 is xlsxIf attachment_0…NONo Operation, do nothing1No Operation, d…EREmail Trigger (IMAP)Email Trigger (…IfCheck Email SubjectCheck Email Sub…DTConvert datetime to Spook formatConvert datetim…DTConvert Excel timeConvert Excel t…1234567891011121314151617181920212223242526272829303132333435
1/5
STEPS · 35
Starts on a Gmail event

On a scheduled check of incoming email, extracts E.ON energy meter data from attachments and imports the readings into Home Assistant.

Tags

eventadvancedGmailEmail (IMAP)File Managementdiscoveredpending-review
Connects
gmailGmailemailimapEmail (IMAP)
CategoryAI Agents & Chatbots
Triggerevent
Complexityadvanced
Nodes32
AddedJun 27, 2026