Automation to document device power usage daily? (Aeotec Heavy Duty Switch)

[BeegW]

I just added an Aeotec Heavy Duty Smart Switch, Gen 5 US (ZW078) to my SmartThings network. It is hooked up to a pump and I want to use it to get daily updates on how much power the pump has used.

The SmartThings app will display Watts and kWh consumed with the option to reset it back to 0. I’d like to find a way to send this data to a spreadsheet or another place where I can monitor performance over time. Ideally, I’d like to set control limits where it will notify if power use becomes excessive.

I’m not a programmer but looked at IFTT and SmartApps for solutions. Any ideas?

[rontalley]

Check out this thread.

Google Sheets Charts

There are a couple Google Sheet data logging smart apps (GoogleSheetsLogging and SimpleEventLogger) and I just wanted to share a way to get a chart from a Google Sheet that could be used in SmartTiles or potentially a DH in the SmartThings App. The trick is to publish the chart as an image; from that, you have a URL that can be used anywhere you can reference an image on the internet. 1-set up your preferred logging smart app 2-insert chart from button bar, set up a chart as you like. Note: make sure to include the last row of the sheet in data ranges and this will allow the chart to refresh the new data added by your smart app. 3-(optional)from chart pulldown, select ‘move to own sheet’ (now the chart will have its own tab) 4-click publish, under link, change interactive pulldown to…

[GSzabados (Gabor Szabados)]

Or look at this:

SmartThings Data Visualisation using InfluxDB and Grafana

Hi all, Here’s a write-up of how I’m using InfluxDB and Grafana to visualise SmartThings device states in charts and dashboards. The solution uses a custom SmartApp I’ve written to send data from SmartThings to InfluxDB. Crucially it supports the database server being on the same private LAN as the SmartThings hub, so there’s no need to make your database server accessible from the internet. I’m quite pleased with it so far. In conjunction with my Evohome (Connect) SmartApp I’m getting some great graphs of my home heating behaviour and energy usage. Here’s an example of a temperature chart: [image] Here’s an Evohome Heating Zone chart with some overlays: [image] I aim to post another article covering some of the more-advanced Grafana features like templating and annotations in th…

[JDRoberts]

There’s a data logging FAQ. It covers both of the previous suggestions and several more.

ROUNDUP: Data Logging and Charting Solutions

[Automated_House (Jimmy)]

They might be coming out with their own energy management app. Will try and find more info at SDC.

[Stavros99 (Steve)]

Hey, how did you pair the Aeotec heavy duty switch with smartthings? I installed one today and seems there is no way to pair it. No option of the switch model in smartthings, no barcode on the product, no button on the product?

[JDRoberts]

I’m sure it’s very frustrating, but give us a chance to answer at least one of your multiple duplicate questions before posting in threads which are older than 2023, as smartthings went through a major architecture change at that time and older threads like this one aren’t really going to be of much help anyway.

If you check the user manual for this model, you will see that the action button is inside the case. I posted a more detailed answer in your other thread:

Aeotec heavy duty 40amp switch pairing?

Let’s continue the conversation there, so we don’t keep bringing up threads about the old architecture, which are just going to be confusing to most people. Thanks!