Register in Google Sheet when device is turn off
This trigger fires when the specified device/group is turned off.
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.
Explore more great ways to automate
Smart Life and Google Sheets