If SensorTagged door/window is opened, log to Google Sheets
Connect popular automations
Quickly and easily enable Applets using Google Sheets and Wireless Tag.-
23
-
-
If SensorTagged door/window is closed, log to Google Sheets
11
-
-
If sensor manager back online, log to Google Sheets
7
-
-
Tag Temperature is Too Low
3
-
-
Tag Temperature is Too High
3
-
-
door closed
2
-
Build your own Google Sheets and Wireless Tag automations
Triggers (If this)
-
Tag is moved
This Trigger fires when specified motion sensor tag(s) armed in motion detection mode, have moved.
-
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.
-
Door or window is opened
This Trigger fires when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window is open.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Door or window is closed
This Trigger fires when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window is closed.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Movement is detected
This Trigger fires when specified PIR KumoSensor detects movement.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Motion sensor has timed out
This Trigger fires when specified PIR KumoSensor or regular motion sensor tag detects no movement for a time-out period.
-
Temperature is too high
This Trigger fires when a specified tag senses that its ambient temperature exceeds an upper threshold configured at temperature options screen inside the WirelessTag app.
-
Temperature is too low
This Trigger fires when a specified tag senses that its ambient temperature falls below an lower threshold configured at temperature options screen inside the WirelessTag app.
-
Temperature returns to normal
This Trigger fires when a specified tag senses that its ambient temperature returns between the upper and lower thresholds configured at temperature options screen inside the WirelessTag app.
-
Humidity or moisture is too high
This Trigger fires when a specified tag with humidity or moisture monitoring enabled, detects "too wet" state. Adjust the threshold from the humidity/moisture options screen inside the WirelessTag app.
-
Humidity or moisture is too low
This Trigger fires when a specified tag with humidity or moisture monitoring enabled, detects "too dry" state. Adjust the threshold from the humidity/moisture options screen inside the WirelessTag app.
-
Humidity or moisture returns to normal
This Trigger fires when a specified tag with humidity or moisture monitoring enabled, returns within normal humidity range. Adjust the upper/lower thresholds from the humidity/moisture options screen inside the WirelessTag app.
-
Sensor detects water
This Trigger fires when specified water sensor tag detects water with its resistive sensor, or when you short circuit its tip.
-
Sensor no longer detects water
This trigger fires when specified water sensor tag transitions from detected water state to not detected water state, or when you open circuit its tip.
-
Out of range
This Trigger fires when a specified tag goes out of range. Note that the system can only determine whether a tag is out of range, if the "auto-update" is enabled.
-
Back in range
This Trigger fires when a specified tag comes out of "out of range" state. Only tags with auto-update is enabled can come out of "out of range" state.
-
Tag Manager Offline
This Trigger fires when the server detects that specified tag manager lost Internet connection due to power outage or Internet connection problems.
-
Tag Manager Online
This Trigger fires when specified tag manager is back online.
-
New KumoApp message
This Trigger fires every time a specific KumoApp produces a log message with KumoApp.Log call with a specific type.
-
Update received
This Trigger fires every time a temperature/humidity/lux update is received from specified sensor/tag(s).
-
Too bright
This Trigger fires when a specified tag senses that its ambient light exceeds an upper threshold configured at light options screen inside the WirelessTag app. For example, this can be used to detect fridge door open.
-
Too dark
This Trigger fires when a specified tag senses that its ambient light exceeds an lower threshold configured at light options screen inside the WirelessTag app. For example, this can be used to turn on a light in a room.
-
Brightness returns to normal
This Trigger fires when a specified tag senses that its ambient light intensity returns between the upper and lower thresholds configured at light options screen inside the WirelessTag app.
Tag is moved
This Trigger fires when specified motion sensor tag(s) armed in motion detection mode, have moved.
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.
Door or window is opened
This Trigger fires when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window is open.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Door or window is closed
This Trigger fires when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window is closed.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Movement is detected
This Trigger fires when specified PIR KumoSensor detects movement.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Motion sensor has timed out
This Trigger fires when specified PIR KumoSensor or regular motion sensor tag detects no movement for a time-out period.
Temperature is too high
This Trigger fires when a specified tag senses that its ambient temperature exceeds an upper threshold configured at temperature options screen inside the WirelessTag app.
Temperature is too low
This Trigger fires when a specified tag senses that its ambient temperature falls below an lower threshold configured at temperature options screen inside the WirelessTag app.
Temperature returns to normal
This Trigger fires when a specified tag senses that its ambient temperature returns between the upper and lower thresholds configured at temperature options screen inside the WirelessTag app.
Humidity or moisture is too high
This Trigger fires when a specified tag with humidity or moisture monitoring enabled, detects "too wet" state. Adjust the threshold from the humidity/moisture options screen inside the WirelessTag app.
Humidity or moisture is too low
This Trigger fires when a specified tag with humidity or moisture monitoring enabled, detects "too dry" state. Adjust the threshold from the humidity/moisture options screen inside the WirelessTag app.
Humidity or moisture returns to normal
This Trigger fires when a specified tag with humidity or moisture monitoring enabled, returns within normal humidity range. Adjust the upper/lower thresholds from the humidity/moisture options screen inside the WirelessTag app.
Sensor detects water
This Trigger fires when specified water sensor tag detects water with its resistive sensor, or when you short circuit its tip.
Sensor no longer detects water
This trigger fires when specified water sensor tag transitions from detected water state to not detected water state, or when you open circuit its tip.
Out of range
This Trigger fires when a specified tag goes out of range. Note that the system can only determine whether a tag is out of range, if the "auto-update" is enabled.
Back in range
This Trigger fires when a specified tag comes out of "out of range" state. Only tags with auto-update is enabled can come out of "out of range" state.
Tag Manager Offline
This Trigger fires when the server detects that specified tag manager lost Internet connection due to power outage or Internet connection problems.
Tag Manager Online
This Trigger fires when specified tag manager is back online.
New KumoApp message
This Trigger fires every time a specific KumoApp produces a log message with KumoApp.Log call with a specific type.
Update received
This Trigger fires every time a temperature/humidity/lux update is received from specified sensor/tag(s).
Too bright
This Trigger fires when a specified tag senses that its ambient light exceeds an upper threshold configured at light options screen inside the WirelessTag app. For example, this can be used to detect fridge door open.
Too dark
This Trigger fires when a specified tag senses that its ambient light exceeds an lower threshold configured at light options screen inside the WirelessTag app. For example, this can be used to turn on a light in a room.
Brightness returns to normal
This Trigger fires when a specified tag senses that its ambient light intensity returns between the upper and lower thresholds configured at light options screen inside the WirelessTag app.
Queries (With)
-
History of temperature returning to normal
This query returns a list of when the specified tag sensed that its ambient temperature had returned between the upper and lower thresholds configured on the temperature options screen inside the WirelessTag app. Note: this query will only return future e
-
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 Tag Manager State
The query returns if the specified tag manager is online or offline, as well as how many hours it has been online.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
Current Tag State
This query returns specified door/window sensor/tag's current state, including temperature, humidity/lux (when available) and motion state such as door open/close, moved, or detected motion (for PIR sensor)
-
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 tag manager offline
This query returns a list of when the server detects that specified tag manager lost Internet connection due to power outage or Internet connection problems.
-
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 when temperature was too low
This query returns a list of when a specified tag sensed that its ambient temperature fell below a threshold. Note: this query will only return future events after this Applet is created.
-
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 High Temperature alerts
This query returns a list of times when a specified tag senses that its ambient temperature exceeded an upper threshold configured at temperature options screen inside the WirelessTag app. Note: this query will only return future events after this Applet
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
-
History of humidity or moisture is too high
This query returns a list of when a specified tag with humidity or moisture monitoring enabled, detects "too wet" state.
-
History of when the tag manager was online
This query returns a list of when the specified tag manager was back online.
-
History of sensor no longer detects water
This query returns a list of when specified water sensor tag transitions from detected water state to not detected water state, or when you open circuit its tip.
-
History of tag moves
This query returns a list of when specified motion sensor tag(s) armed in motion detection mode, have moved.
-
History of tag out of range
This query returns a list of when a specified tag goes out of range. Note that the system can only determine whether a tag was out of range, if the "auto-update" was enabled.
-
History of motion sensor has timed out
This query returns a list of when specified PIR KumoSensor or regular motion sensor tag detects no movement for a time-out period.
-
History of update received
This query returns a list of when a temperature/humidity/lux update was received from specified sensor/tag(s).
-
History of door or window is opened
This query returns a list of when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window was open.
-
History of too bright
This query returns a list of when a specified tag senses that its ambient light exceeds an upper threshold configured at light options screen inside the WirelessTag app. Note: this query will only return future events after this Applet is created.
-
History of door or window is closed
This query returns a list of when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window was closed.
-
History of KumoApp messages
This query returns a list of every time a specific KumoApp produces a log message with KumoApp.Log call with a specific type.
History of temperature returning to normal
This query returns a list of when the specified tag sensed that its ambient temperature had returned between the upper and lower thresholds configured on the temperature options screen inside the WirelessTag app. Note: this query will only return future e
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 Tag Manager State
The query returns if the specified tag manager is online or offline, as well as how many hours it has been online.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
Current Tag State
This query returns specified door/window sensor/tag's current state, including temperature, humidity/lux (when available) and motion state such as door open/close, moved, or detected motion (for PIR sensor)
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 tag manager offline
This query returns a list of when the server detects that specified tag manager lost Internet connection due to power outage or Internet connection problems.
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 when temperature was too low
This query returns a list of when a specified tag sensed that its ambient temperature fell below a threshold. Note: this query will only return future events after this Applet is created.
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 High Temperature alerts
This query returns a list of times when a specified tag senses that its ambient temperature exceeded an upper threshold configured at temperature options screen inside the WirelessTag app. Note: this query will only return future events after this Applet
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
History of humidity or moisture is too high
This query returns a list of when a specified tag with humidity or moisture monitoring enabled, detects "too wet" state.
History of when the tag manager was online
This query returns a list of when the specified tag manager was back online.
History of sensor no longer detects water
This query returns a list of when specified water sensor tag transitions from detected water state to not detected water state, or when you open circuit its tip.
History of tag moves
This query returns a list of when specified motion sensor tag(s) armed in motion detection mode, have moved.
History of tag out of range
This query returns a list of when a specified tag goes out of range. Note that the system can only determine whether a tag was out of range, if the "auto-update" was enabled.
History of motion sensor has timed out
This query returns a list of when specified PIR KumoSensor or regular motion sensor tag detects no movement for a time-out period.
History of update received
This query returns a list of when a temperature/humidity/lux update was received from specified sensor/tag(s).
History of door or window is opened
This query returns a list of when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window was open.
History of too bright
This query returns a list of when a specified tag senses that its ambient light exceeds an upper threshold configured at light options screen inside the WirelessTag app. Note: this query will only return future events after this Applet is created.
History of door or window is closed
This query returns a list of when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window was closed.
History of KumoApp messages
This query returns a list of every time a specific KumoApp produces a log message with KumoApp.Log call with a specific type.
Actions (Then that)
-
Beep a tag
This Action will beep the tag. NOTE: Only compatible with the Motion Sensor Tags with buzzer.
-
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.
-
Stop beeping a tag
This Action will stop the tag beeping. This action can also be used to test tag connectivity.
-
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.
-
Turn on light or switch
This Action will turn on LED on the tag or a WeMo device.
-
Turn off light or switch
This Action will turn off LED on the tag or a WeMo device.
-
Arm motion sensor
This Action arms motion sensor on a tag. Regular angle based motion sensor, Reed KumoSensor and PIR KumoSensor can all be armed using this action.
-
Disarm motion sensor
This Action disarms motion sensor on a tag. Regular angle based motion sensor, Reed KumoSensor and PIR KumoSensor can all be disarmed using this action.
-
Enable temperature monitoring
This Action will enable temperature monitoring on a tag.
-
Disable temperature monitoring
This Action will disable temperature monitoring on a tag.
-
Enable humidity or moisture monitoring
This Action will enable humidity or moisture monitoring on a tag. NOTE: Only compatible with Tags with humidity or moisture sensor.
-
Disable humidity or moisture monitoring
This Action will disable humidity or moisture monitoring on a tag.
-
Run a KumoApp
This Action will start a KumoApp installed under the current user account. If the KumoApp is running, nothing will happen. If a KumoApp does not register any event handler or timer, it will automatically stop after executing the first time, allowing this action to run multiple times without user intervention.
-
Stop a KumoApp
This Action will stop a KumoApp. If the KumoApp is not running, nothing will happen.
-
Enable brightness monitoring
This Action will enable brightness/ambient light intensity monitoring on a tag. NOTE: Only compatible with Tags with ambient light sensor.
-
Disable brightness monitoring
This Action will disable brightness/ambient light intensity monitoring on a tag.
-
Update Temperature/Humidity/Lux
This action will force an update to read the current temperature, humidity and ambient light (when available).
Beep a tag
This Action will beep the tag. NOTE: Only compatible with the Motion Sensor Tags with buzzer.
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.
Stop beeping a tag
This Action will stop the tag beeping. This action can also be used to test tag connectivity.
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.
Turn on light or switch
This Action will turn on LED on the tag or a WeMo device.
Turn off light or switch
This Action will turn off LED on the tag or a WeMo device.
Arm motion sensor
This Action arms motion sensor on a tag. Regular angle based motion sensor, Reed KumoSensor and PIR KumoSensor can all be armed using this action.
Disarm motion sensor
This Action disarms motion sensor on a tag. Regular angle based motion sensor, Reed KumoSensor and PIR KumoSensor can all be disarmed using this action.
Enable temperature monitoring
This Action will enable temperature monitoring on a tag.
Disable temperature monitoring
This Action will disable temperature monitoring on a tag.
Enable humidity or moisture monitoring
This Action will enable humidity or moisture monitoring on a tag. NOTE: Only compatible with Tags with humidity or moisture sensor.
Disable humidity or moisture monitoring
This Action will disable humidity or moisture monitoring on a tag.
Run a KumoApp
This Action will start a KumoApp installed under the current user account. If the KumoApp is running, nothing will happen. If a KumoApp does not register any event handler or timer, it will automatically stop after executing the first time, allowing this action to run multiple times without user intervention.
Stop a KumoApp
This Action will stop a KumoApp. If the KumoApp is not running, nothing will happen.
Enable brightness monitoring
This Action will enable brightness/ambient light intensity monitoring on a tag. NOTE: Only compatible with Tags with ambient light sensor.
Disable brightness monitoring
This Action will disable brightness/ambient light intensity monitoring on a tag.
Update Temperature/Humidity/Lux
This action will force an update to read the current temperature, humidity and ambient light (when available).
How to connect Google Sheets and Wireless Tag
Find or create an Applet
Start by discovering an automation to connect or customizing your own. It's quick and easy.Connect IFTTT to your accounts
Securely connect your Google Sheets and Wireless Tag accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!Upgrade your automations with
-
Connect to more Applets
Connect up to 20 automations with Pro, and unlimited automations with Pro+ -
Add multiple actions with exclusive services
Add real-time data and multiple actions for smarter automations -
Get access to faster speeds
Get faster updates and more actions with higher rate limits and quicker checks
More on Discord and Instagram
About 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 Wireless Tag
Wireless Sensor Tag monitors and records motion events, temperature, humidity, ambient light, water leaks and can be used to find keys through beeps.
Wireless Sensor Tag monitors and records motion events, temperature, humidity, ambient light, water leaks and can be used to find keys through beeps.