Press a SwitchBot with the Button widget
How this automation works
Automatically record when your SwitchBot door sensor detects that a door has been opened and no brightness is detected. This Applet runs whenever the contact sensor reports an open state with no light detected and adds a new entry to a Microsoft Excel worksheet. Perfect for keeping a detailed history of door activity for monitoring or security review.
If
Trigger ingredients
CreatedAt
Content
Then
Action fields
path
filename
formatted_row
worksheet_name
Services used in this Applet
You might also like...
-
1.7K
-
-
Turn on SwitchBot with a Button widget tap
446
-
-
Press Button widget to turn on SwitchBot devices and Hub Plus IR appliances
94
-
Related services
Create your own Microsoft 365 Excel and SwitchBot 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.
103 triggers, queries, and actions
Carbon dioxide changes
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
Whenever a preset carbon dioxide change detected, SwitchBot meter pro will try to trigger the service. E.g. if the carbon dioxide is too high, turn on SwitchBot air purifier.
Cell updated in workbook
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the workbook you specify.
Contact and Motion Detection
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
When Contact Sensor detected door/window opened or closed or left open, the SwitchBot contact sensor will try to trigger the service.
Hub 2's touch buttons pressed
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when one of the touch buttons of your Hub 2 is pressed. E.g. when the left touch button is pressed, turn on SwitchBot Color Bulb.
Lock status changed
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when the status of your SwitchBot Lock is changed.
Motion detected or no motion 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 5 minutes for Pro and Pro+ users, and every hour for Free users.
When Motion Sensor detected motion or no motion, the SwitchBot motion sensor will try to trigger the service.
New row added to workbook
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a workbook you specify.
Power changes
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
You can choose Plug Mini's behaviour as a trigger condition
Robot status changed
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when the status of your SwitchBot Robot Vacuum Cleaner changed
Temperature or humidity changes
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
Whenever a preset temperature and/or humidity change detected, SwitchBot Thermometer & Hygrometer (the Meter) will try to trigger the service. E.g. if the temperature is too high, turn on AC with the SwitchBot Hub Plus (the Hub Plus).
Water Detector State
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
You can use the Water Detector state as a condition to trigger an automation.
ハブ２のタッチボタンを押す
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
SwitchBotハブ２のタッチボタンを押すことをトリガー条件として設定することが可能です。例えば：ハブ２の左ボタンを押すと、SwitchBotスマート電球をオンにします。
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 workbook.
Add row to workbook
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 worksheet you specify in the workbook.
Back to base station
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.
The platform will back to base station
Bot press
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 trigger the specified Bot to press the switch.
Bot turn off
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 trigger the specified Bot to turn off the switch.
Bot turn on
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 trigger the specified Bot to turn on the switch.
Bulb Brightness
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.
You can set the brightness of your Color Bulb here.
Bulb Color
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.
You can set the color of your Color Bulb here.
Bulb Color Temperature
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.
You can set the color temperature of your Color bulb here.
Bulb Presets
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.
You can set the presets saved in your SwitchBot app here.
Ceiling Light Brightness
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.
You can set the brightness of your Ceiling Light here.
Ceiling Light Color Temperature
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.
You can set the color temperature of your Ceiling Light here.
Change water output for mopping
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.
Change water output for mopping
Add row to workbook
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 worksheet you specify in the workbook.
Back to base station
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.
The platform will back to base station
Bot press
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 trigger the specified Bot to press the switch.
Bot turn off
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 trigger the specified Bot to turn off the switch.
Bot turn on
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 trigger the specified Bot to turn on the switch.
Bulb Brightness
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.
You can set the brightness of your Color Bulb here.
Bulb Color
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.
You can set the color of your Color Bulb here.
Bulb Color Temperature
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.
You can set the color temperature of your Color bulb here.
Bulb Presets
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.
You can set the presets saved in your SwitchBot app here.
Carbon dioxide changes
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
Whenever a preset carbon dioxide change detected, SwitchBot meter pro will try to trigger the service. E.g. if the carbon dioxide is too high, turn on SwitchBot air purifier.
Ceiling Light Brightness
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.
You can set the brightness of your Ceiling Light here.
Ceiling Light Color Temperature
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.
You can set the color temperature of your Ceiling Light here.
Build an automation in seconds!
If
Select a trigger the automation will use
Then
Select an action the automation will perform
You can add delays, queries, and more actions in the next step!
More on Microsoft 365 Excel and SwitchBot
About Microsoft 365 Excel
Microsoft 365 Excel is a powerful spreadsheet program used for organizing, analyzing, and visualizing data. Leverage its capabilities to manage finances, track projects, and perform complex calculations with ease. Connect Microsoft 365 Excel to IFTTT to automate data entry, generate reports, and trigger actions based on spreadsheet changes. Optimize your data workflows and enhance productivity across your personal and professional tasks.
Microsoft 365 Excel is a powerful spreadsheet program used for organizing, analyzing, and visualizing data. Leverage its capabilities to manage finances, track projects, and perform complex calculations with ease. Connect Microsoft 365 Excel to IFTTT to automate data entry, generate reports, and trigger actions based on spreadsheet changes. Optimize your data workflows and enhance productivity across your personal and professional tasks.
About SwitchBot
SwitchBot is your simple switch to a smart home. Thousands of IFTTT users are enjoying our button presser that mechanically turns any rocker switch and button on and off. Now we have Hub, Thermometer and Hygrometer, Smart Fan and more. Learn more by pressing the Buy link above.
SwitchBot is your simple switch to a smart home. Thousands of IFTTT users are enjoying our button presser that mechanically turns any rocker switch and button on and off. Now we have Hub, Thermometer and Hygrometer, Smart Fan and more. Learn more by pressing the Buy link above.