Add Google Sheets row when Aqara switch is pressed
by
23 ready-made Aqara Home for EU and Google Sheets Applets
Turn one on, or build your own. Aqara Home for EU can start an automation with "Absence is detected", and IFTTT can then run "Add multiple rows to spreadsheet" on Google Sheets.-
-
-
Add a row to Google Sheets when Aqara vibration is detectedby
-
-
Log Aqara door sensor closure to Google Sheetsby
-
-
Add Google Sheets row when Aqara motion detectedby
-
-
-
-
-
- 2+
Blink Philips Hue lights, send notifications, and log data when a water leak is detectedby -
-
Log Aqara switch actions and send notificationsby
-
-
Update Google Sheets cell when humidity reaches a set levelby
-
-
Update Google Sheets cell when Aqara humidity drops below set levelby
-
-
Log Aqara switch activity to Google Sheetsby
-
Automate Aqara Home for EU and Google Sheets from your AI assistant
Have Claude, ChatGPT, or Cursor build and run Aqara Home for EU and Google Sheets automations for you, like “Add Google Sheets row when Aqara switch is pressed”, with IFTTT MCP.
Set up IFTTT MCP
Create your own Aqara Home for EU and Google Sheets workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
110 triggers, queries, and actions
Absence is detected
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when absence detected.
Bell ringing was detected
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when When Bell ringing is detected
Camera detects motion
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the specified camera detects motion. To use this trigger, camera's motion detection should be turned on.
Camera detects sound
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the specified camera detects sounds. To use this trigger, camera's sound detection should be turned on.
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Click (for Wireless Double Rocker switches)
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the specified double rocker switch is single clicked/double clicked/long pressed.
Click (for Wireless Single Rocker / Mini switch)
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the specified single rocker switch is single clicked/double clicked/long pressed.
Cube flip to side 1
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the cube flip to side 1
Cube flip to side 2
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the cube flip to side 2
Cube flip to side 3
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the cube flip to side 3
Cube flip to side 4
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the cube flip to side 4
Cube flip to side 5
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the cube flip to side 5
Current temperature
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current temperature.
Current humidity
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns current humidity.
Current Motion Status
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current motion status.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.
Current values of a row
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Find rows in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the rows of a worksheet with a cell that contains or matches a value, with each row's number for "Update row in spreadsheet". Use it to look up rows instead of reading them one at a time.
Get rows in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query reads 50 rows of a worksheet, starting at the row you choose, and returns the ones with data. Use it to read a table, header row included, in one run instead of one row at a time. To read on, add 50 to the start row.
History of rows added to spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new row is added to a spreadsheet you specify.
History of spreadsheets added to folder
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 Cell was updated in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of worksheets in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Add multiple rows to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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.
Add row to top of spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.
Close the curtain
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will close the curtain of your choosing.
Close the door
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will close the door, gate, window of your choosing
Create spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new blank spreadsheet in a Google Drive folder you specify. If a spreadsheet with the same name already exists, no new file is created.
Disable motion detection
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will disable motion detection of the specified camera.
Disable sound detection
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will disable sound detection of the specified camera.
Enable / Disable motion detection
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will enable / disable motion detection of the specified camera.
Enable / Disable sound detection
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will enable / disable sound detection of the specified camera.
Enable motion detection
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will enable motion detection of the specified camera.
Enable sound detection
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will enable sound detection of the specified camera.
Absence is detected
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when absence detected.
Add multiple rows to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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.
Add row to top of spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.
Bell ringing was detected
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when When Bell ringing is detected
Camera detects motion
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the specified camera detects motion. To use this trigger, camera's motion detection should be turned on.
Camera detects sound
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the specified camera detects sounds. To use this trigger, camera's sound detection should be turned on.
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Click (for Wireless Double Rocker switches)
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the specified double rocker switch is single clicked/double clicked/long pressed.
Click (for Wireless Single Rocker / Mini switch)
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the specified single rocker switch is single clicked/double clicked/long pressed.
Close the curtain
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will close the curtain of your choosing.
Close the door
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will close the door, gate, window of your choosing
Build an automation in seconds!
If
Select a trigger the automation will use
Absence is detected
Bell ringing was detected
Camera detects motion
Camera detects sound
Cell updated in spreadsheet
Click (for Wireless Double Rocker switches)
Click (for Wireless Single Rocker / Mini switch)
Cube flip to side 1
Cube flip to side 2
Cube flip to side 3
Cube flip to side 4
Cube flip to side 5
Cube flip to side 6
Cube was flipped
Cube was pushed
Cube was rotated
Cube was shaken
Cube was tapped twice
Cube was triggered after one-minute inactivity
Curtain is fully opened/closed
Darkness is detected
Door and window sensor is closed
Door and window sensor is open
Drop is detected
Fire is detected
Fire is disappeared
Forcible demolition alarm detected
Hub light / bulb was turned on/off
Human detected
Humidity drops to
Humidity reaches up to
illuminance drops to
illuminance reaches up to
Leak is detected
Low battery
Motion is detected
Motion is detected and brightness is above
Motion is detected and brightness is below
Natural gas is detected
Natural gas is disappeared
New row added to spreadsheet
New spreadsheet added to folder
New worksheet in spreadsheet
Package detected
Pet detected
Plug was turned on/off
Presence is detected
Recognize strange faces
Recognize the specified face
Recognize the specified vehicle
Single press the switch (for Double Rocker switches)
Single press the switch (for Single Rocker switches)
Somebody linger
Temperature drops to
Temperature reaches up to
The door is closed
The door is opened
Tilt is detected
TVOC drops to
TVOC reaches up to
Unknown vehicle detected
Vibration is detected
Wall Switch was turned on/off (for Double Rocker / Channel switch or module)
Wall Switch was turned on/off (for Single Rocker / Channel switch or module)
Water recedes
Wireless Relay Controller was turned on/off (for 2 Channels )
Zone detection
Then
Select an action the automation will perform
Add multiple rows to spreadsheet
Add row to spreadsheet
Add row to top of spreadsheet
Close the curtain
Close the door
Create spreadsheet
Disable motion detection
Disable sound detection
Enable / Disable motion detection
Enable / Disable sound detection
Enable motion detection
Enable sound detection
Feeding for once
Open the curtain
Open the curtain to the designated position
Open the door
Open/close the curtain
Run light scenario
Set color
Sleep camera
Stop the curtain
Turn on/off switch (for Double Rocker / Channel switch or module)
Turn on/off switch (for Single Rocker / Channel switch or module)
Turn on/off the hub light / bulb
Turn on/off the lamp (for 2 Channels)
Turn on/off Wireless Relay Controller (for 2 Channels)
Turns on/off plug
Update cell in spreadsheet
Update multiple rows in spreadsheet
Update row in spreadsheet
Wake up / sleep camera
Wake up camera
You can add delays, queries, and more actions in the chat.
GET STARTED
How to connect to a Aqara Home for EU automation
Find an Applet using Aqara Home for EU and Google Sheets
Find an automation to connect to, or create your own!Connect IFTTT to your accounts
Securely connect the Applet services to your respective accounts.Finalize and customize your Applet
Review trigger and action settings, and click connect. Simple as that!Make more happen with your credits
-
More credits, more possibilities
Get more credits per month to power more automation activity. -
Power more advanced automations
Use credits to power your automations, including actions that require more processing. -
Access faster speeds and higher rate limits
Get faster updates and more actions with increased rate limits and more frequent checks.
Aqara Home for EU and Google Sheets tips, tools, and resources
More on Aqara Home for EU and Google Sheets
About Aqara Home for EU
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.