Connect Google Sheets to UbiBot and unlock powerful automations

This trigger monitors the UbiBot device's built-in temperature sensor readings and fires whenever the temperature rises above or drops below the value you provide.

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 monitors the UbiBot device's selected Field readings and fires whenever the reading rises above or drops below the value you provide.

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

This trigger monitors the UbiBot device's built-in humidity sensor readings and fires whenever the humidity rises above or drops below the value you provide.

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

This trigger monitors the UbiBot device's built-in light sensor readings and fires whenever the light level rises above or drops below the value in lux you provide.

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

This trigger monitors the voltage of the batteries or USB power and fires whenever the voltage rises above or drops below the value you provide.

This trigger monitors the status of the external power supply (USB) that connects to the device and fires whenever the power supply is up or down.

This trigger fires when your UbiBot device is offline.

This trigger monitors the status of the motion sensor and fires whenever motion is detected or undetected.

This trigger monitors the UbiBot device's external DS18B20 temperature probe 1's readings and fires whenever the temperature rises above or drops below the value you provide (Available for WS1 and WS1-PRO devices).

This trigger monitors the UbiBot device's external DS18B20 temperature probe 2's readings and fires whenever the temperature rises above or drops below the value you provide. (Available for WS1-PRO devices)

This trigger monitors the UbiBot device's external TH30S probe Temperature readings and fires whenever the Temperature rises above or drops below the value you provide (Available for WS1-PRO and GS1 devices).

This trigger monitors the UbiBot device's external TH30S probe Humidity readings and fires whenever the Humidity rises above or drops below the value you provide (Available for WS1-PRO and GS1 devices).

This trigger monitors the UbiBot device's external Soil Probe Moisture readings and fires whenever the moisture level rises above or drops below the value you provide.

This trigger monitors the UbiBot device's external Soil Probe Moisture readings and fires whenever the temperature level rises above or drops below the value you provide.

This trigger monitors the UbiBot device's external PT100 probe Temperature readings and fires whenever the Temperature rises above or drops below the value you provide.

This trigger monitors the WS1 vibration sensor readings and fires whenever the vibration index rises above or drops below the value you provide.

This trigger monitors the UbiBot device's connected Carbon Dioxide (CO2) probe readings and fires whenever the result rises above or drops below the value you provide.

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

This query monitors the WS1 vibration sensor readings and returns a list of whenever the vibration index rises above or drops below the value you provide. Note: this query will only return future events after this Applet is created.

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

This query monitors the UbiBot device's built-in light sensor readings and returns a list of whenever the light level rose above or dropped below the value in lux you provide. Note: this query will only return future events after this Applet is created.

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 UbiBot device's external Soil Probe Moisture level rises above or drops below the value you provide. Note: this query will only return future events after this Applet is created.

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

This query returns a list of when your UbiBot receives new sensor data. The raw data can be exported to other services, such as Google Spreadsheet.

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 when a new worksheet is added to a spreadsheet you specify.

Send Action Command to Any Target Channel

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.

Send Action RAW Command to Any Target Channel

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.

Send Action Command to Turn On or Off your UbiBot Smart Plug

Send Action Command to Turn On or Off your UbiBot Network Relay Switch