Back up new texts you receive on your Android device to a Google Spreadsheet
Other popular Google Sheets workflows and automations
-
36.9K
-
-
Automatically add your saved tracks in Spotify to a Google spreadsheet
21.3K
-
-
Track New Followers in Spreadsheet
4.27K
-
-
Track your daily Fitbit activity in a Google spreadsheet
28.2K
-
-
Track work hours in a Google Spreadsheet
10.6K
-
-
Save notifications from all of your apps to a Google spreadsheet
14K
-
-
Gmail to Sheets
3.36K
-
-
Record every time your phone's battery is low in a Google spreadsheet
5.99K
-
-
Save your Pixel 2 Now Playing song history to a spreadsheet in Google Drive.
3.72K
-
USE CASE
Location-based time logging
Track the time you spend in specific locations, like your office or home, by automatically logging data into a Google Sheet each time you arrive or leave.
Get startedCreate your own Google Sheets 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.
110 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 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 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet 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 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 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a spreadsheet you specify.
New spreadsheet added to folder
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 spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
New worksheet 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 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new worksheet is added to a spreadsheet 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スマート電球をオンにします。
ロック状態変更
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.
このトリガーはロックの状態が変更した時に実行する
ロボット状態変更
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.
このトリガーはロボットの状態が変更した時に実行します
動体が検出された、または検出されない
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人感センサーがサービスをトリガーします。
水漏れセンサーの状態
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.
水漏れセンサーの水漏れ/水位低下状態をトリガー条件として設定することが可能です。
温度・湿度の変化
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温湿度計（メーター）が「THAT」サービスをトリガーにします。例えば、温度が27度より高い時、SwitchBot Hub PlusでエアコンをONにします。
開閉と動体を検知する
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開閉センサーがサービスをトリガーします。
電源の変化
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.
プラグミニの状態をアクション実行条件として設定できます
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.
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 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.
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
Control Air Purifier
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 control the SwitchBot Air Purifier.
Control 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 control the SwitchBot Curtain.
Control Evaporative Humidifier
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 control the SwitchBot Evaporative Humidifier.
Control Fan
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 control the SwitchBot Smart Fan.
Control home appliances
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 ask SwitchBot Hub Plus to send an infrared signal to control any "Others" types of appliances set in the SwitchBot App.
Note: Please use other actions if your appliance type is known to the App for a better experience
Control Humidifier
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 control the SwitchBot Smart Humidifier.
Control RollerShade
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 control the SwitchBot RollerShade.
Control TV
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 ask SwitchBot Hub Plus to send an infrared signal to control TV.
Delay On/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.
You can set the Plug Mini's action
Fan 2 Blowing Mode
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 switch between 4 blowing modes.
Fan 2 Nightlight
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 nightlight status of your Air Circulator Fan.
Fan 2 常夜灯設定
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.
常夜灯の明るさを調整できます。
Fan 2 送風モード
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.
4つの送風モードを切り替えます。
fan 2 Fan Speed
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 fan speed.
Fan 2 Horizontal Oscillation
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 Horizontal Oscillation to turn on or turn off.
Fan 2 Vertical Oscillation
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 Vertical Oscillation to turn on or turn off.
Fan 2 上下の首振り
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.
上下の首振りモードを設定できます。
Fan 2 左右の首振り
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.
首振りモードを設定できます。
fan 2 風量
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.
風量を調整できます。
LED Strip Light 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 Strip Light on this page.
LED Strip Light On/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.
You can set the on/off state of your Strip Light here.
Open/close Blind Tilt
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 open/close Blind Tilt up or down and to a specific percentage.
Pause vacuuming (Pause recharging)
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 robot will pause vacuuming (pause recharging)
Power On/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.
You can set the Plug Mini's action
Scene
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.
Run the Scene you previously set in the SwitchBot App. Only manual execution types are allowed.
Start cruise whole house
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 cruise whole house
Start purity in situ
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 purity in situ
Start purity whole house
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 purity whole house
Start recharging
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 robot will start recharging
Start vacuuming
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 robot will start vacuuming
Switch Mode
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 robot will switch mode
Toggle Ceiling Light On/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.
Toggle Ceiling Light On/Off
Toggle On/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.
You can set the Plug Mini's action
Turn A/C 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 ask SwitchBot Hub Plus to turn off your paired air conditioner.
Turn A/C 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 ask SwitchBot Hub Plus to turn on or set your paired air conditioner with predefined mode, temperature and fan speed.
Turn Bulb On/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.
You can set the on/off state of your Color Bulb here.
Turn Ceiling Light On/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.
You can set your Ceiling Light to be turned on/off.
Turn off appliance with Hub Plus IR remote
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 ask SwitchBot Hub Plus to turn off your paired appliance with the IR remote feature.
Turn on appliance with Hub Plus IR remote
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 ask SwitchBot Hub Plus to turn on your paired appliance with the IR remote feature.
Turn Plug 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 turn off your Plug.
Turn Plug 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 turn on your Plug.
Update cell in 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 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.
カーテンをコントロール
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.
このアクションは、SwitchBotカーテンを制御します。
シーリングライトの明るさ
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.
シーリングライトの明るさを設定できます
シーリングライトの色温度
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.
シーリングライトの色温度を設定できます
シーリングライトをオン/オフ
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.
シーリングライトのオン/オフを設定できます
シーン
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.
SwitchBot アプリで作成したシーンを実行します。（ご注意：手動実行するシーンのみ）
テープライトのカラー
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.
本ページでテープライトのカラーを設定できます
テープライトをオン/オフにする
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.
本ページでテープライトの状態を設定できます
トグルシーリングライト（オン/オフ）
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.
トグルシーリングライト（オン/オフ）
トグル（オン/オフ）
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.
プラグミニの実行アクションを設定できます
ハウスツアーを開始する
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.
ハウスツアーを開始する
ブラインドポールの開閉を設定
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.
ブラインドポールを特定の位置まで開ける/閉めるに設定可能です。
モード切替
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.
ロボットは吸引力のモードを切り替えます
再充電する
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.
ロボットは充電に帰還します
加湿器をコントロール
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.
このアクションは、SwitchBotスマート加湿器を制御します。
原位置除染を開始する
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.
原位置除染を開始する
基地局への復帰を開始する
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.
基地局への復帰を開始する
家全体の浄化を始める
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.
家全体の浄化を始める
扇風機をコントロール
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.
このアクションはSwitchBotスマート扇風機を操作できます。
気化式加湿器をコントロール
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.
このアクションは、SwitchBotスマート気化式加湿器を制御します。
水拭きの水量を変更
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.
水拭きの水量を変更
清掃/再充電を一時停止
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.
ロボットは清掃/再充電を一時停止します
清掃する
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.
ロボットは清掃を開始します
遅延実行（オン/オフ）
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.
プラグミニの実行アクションを設定できます
電源オン/オフ
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.
プラグミニの実行アクションを設定できます
電球のカラー
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.
本ページで電球のカラーを設定できます
電球のプリセット
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.
本ページでSwitchBotアプリに保存されたプリセットを設定できます
電球の明るさ
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.
本ページで電球の明るさを設定できます
電球の色温度
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.
本ページで電球のカラーを設定できます
電球をオン/オフにする
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.
本ページで電球の状態を設定できます
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.
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.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
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
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.
Control Air Purifier
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 control the SwitchBot Air Purifier.
Control 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 control the SwitchBot Curtain.
Control Evaporative Humidifier
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 control the SwitchBot Evaporative Humidifier.
Control Fan
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 control the SwitchBot Smart Fan.
Control home appliances
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 ask SwitchBot Hub Plus to send an infrared signal to control any "Others" types of appliances set in the SwitchBot App.
Note: Please use other actions if your appliance type is known to the App for a better experience
Control Humidifier
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 control the SwitchBot Smart Humidifier.
Control RollerShade
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 control the SwitchBot RollerShade.
Control TV
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 ask SwitchBot Hub Plus to send an infrared signal to control TV.
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.
Delay On/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.
You can set the Plug Mini's action
Fan 2 Blowing Mode
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 switch between 4 blowing modes.
Fan 2 Nightlight
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 nightlight status of your Air Circulator Fan.
Fan 2 常夜灯設定
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.
常夜灯の明るさを調整できます。
Fan 2 送風モード
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.
4つの送風モードを切り替えます。
fan 2 Fan Speed
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 fan speed.
Fan 2 Horizontal Oscillation
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 Horizontal Oscillation to turn on or turn off.
Fan 2 Vertical Oscillation
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 Vertical Oscillation to turn on or turn off.
Fan 2 上下の首振り
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.
上下の首振りモードを設定できます。
Fan 2 左右の首振り
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.
首振りモードを設定できます。
fan 2 風量
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.
風量を調整できます。
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.
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.
LED Strip Light 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 Strip Light on this page.
LED Strip Light On/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.
You can set the on/off state of your Strip Light here.
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 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 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a spreadsheet you specify.
New spreadsheet added to folder
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 spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
New worksheet 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 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Open/close Blind Tilt
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 open/close Blind Tilt up or down and to a specific percentage.
Pause vacuuming (Pause recharging)
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 robot will pause vacuuming (pause recharging)
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
Power On/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.
You can set the Plug Mini's action
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
Scene
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.
Run the Scene you previously set in the SwitchBot App. Only manual execution types are allowed.
Start cruise whole house
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 cruise whole house
Start purity in situ
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 purity in situ
Start purity whole house
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 purity whole house
Start recharging
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 robot will start recharging
Start vacuuming
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 robot will start vacuuming
Switch Mode
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 robot will switch mode
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).
Toggle Ceiling Light On/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.
Toggle Ceiling Light On/Off
Toggle On/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.
You can set the Plug Mini's action
Turn A/C 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 ask SwitchBot Hub Plus to turn off your paired air conditioner.
Turn A/C 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 ask SwitchBot Hub Plus to turn on or set your paired air conditioner with predefined mode, temperature and fan speed.
Turn Bulb On/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.
You can set the on/off state of your Color Bulb here.
Turn Ceiling Light On/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.
You can set your Ceiling Light to be turned on/off.
Turn off appliance with Hub Plus IR remote
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 ask SwitchBot Hub Plus to turn off your paired appliance with the IR remote feature.
Turn on appliance with Hub Plus IR remote
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 ask SwitchBot Hub Plus to turn on your paired appliance with the IR remote feature.
Turn Plug 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 turn off your Plug.
Turn Plug 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 turn on your Plug.
Update cell in 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 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.
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.
カーテンをコントロール
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.
このアクションは、SwitchBotカーテンを制御します。
シーリングライトの明るさ
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.
シーリングライトの明るさを設定できます
シーリングライトの色温度
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.
シーリングライトの色温度を設定できます
シーリングライトをオン/オフ
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.
シーリングライトのオン/オフを設定できます
シーン
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.
SwitchBot アプリで作成したシーンを実行します。（ご注意：手動実行するシーンのみ）
テープライトのカラー
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.
本ページでテープライトのカラーを設定できます
テープライトをオン/オフにする
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.
本ページでテープライトの状態を設定できます
トグルシーリングライト（オン/オフ）
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.
トグルシーリングライト（オン/オフ）
トグル（オン/オフ）
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.
プラグミニの実行アクションを設定できます
ハウスツアーを開始する
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.
ハウスツアーを開始する
ハブ２のタッチボタンを押す
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スマート電球をオンにします。
ブラインドポールの開閉を設定
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.
ブラインドポールを特定の位置まで開ける/閉めるに設定可能です。
モード切替
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.
ロボットは吸引力のモードを切り替えます
ロック状態変更
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.
このトリガーはロックの状態が変更した時に実行する
ロボット状態変更
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.
このトリガーはロボットの状態が変更した時に実行します
再充電する
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.
ロボットは充電に帰還します
加湿器をコントロール
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.
このアクションは、SwitchBotスマート加湿器を制御します。
動体が検出された、または検出されない
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人感センサーがサービスをトリガーします。
原位置除染を開始する
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.
原位置除染を開始する
基地局への復帰を開始する
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.
基地局への復帰を開始する
家全体の浄化を始める
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.
家全体の浄化を始める
扇風機をコントロール
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.
このアクションはSwitchBotスマート扇風機を操作できます。
気化式加湿器をコントロール
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.
このアクションは、SwitchBotスマート気化式加湿器を制御します。
水拭きの水量を変更
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.
水拭きの水量を変更
水漏れセンサーの状態
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.
水漏れセンサーの水漏れ/水位低下状態をトリガー条件として設定することが可能です。
清掃/再充電を一時停止
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.
ロボットは清掃/再充電を一時停止します
清掃する
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.
ロボットは清掃を開始します
温度・湿度の変化
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温湿度計（メーター）が「THAT」サービスをトリガーにします。例えば、温度が27度より高い時、SwitchBot Hub Plusでエアコンを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.
プラグミニの実行アクションを設定できます
開閉と動体を検知する
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開閉センサーがサービスをトリガーします。
電源の変化
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.
プラグミニの状態をアクション実行条件として設定できます
電源オン/オフ
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.
プラグミニの実行アクションを設定できます
電球のカラー
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.
本ページで電球のカラーを設定できます
電球のプリセット
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.
本ページでSwitchBotアプリに保存されたプリセットを設定できます
電球の明るさ
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.
本ページで電球の明るさを設定できます
電球の色温度
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.
本ページで電球のカラーを設定できます
電球をオン/オフにする
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.
本ページで電球の状態を設定できます
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!
GET STARTED
How to connect to a Google Sheets automation
Find an automation using Google Sheets
Find an automation to connect to, or create your own!Connect IFTTT to your Google Sheets account
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!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
Top integration tips, tools, and resources
More on Discord and Instagram
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.
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.
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.