Connect Google Sheets to Wireless Tag and unlock powerful automations

This Trigger fires when specified motion sensor tag(s) armed in motion detection mode, have moved.

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.

This Trigger fires when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window is open.

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

This Trigger fires when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window is closed.

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

This Trigger fires when specified PIR KumoSensor detects movement.

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

This Trigger fires when specified PIR KumoSensor or regular motion sensor tag detects no movement for a time-out period.

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.

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.

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.

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.

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.

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.

This Trigger fires when specified water sensor tag detects water with its resistive sensor, or when you short circuit its tip.

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.

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.

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.

This Trigger fires when the server detects that specified tag manager lost Internet connection due to power outage or Internet connection problems.

This Trigger fires when specified tag manager is back online.

This Trigger fires every time a specific KumoApp produces a log message with KumoApp.Log call with a specific type.

This Trigger fires every time a temperature/humidity/lux update is received from specified sensor/tag(s).

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.

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.

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.

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)

This query returns the current values in a given row. Values from columns A-Z are available as ingredients.

The query returns if the specified tag manager is online or offline, as well as how many hours it has been online.

This query returns the current value of a single cell in your spreadsheet.

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

This query returns a list of when a new row is added to a spreadsheet you specify.

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.

This query returns a list of when a particular cell was updated within the spreadsheet you specify.

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.

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.

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

This query returns a list of when a new worksheet is added to a spreadsheet you specify.

This query returns a list of when a specified tag with humidity or moisture monitoring enabled, detects "too wet" state.

This query returns a list of when the specified tag manager was back online.

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.

This query returns a list of when specified motion sensor tag(s) armed in motion detection mode, have moved.

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.

This query returns a list of when specified PIR KumoSensor or regular motion sensor tag detects no movement for a time-out period.

This query returns a list of when a temperature/humidity/lux update was received from specified sensor/tag(s).

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.

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.

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.

This query returns a list of every time a specific KumoApp produces a log message with KumoApp.Log call with a specific type.

This Action will beep the tag. NOTE: Only compatible with the Motion Sensor Tags with buzzer.

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.

This Action will stop the tag beeping. This action can also be used to test tag connectivity.

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.

This Action will turn on LED on the tag or a WeMo device.

This Action will turn off LED on the tag or a WeMo device.

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.

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.

This Action will enable temperature monitoring on a tag.

This Action will disable temperature monitoring on a tag.

This Action will enable humidity or moisture monitoring on a tag. NOTE: Only compatible with Tags with humidity or moisture sensor.

This Action will disable humidity or moisture monitoring on a tag.

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.

This Action will stop a KumoApp. If the KumoApp is not running, nothing will happen.

This Action will enable brightness/ambient light intensity monitoring on a tag. NOTE: Only compatible with Tags with ambient light sensor.

This Action will disable brightness/ambient light intensity monitoring on a tag.

This action will force an update to read the current temperature, humidity and ambient light (when available).