Get a notification when the door was opened
Other popular Aqara Home for US workflows and automations
-
35
-
-
#EnergyChallenge: When Aqara Door/Window Sensor is open, turn off Midea AC.
-
-
#EnergyChallenge: When Aqara Door/Window Sensor is open, turn off Midea Fan.
-
-
If Double Rocker H1 Left Switch Turns Off, Wait. 5 minutes Then Deactivate Bathroom Vent
-
-
Press SkyBell Doorbell When Detecting Motion on Another Device
-
-
#EnergyChallenge: When Aqara Door/Window Sensor is open, turn off Midea Air Purifier.
-
-
If Aqara FP2 detects motion, then Set light level
-
-
#EnergyChallenge: When Aqara Door/Window Sensor is open, turn off Midea AC.
-
-
Automatically Turn On Your Smart Dehumidifier When Humidity Rises
-
Build your own Aqara Home for US and Google Sheets automations
Triggers (If this)
-
Wall Switch was turned on/off (for Single Rocker / Channel switch or module)
This trigger fires when the specified single rocker switch is turned on/off.
-
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.
-
Wall Switch was turned on/off (for Double Rocker / Channel switch or module)
This trigger fires when the specified double rocker switch is turned on/off.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Wall Switch was turned on/off (for Triple Rocker / Channel switch or module)
This trigger fires when the specified triple rocker switch is turned on/off.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Relay Controller was turned on/off (for 2 Channels )
This trigger fires when the specified Relay Controller is turned on/off.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Hub light / bulb was turned on/off
This trigger fires when the specified light is turned on/off.
-
Plug was turned on/off
This trigger fires when the specified plug is turned on/off.
-
Click (for Wireless Single Rocker / Mini switch)
This trigger fires when the specified single rocker switch is single clicked/double clicked/long pressed.
-
Click (for Wireless Double Rocker switches)
This trigger fires when the specified double rocker switch is single clicked/double clicked/long pressed.
-
Temperature reaches up to
This trigger fires when the temperature reaches the specified value.
-
Temperature drops to
This trigger fires when the temperature drops to the specified value.
-
Humidity reaches up to
This trigger fires when the humidity reaches the specified value.
-
Humidity drops to
This trigger fires when the humidity drops to the specified value.
-
TVOC reaches up to
This trigger fires when the tvoc reaches the specified value.
-
TVOC drops to
This trigger fires when the tvoc drops to the specified value.
-
Darkness is detected
This trigger fires when the darkness is detected.
-
Camera detects sound
This trigger fires when the specified camera detects sounds. To use this trigger, camera's sound detection should be turned on.
-
Camera detects motion
This trigger fires when the specified camera detects motion. To use this trigger, camera's motion detection should be turned on.
-
Motion is detected
This trigger fires when motion is detected.
-
Leak is detected
This trigger fires when water leak is detected.
-
Water recedes
This trigger fires when the water recedes.
-
Door and window sensor is open
This trigger fires when the door and window sensor is open.
-
Door and window sensor is closed
This trigger fires when the door and window sensor is closed.
-
Motion is detected and brightness is below
This trigger fires when the motion is detected and brightness is below the specified value.
-
Motion is detected and brightness is above
This trigger fires when the motion is detected and brightness is above the specified value.
-
Cube was triggered after one-minute inactivity
This trigger fires when the cube is triggered after one-minute inactivity.
-
Cube was flipped
This trigger fires when the the cube was flipped
-
Cube was pushed
This trigger fires when the cube was pushed.
-
Cube was rotated
This trigger fires when the cube was rotated.
-
Cube was tapped twice
This trigger fires when the cube was tapped twice.
-
Cube was shaken
This trigger fires when the cube was shaken.
-
Drop is detected
This trigger fires when the drop is detected.
-
Tilt is detected
This trigger fires when the tilt is detected.
-
Vibration is detected
This trigger fires when the vibration is detected.
-
Curtain is fully opened/closed
This trigger fires when the specified curtain is fully opened/closed.
-
Single press the switch (for Single Rocker switches)
This trigger fires when single press the specified switch.
-
Single press the switch (for Double Rocker switches)
This trigger fires when single press the specified switch.
-
Low battery
The battery of the device is low
-
Bell ringing was detected
This trigger fires when When Bell ringing is detected
-
Forcible demolition alarm detected
This trigger fires when Forcible demolition alarm detected
-
Recognize the specified face
This trigger fires when recognize the specified face
-
Recognize strange faces
This trigger fires when recognize strange faces
-
Somebody linger
This trigger fires when somebody is lingering at your doorstep
-
Cube flip to side 1
This trigger fires when the cube flip to side 1
-
Cube flip to side 2
This trigger fires when the cube flip to side 2
-
Cube flip to side 3
This trigger fires when the cube flip to side 3
-
Cube flip to side 4
This trigger fires when the cube flip to side 4
-
Cube flip to side 5
This trigger fires when the cube flip to side 5
-
Cube flip to side 6
This trigger fires when the cube flip to side 6
-
Zone detection
This trigger fires when an event is detected in the zone
-
Recognize the specified vehicle
This trigger fires when the camera recognize the specified vehicle
-
Click (Wireless switch for S1E)
This trigger fires when the S1E switch is clicked.
-
Presence is detected
This trigger fires when presence detected.
-
Absence is detected
This trigger fires when absence detected.
-
Pet detected
This trigger fires when when the camera detects pet.
-
Package detected
This trigger fires when when the camera detects package.
-
Unknown vehicle detected
This trigger fires when the camera detects detects unknown vehicle.
-
Human detected
This trigger fires when when the camera detects human.
-
The door is opened
this trigger fires when the door, gate, window is opened
-
The door is closed
This trigger fires when the door, gate, window is closed.
-
illuminance drops to
This trigger fires when the illuminance drops to the specified value.
-
illuminance reaches up to
This trigger fires when the illuminance reaches the specified value.
Wall Switch was turned on/off (for Single Rocker / Channel switch or module)
This trigger fires when the specified single rocker switch is turned on/off.
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.
Wall Switch was turned on/off (for Double Rocker / Channel switch or module)
This trigger fires when the specified double rocker switch is turned on/off.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Wall Switch was turned on/off (for Triple Rocker / Channel switch or module)
This trigger fires when the specified triple rocker switch is turned on/off.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Relay Controller was turned on/off (for 2 Channels )
This trigger fires when the specified Relay Controller is turned on/off.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Hub light / bulb was turned on/off
This trigger fires when the specified light is turned on/off.
Plug was turned on/off
This trigger fires when the specified plug is turned on/off.
Click (for Wireless Single Rocker / Mini switch)
This trigger fires when the specified single rocker switch is single clicked/double clicked/long pressed.
Click (for Wireless Double Rocker switches)
This trigger fires when the specified double rocker switch is single clicked/double clicked/long pressed.
Temperature reaches up to
This trigger fires when the temperature reaches the specified value.
Temperature drops to
This trigger fires when the temperature drops to the specified value.
Humidity reaches up to
This trigger fires when the humidity reaches the specified value.
Humidity drops to
This trigger fires when the humidity drops to the specified value.
TVOC reaches up to
This trigger fires when the tvoc reaches the specified value.
TVOC drops to
This trigger fires when the tvoc drops to the specified value.
Darkness is detected
This trigger fires when the darkness is detected.
Camera detects sound
This trigger fires when the specified camera detects sounds. To use this trigger, camera's sound detection should be turned on.
Camera detects motion
This trigger fires when the specified camera detects motion. To use this trigger, camera's motion detection should be turned on.
Motion is detected
This trigger fires when motion is detected.
Leak is detected
This trigger fires when water leak is detected.
Water recedes
This trigger fires when the water recedes.
Door and window sensor is open
This trigger fires when the door and window sensor is open.
Door and window sensor is closed
This trigger fires when the door and window sensor is closed.
Motion is detected and brightness is below
This trigger fires when the motion is detected and brightness is below the specified value.
Motion is detected and brightness is above
This trigger fires when the motion is detected and brightness is above the specified value.
Cube was triggered after one-minute inactivity
This trigger fires when the cube is triggered after one-minute inactivity.
Cube was flipped
This trigger fires when the the cube was flipped
Cube was pushed
This trigger fires when the cube was pushed.
Cube was rotated
This trigger fires when the cube was rotated.
Cube was tapped twice
This trigger fires when the cube was tapped twice.
Cube was shaken
This trigger fires when the cube was shaken.
Drop is detected
This trigger fires when the drop is detected.
Tilt is detected
This trigger fires when the tilt is detected.
Vibration is detected
This trigger fires when the vibration is detected.
Curtain is fully opened/closed
This trigger fires when the specified curtain is fully opened/closed.
Single press the switch (for Single Rocker switches)
This trigger fires when single press the specified switch.
Single press the switch (for Double Rocker switches)
This trigger fires when single press the specified switch.
Low battery
The battery of the device is low
Bell ringing was detected
This trigger fires when When Bell ringing is detected
Forcible demolition alarm detected
This trigger fires when Forcible demolition alarm detected
Recognize the specified face
This trigger fires when recognize the specified face
Recognize strange faces
This trigger fires when recognize strange faces
Somebody linger
This trigger fires when somebody is lingering at your doorstep
Cube flip to side 1
This trigger fires when the cube flip to side 1
Cube flip to side 2
This trigger fires when the cube flip to side 2
Cube flip to side 3
This trigger fires when the cube flip to side 3
Cube flip to side 4
This trigger fires when the cube flip to side 4
Cube flip to side 5
This trigger fires when the cube flip to side 5
Cube flip to side 6
This trigger fires when the cube flip to side 6
Zone detection
This trigger fires when an event is detected in the zone
Recognize the specified vehicle
This trigger fires when the camera recognize the specified vehicle
Click (Wireless switch for S1E)
This trigger fires when the S1E switch is clicked.
Presence is detected
This trigger fires when presence detected.
Absence is detected
This trigger fires when absence detected.
Pet detected
This trigger fires when when the camera detects pet.
Package detected
This trigger fires when when the camera detects package.
Unknown vehicle detected
This trigger fires when the camera detects detects unknown vehicle.
Human detected
This trigger fires when when the camera detects human.
The door is opened
this trigger fires when the door, gate, window is opened
The door is closed
This trigger fires when the door, gate, window is closed.
illuminance drops to
This trigger fires when the illuminance drops to the specified value.
illuminance reaches up to
This trigger fires when the illuminance reaches the specified value.
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.
-
Current temperature
This query returns the current temperature.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
Current humidity
This query returns current humidity.
-
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 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 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 worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Current temperature
This query returns the current temperature.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
Current humidity
This query returns current humidity.
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 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 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 worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
-
Wake up camera
This action will wake up the specified camera.
-
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.
-
Sleep camera
This action will sleep the specified camera.
-
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.
-
Wake up / sleep camera
This action will wake up / sleep of the specified camera.
-
Enable motion detection
This action will enable motion detection of the specified camera.
-
Enable sound detection
This action will enable sound detection of the specified camera.
-
Disable motion detection
This action will disable motion detection of the specified camera.
-
Disable sound detection
This action will disable sound detection of the specified camera.
-
Enable / Disable motion detection
This action will enable / disable motion detection of the specified camera.
-
Enable / Disable sound detection
This action will enable / disable sound detection of the specified camera.
-
Turns on/off plug
This action will turn on/off the plug of your choosing.
-
Turn on/off switch (for Single Rocker switches)
This action will turn on/off the single rocker switches of your choosing.
-
Turn on/off switch (for Double Rocker switches)
This action will turn on/off the double rocker switches of your choosing.
-
Turn on/off switch (for Triple Rocker switches)
This action will turn on/off the triple rocker switches of your choosing.
-
Turn on/off Wireless Relay Controller (for 2 Channels)
This action will turn on/off the wireless relay controller of your choosing.
-
Turns on/off the light
This action will turn on/off the light of your choosing.
-
Open the curtain
This action will open the curtain of your choosing.
-
Close the curtain
This action will close the curtain of your choosing.
-
Open/close the curtain
This action will open/close the curtain of your choosing.
-
Stop the curtain
This action will stop the curtain of your choosing.
-
Open the curtain to the designated position
This action will open the curtain of your choosing to the designated position.
-
Feeding for once
This action will make feeder feed once
-
Set brightness
This action will Set the light of brightness
-
Set color temperature
This action will set the color temperature of lamp
-
Set color
This action will set the color of the light
-
Turn on/off the lamp (for 2 Channels)
This action will Turn on/off the light of your choosing.
-
Run light scenario
This action will run the light scenario
-
Open the door
This action will open the door, gate, window of your choosing
-
Close the door
This action will close the door, gate, window of your choosing
Wake up camera
This action will wake up the specified camera.
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.
Sleep camera
This action will sleep the specified camera.
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.
Wake up / sleep camera
This action will wake up / sleep of the specified camera.
Enable motion detection
This action will enable motion detection of the specified camera.
Enable sound detection
This action will enable sound detection of the specified camera.
Disable motion detection
This action will disable motion detection of the specified camera.
Disable sound detection
This action will disable sound detection of the specified camera.
Enable / Disable motion detection
This action will enable / disable motion detection of the specified camera.
Enable / Disable sound detection
This action will enable / disable sound detection of the specified camera.
Turns on/off plug
This action will turn on/off the plug of your choosing.
Turn on/off switch (for Single Rocker switches)
This action will turn on/off the single rocker switches of your choosing.
Turn on/off switch (for Double Rocker switches)
This action will turn on/off the double rocker switches of your choosing.
Turn on/off switch (for Triple Rocker switches)
This action will turn on/off the triple rocker switches of your choosing.
Turn on/off Wireless Relay Controller (for 2 Channels)
This action will turn on/off the wireless relay controller of your choosing.
Turns on/off the light
This action will turn on/off the light of your choosing.
Open the curtain
This action will open the curtain of your choosing.
Close the curtain
This action will close the curtain of your choosing.
Open/close the curtain
This action will open/close the curtain of your choosing.
Stop the curtain
This action will stop the curtain of your choosing.
Open the curtain to the designated position
This action will open the curtain of your choosing to the designated position.
Feeding for once
This action will make feeder feed once
Set brightness
This action will Set the light of brightness
Set color temperature
This action will set the color temperature of lamp
Set color
This action will set the color of the light
Turn on/off the lamp (for 2 Channels)
This action will Turn on/off the light of your choosing.
Run light scenario
This action will run the light scenario
Open the door
This action will open the door, gate, window of your choosing
Close the door
This action will close the door, gate, window of your choosing
How to connect Aqara Home for US and Google Sheets
Find or create an Applet
Start by discovering an automation to connect or customizing your own. It's quick and easy.Connect IFTTT to your accounts
Securely connect your Aqara Home for US and Google Sheets accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!Upgrade your automations with
-
Connect to more Applets
Connect up to 20 automations with Pro, and unlimited automations with Pro+ -
Add multiple actions with exclusive services
Add real-time data and multiple actions for smarter automations -
Get access to faster speeds
Get faster updates and more actions with higher rate limits and quicker checks
More on Discord and Instagram
About Aqara Home for US
Aqara offers a wide range of smart products ranging from a variety of sensors to switches,lights and hubs and a comprehensive home automation system with various kinds of smart control. We believe that everyone deserves a smart home solution that is accessible, beautifully designed, and easy to set up.
About Google Sheets
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.