Water usage tracking from email

Energy
1

I am looking to track my water usage, which I receive through a daily email from the utility company, on the Energy Dashboard. The type of tracking that I am interested in capturing is Daily Usage as well as Monthly Usage.

The emails that I receive contain this text formatting:

Meter measured consumption that has exceeded the daily usage alert you set up in the Customer Portal for 12/06/2023 at 01:08 AM.
You are receiving this alert because you have used 0.26CCF and your alert setting was 0.00CCF

I have explored several paths so far (with no much success) such as exporting the daily data to Google Sheets - but not sure if HA can read the content of the spreadsheet, setting up IMAP - but not sure how I scan the contents of the emails (and will this only work as new emails arrive in my account?)

In summary, I am looking for recommendations on how to approach this problem.

The community’s assistance is very much appreciated!

2

I would try to receive the email and parse it in home assistant.
Try this thread: Look for a specific word in the body of the email, then trigger an action
If you can get the value from the body you can add it to a sensor each day.

I haven’t done such a thing myself but I would be interested in a possible solution.