[Blueprint] Power State Monitor with Google Sheets & Smart Notifications

Blueprints Exchange
, ,
1

Power State Monitor Blueprint - Smart Appliance Monitoring with Google Sheets Integration

:dart: Overview

Monitor any appliance’s power states, log activities to Google Sheets, and receive smart notifications. Perfect for fridges, freezers, washing machines, dryers, and more! Turn any power-monitored device into a smart device with state detection and logging.

Open your Home Assistant instance and show the blueprint import dialog with a specific blueprint pre-filled.

:sparkles: Key Features

  1. Smart Power State Detection

    • Automatic detection of working/idle states
    • Optional extra state detection (e.g., door events)
    • Precise power change monitoring
    • Configurable thresholds for any device
    • Power stabilization delays for accuracy
    • Parallel execution with configurable instances

  2. :bell: Intelligent Notifications

    • Extra state timeout warnings (e.g., door left open)
    • Cycle completion alerts (e.g., washer finished)
    • Mobile app & web UI notifications
    • Persistent notifications until acknowledged
    • Customizable notification titles

  3. :bar_chart: Google Sheets Integration

    • Automatic logging of all state changes
    • Power change tracking
    • Elapsed time calculations in minutes & (HH:MM:SS)
    • Customizable worksheet names

  4. :zap: Flexible Configuration

    • Adjustable power thresholds
    • Custom state names

:bulb: Real-World Applications

1. Kitchen Appliances

  • Fridge/Freezer Monitoring
    • Track compressor cycles
    • Detect door open/close events
    • Get alerts for door left open
    • Analyze cooling patterns

2. Laundry Management

  • Washer/Dryer Monitoring
    • Know exactly when cycles finish & get alerts
    • Track cycle durations

3. Energy Analysis

  • Power Usage Insights
    • Track consumption patterns
    • Monitor standby power
    • Historical data analysis

:bar_chart: Power Reference Values

Two-State Devices

  • Washing Machine: 1.2W idle, 350-500W working
  • Dryer: 2-3W idle, 800-1000W working
  • Freezer: 0-2W idle, 150-300W working

Three-State Devices

  • Modern Fridge:
    • Idle: 0-2W
    • Compressor: 150-250W
    • Door Events: 35-70W change
    • Water/Ice: 40-80W spike

:wrench: Requirements

  1. Home Assistant

    • HACS for Google Sheets integration
    • Mobile app (optional, for notifications)

  2. Hardware

    • Power monitoring device (watts)
    • 1-5 second update rate recommended
    • Compatible with Home Assistant
    • :warning: For volt/amp meters, use template sensor

  3. Google Account

    • Google Drive access
    • Google Cloud Console access
    • OAuth 2.0 credentials

:memo: Setup Instructions

Detailed setup instructions are included in the blueprint, covering:

  1. Google Sheets Integration

    • HACS installation
    • OAuth configuration
    • Worksheet setup
    • Integration configuration

  2. Helper Entities

    • State tracking booleans
    • Timing entities
    • Naming conventions
    • Entity configuration

  3. Power Configuration

    • Threshold settings
    • State detection tuning
    • Update frequency
    • Stabilization delays

  4. Notification Setup

    • Mobile devices selection
    • Web UI options
    • Alert timeouts
    • Custom messages

:handshake: Contributing

Feel free to:

  • Share your experience
  • Suggest improvements
  • Report issues
  • Contribute to development

:page_facing_up: Links

:pray: Acknowledgments

Special thanks to the Home Assistant community for inspiration.

Versions

  • 13/01/2025: Code clean up and better naming & documentation
2 Likes