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.