Connect Energenie Mi|Home to Google Sheets and unlock powerful automations

This Trigger fires every time a device reports that the temperature has dropped below a threshold temperature.

This trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.

This Trigger fires every time an eTRV reports that the temperature has risen above a threshold temperature.

This trigger fires when a new worksheet is added to a spreadsheet you specify.

This Trigger fires whenever a motion sensor detects movement nearby.

This trigger fires when a new row is added to a spreadsheet you specify.

This Trigger fires whenever a specific sensor detects that its door/window was opened.

This trigger fires when a particular cell is updated within the spreadsheet you specify.

This Trigger fires whenever a specific sensor detects that its door/window was closed.

This Trigger fires every time one of your Mi|Home devices is powered on.

This Trigger fires every time one of your Mi|Home devices is powered off.

This trigger fires when a MiHome Click device is single-clicked.

This trigger fires when a MiHome Click device is double-clicked.

This trigger fires when a MiHome Click device is long-pressed.

This query returns the current values in a given row. Values from columns A-Z are available as ingredients.

This query returns the instances when a MiHome Click device was signle-clicked.

This query returns the current value of a single cell in your spreadsheet.

This query returns a list of whenever a specific sensor detected that its door/window was opened.

This query returns a list of when a new row is added to a spreadsheet you specify.

This query returns a list of whenever a specific sensor detected that its door/window was closed.

This query returns a list of when a particular cell was updated within the spreadsheet you specify.

This query returns a list of when a MiHome Click device was long-pressed.

This query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.

This query returns a list of when a device reports that the temperature was dropped below a threshold temperature. Note: this query will only return future events after this Applet is created.

This query returns a list of when a new worksheet is added to a spreadsheet you specify.

This action will set the dimmer level

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.

This action will power off a Mi|Home device, identified by its name.

This action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.

This Action will turn on one of your Mi|Home devices.

This action will power on a Mi|Home device, identified by its name.

This Action will turn off one of your Mi|Home devices.

This Action will set the target temperature for the selected device to the temperature you specify.

This Action will turn off a whole group of Mi|Home devices simultaneously.

This Action will turn on a whole group of Mi|Home devices simultaneously.