Energy-meter readings from email into your smart home

The scenario catches energy-portal emails, extracts import and export readings, and updates the meters in your smart home.

  • No manual export or typing of numbers
  • Hourly totals calculated automatically
  • Smart-home meters always up to date
  • Runs on new email and on a schedule
GmailHome AssistantEmail Trigger (IMAP)
Set it up for yourselfScriptera

How it works

To move data from Gmail to Home Assistant automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Gmail Trigger
  2. Check: Check Email Subject
  3. If yes: Aggregate_id
  4. Then: Get a message[0]
  5. Check: If attachment_0 is xlsx
  6. If yes: Extract from File
  7. Then: Extract default data from source (+A)
  8. Then: Rename "*_1" keys for merge3
  9. Check: Merge (+A; -A)
  10. Check: Merge (+A; -A)2
  11. Then: Convert Excel time
  12. Then: Convert datetime to Spook format
  13. Then: Calculate hourly sum and
  14. Then: Generate 1_8_0 list for stats
  15. Then: Generate 1_8_0 stats
  16. Then: Spook: update +A hitorical data1
  17. Then: Update input_number.import entity state1
  18. Then: Generate 2_8_0 list for stats
  19. Then: Generate 2_8_0 stats
  20. Then: Spook: update -A hitorical data1
  21. Then: Update input_number.exportt entity state1
  22. Then: Extract '*_1' data from source (-A)
  23. Then: Rename "*_1" keys for merge
  24. Then: Extract '*_2' data from source (1_8_0)
  25. Then: Rename "*_1" keys for merge1
  26. Check: Merge (+A; -A)1
  27. Then: Extract '*_3' data from source (2_8_0)
  28. Then: Rename "*_1" keys for merge2
  29. Then: Get last 5 messages
  30. Starts when: Schedule Trigger
  31. Then: Email Trigger (IMAP)

You can launch this Gmail + Home Assistant integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios