IFTTT
IFTTT
Explore
Plans
Log in
Get started
Mobile menu
Close menu
Back
Share this using the options below:
Quickly connect Energenie Mi|Home to Google Sheets
Send this automation to anyone using the options below.
Copy
Or copy link
Copy
Share
Connect
Energenie Mi|Home
to
Google Sheets
and unlock powerful automations
Start today
Other popular Energenie Mi|Home workflows and automations
Switch your Mi|Home adapter ON whenever an event starts
Google
4
MiHome sunrise trigger (Group)
by
fidge73
11
Switch your Mi|Home adapter OFF when the temperature rises above 20°C
Weather Underground
6
Turn off Energenie device every day at specific time
Energenie Mi|Home
254
Switch your Mi|Home adapter ON everyday at 9AM
Energenie Mi|Home
9
Switch my Appliance on
Energenie Mi|Home
341
MiHome turn on at sunset
by
antreid
122
Switch your Mi|Home adapter OFF everyday at sunrise
Weather Underground
23
Switch your Mi|Home adapter ON everyday at sunrise
Weather Underground
11
Useful Energenie Mi|Home and Google Sheets integrations
Triggers (If this)
Temperature drops below
This Trigger fires every time a device reports that the temperature has dropped below a threshold temperature.
New spreadsheet added to folder
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.
Temperature rises above
This Trigger fires every time an eTRV reports that the temperature has risen above a threshold temperature.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Motion detected
This Trigger fires whenever a motion sensor detects movement nearby.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Door/window opened
This Trigger fires whenever a specific sensor detects that its door/window was opened.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Door/window closed
This Trigger fires whenever a specific sensor detects that its door/window was closed.
Device powered on
This Trigger fires every time one of your Mi|Home devices is powered on.
Device powered off
This Trigger fires every time one of your Mi|Home devices is powered off.
MiHome Click is single-clicked
This trigger fires when a MiHome Click device is single-clicked.
MiHome Click is double-clicked
This trigger fires when a MiHome Click device is double-clicked.
MiHome Click is long-pressed
This trigger fires when a MiHome Click device is long-pressed.
Queries (With)
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
History of single-clicked MiHome Clicks
This query returns the instances when a MiHome Click device was signle-clicked.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of door/window opens
This query returns a list of whenever a specific sensor detected that its door/window was opened.
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
History of Door/window closes
This query returns a list of whenever a specific sensor detected that its door/window was closed.
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of MiHome Click is long-pressed
This query returns a list of when a MiHome Click device was long-pressed.
History of spreadsheets added to folder
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.
History of when temperature dropped below a threshold
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.
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
Set dimmer level
This action will set the dimmer level
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.
Power off device by name
This action will power off a Mi|Home device, identified by its name.
Update cell in spreadsheet
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.
Power on device
This Action will turn on one of your Mi|Home devices.
Power on device by name
This action will power on a Mi|Home device, identified by its name.
Power off device
This Action will turn off one of your Mi|Home devices.
Set target temperature
This Action will set the target temperature for the selected device to the temperature you specify.
Power off group
This Action will turn off a whole group of Mi|Home devices simultaneously.
Power on group
This Action will turn on a whole group of Mi|Home devices simultaneously.
IFTTT helps all your apps and devices work better together
Start automating