Sunday evening weekly home energy report in Notion

Every Sunday at 6pm in my local time, build a written weekly home energy report and post it to a Notion page so I actually understand where my electricity went and what to change.

Trigger: cron, every Sunday at 18:00 in my local timezone.

Integrations: Home Assistant and Notion.

Step 1. Figure out my setup. Call Home Assistant's Get Configuration first so the report uses the right unit system (kWh, currency) and the right timezone. Never hardcode units or a currency symbol.

Step 2. Find the right sensors. Use Home Assistant's List States and select entities whose device_class is power, energy, or monetary, plus common patterns like utility_meter helpers, total kWh sensors, grid-import sensors, and cost sensors. If there are zero qualifying energy or power sensors, exit silently and do not post anything to Notion.

Step 3. Pull a week of history. For each qualifying entity, call Home Assistant's Get History for the past 7 days. If prior data exists, also pull the 7 days before that so week-over-week change can be computed.

Step 4. Analyze. Compute: total kWh consumed this week, week-over-week percent change vs the prior 7 days (skip this metric if no prior data), the top 3 biggest consumers by kWh, the rough time-of-day pattern (morning, afternoon, evening, overnight), and any clearly anomalous spikes such as one circuit suddenly doubling or a device that looks like it ran 24/7 when it usually cycles (a freezer, a heater stuck on, etc.).

Step 5. Write a short narrative report (a few paragraphs, not a wall of text or a JSON dump), followed by 2 or 3 concrete, low-effort suggestions for the coming week. Only mention cost if a monetary or cost sensor is present. Never invent dollar figures or estimate rates.

Step 6. Post it to Notion. Prefer Append Block Children on my existing 'Home Log' page so the weekly entries stack up into a real journal, with a dated H2 heading like 'Energy report, Sun Jun 7'. If no 'Home Log' page is configured, fall back to Create a Page under a parent page I choose at setup.

Guardrails:

1. Skip silently with no error and no Notion write if Home Assistant returns no qualifying sensors.

2. Always read units and timezone from Home Assistant's Get Configuration.

3. Never fabricate costs when no cost sensor is present, just report kWh.

4. Keep the tone human and concise. This is a Sunday-evening read, not a dashboard export.

Additional information

What does this prompt do?

Pulls the past week of power and energy data from your Home Assistant so you can finally see where the electricity actually went.
Writes a short narrative report covering total usage, week-over-week change, your biggest consumers, time-of-day patterns, and any unusual spikes.
Suggests two or three concrete, low-effort fixes to try in the coming week.
Posts everything to your Notion home log on Sunday evening, with a dated heading so a real history builds up over time.

What do I need to use this?

A Home Assistant setup with at least one power, energy, or cost sensor in use (anything that tracks watts, kWh, or utility cost will work).
A Notion workspace with a page (such as a 'Home Log') shared with the General Input connection.

How can I customize it?

Change the day or time the report runs, for example Friday afternoons instead of Sunday evenings.
Point it at a different Notion page, or have it create a brand new dated page each week instead of appending to one log.
Adjust how chatty the report is and what the suggestions focus on (cost savings, habit changes, or device tuning).

Frequently asked questions

What if I don't have a cost sensor set up in Home Assistant?

The report will only show kWh. It will never invent or estimate dollar figures, only what it can actually measure from your existing sensors.

Do I need to carefully name or label my sensors first?

No. It picks sensors by their built-in device class (power, energy, monetary), so even default names get detected.

What happens the very first week, when there is nothing to compare against?

It will skip the week-over-week comparison and just report the current week's totals. The comparison kicks in once you have a second week of data.

Will it post a noisy 'no data' entry if Home Assistant has no energy sensors yet?

No. It exits silently in that case, so your Notion home log stays clean until your setup actually has something to report on.

Can I send the report somewhere other than Notion?

This version posts to Notion. If you want it in Slack, email, or another tool, you can fork the prompt and swap out the destination.