Explore
Plans
Mobile menu Close menu
Sense Energy Monitor Device turned On/Off. Google Sheets Add row to spreadsheet.

Log device state into single spreadsheet on GoogleDrive

by turnercova
15
Connect

Create two recipies for each device (ON/off) to collect all the state changes from your Sense Energy Monitor. Helps determine if you have an appliance that is turning on when it shouldn't be.

If

Sense Energy Monitor icon
Device turned On/Off

This trigger fires every time a device in your house turns on or off.

Then

Google Sheets icon
Add row to spreadsheet

This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.

Fewer details
More details