Every month store the current counter reading of a Modbus energy meter to a Google speadsheet

1
Connect

Energy is valuable. It is becoming increasingly important to know how much you have used. Timberwolf Server can manage hundreds of energy meters via Modbus. This applet starts at midnight every month and reads the current value from the Timberwolf Server. You assign the respective meter to be used on the server. The applet saves the counter reading in the Google Spreadsheet "Power usage".

If

Date & Time icon
Every month on the

This Trigger fires every month on the day and time you specify.

With

History of Timberwolf object value changes icon
Query

This returns a list of value changes recorded after this query is created.

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

Explore more great ways to automate Google Sheets and Timberwolf Server