Aqara Home for RU

Google Sheets

Connect Aqara Home for RU to Google Sheets and unlock powerful 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.

Wireless Relay Controller was turned on/off (for 2 Channels )

This trigger fires when the specified Wireless Relay Controller is turned on/off.

New worksheet in spreadsheet

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

Hub light / bulb was turned on/off

This trigger fires when the specified light is turned on/off.

New row added to spreadsheet

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

Plug was turned on/off

This trigger fires when the specified plug is turned on/off.

Cell updated in spreadsheet

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

Leak is detected

This trigger fires when water leak is detected.

Tilt is detected

This trigger fires when the tilt is detected.

Motion is detected

This trigger fires when motion is detected.

Cube was tapped twice

This trigger fires when the cube was tapped twice.

Cube was triggered after one-minute inactivity

This trigger fires when the cube is triggered after one-minute inactivity.

Humidity reaches up to

This trigger fires when the humidity reaches the specified value.

Cube was rotated

This trigger fires when the cube was rotated.

Click (for Wireless Double Rocker switches)

This trigger fires when the specified double rocker switch is single clicked/double clicked/long pressed.

Camera detects motion

This trigger fires when the specified camera detects motion. To use this trigger, camera's motion detection should be turned on.

Temperature reaches up to

This trigger fires when the temperature reaches the specified value.

Fire is detected

This trigger fires when fire is detected.

Fire is disappeared

This trigger fires when fire is no detected.

Water recedes

This trigger fires when the water recedes.

Click (for Wireless Single Rocker / Mini switch)

This trigger fires when the specified single rocker switch is single clicked/double clicked/long pressed.

Door and window sensor is open

This trigger fires when the door and window sensor is open.

Humidity drops to

This trigger fires when the humidity drops to the specified value.

Vibration is detected

This trigger fires when the vibration is detected.

Motion is detected and brightness is above

This trigger fires when the motion is detected and brightness is above the specified value.

Cube was shaken

This trigger fires when the cube was shaken.

Curtain is fully opened/closed

This trigger fires when the specified curtain is fully opened/closed.

Camera detects sound

This trigger fires when the specified camera detects sounds. To use this trigger, camera's sound detection should be turned on.

Door and window sensor is closed

This trigger fires when the door and window sensor is closed.

Temperature drops to

This trigger fires when the temperature drops to the specified value.

TVOC drops to

This trigger fires when the tvoc drops to the specified value.

Cube was pushed

This trigger fires when the cube was pushed.

TVOC reaches up to

This trigger fires when the tvoc reaches the specified value.

Cube was flipped

This trigger fires when the the cube was flipped

Natural gas is disappeared

This trigger fires when no natural gas is detected.

Natural gas is detected

This trigger fires when natural gas is detected.

Motion is detected and brightness is below

This trigger fires when the motion is detected and brightness is below the specified value.

Drop is detected

This trigger fires when the drop is detected.

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

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 when the camera detects unknown vehicle.

Human detected

This trigger fires when when the camera detects human.

Recognize the specified vehicle

This trigger fires when when the camera recognize the specified vehicle.

The door is closed

this trigger fires when the door, gate, window is closed

The door is opened

this trigger fires when the door, gate, window is opened

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.

Actions (Then that)

Wake up / sleep camera

This action will wake up / sleep of 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.

Close the curtain

This action will close the curtain of your choosing.

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.

Enable / Disable sound detection

This action will enable / disable sound detection of the specified camera.

Open the curtain to the designated position

This action will open the curtain of your choosing to the designated position.

Turn on/off switch (for Single Rocker / Channel switch or module)

This action will turn on/off the single rocker switches or module of your choosing.

Disable sound detection

This action will disable sound detection of the specified camera.

Sleep camera

This action will sleep the specified camera.

Turns on/off plug

This action will turn on/off the plug of your choosing.

Wake up camera

This action will wake up the specified camera.

Open/close the curtain

This action will open/close the curtain of your choosing.

Open the curtain

This action will open the curtain of your choosing.

Stop the curtain

This action will stop the curtain of your choosing.

Enable / Disable motion detection

This action will enable / disable motion detection of the specified camera.

Turn on/off the hub light / bulb

This action will turn on/off the light 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.

Disable motion detection

This action will disable motion detection of the specified camera.

Enable sound detection

This action will enable sound detection of the specified camera.

Enable motion detection

This action will enable motion detection of the specified camera.

Feeding for once

This action will make feeder feed once

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

Close the door

This action will close the door, gate, window of your choosing

Open the door

This action will open the door, gate, window of your choosing

IFTTT helps all your apps and devices work better together