Create a spreadsheet of new laws, eliminating the need for countless Washington, DC interns
Start today
Other popular Google Sheets workflows and automations
- When a reddit post is saved, enter a row into a Google Drive sheet with its info.
- Log WiFi connections/disconnections
- Automatically track your Fitbit weight logs in a Google spreadsheet
- Save your Fitbit sleep logs to a Google Spreadsheet
- How strong is your currency in another country? Log the exchange rate every day
- Create a new row in Google Sheets when your business is tagged in a Facebook photo
- Track #hashtag mentions in a Google Spreadsheet
- Call Log, Missed call
Useful Google Sheets and UbiBot integrations
Triggers (If this)
- Temperature Rises above or Drops belowThis 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.
- New spreadsheet added to folderThis 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.
- (Universal) Any Channel Field Value Rises above or Drops belowThis trigger monitors the UbiBot device's selected Field readings and fires whenever the reading rises above or drops below the value you provide.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Humidity Rises above or Drops belowThis 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.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Light Rises above or Drops belowThis 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.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Voltage Rises above or Drops belowThis trigger monitors the voltage of the batteries or USB power and fires whenever the voltage rises above or drops below the value you provide.
- External Power Supply is Up or DownThis 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.
- Device is offlineThis trigger fires when your UbiBot device is offline.
- Motion is Detected or Undetected from Motion SensorThis trigger monitors the status of the motion sensor and fires whenever motion is detected or undetected.
- External-DS18B20-Temperature-Probe-1 Rises above or Drops belowThis 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).
- External-DS18B20-Temperature-Probe-2 Rises above or Drops belowThis 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)
- External-TH30S-Probe-Temperature Rises above or Drops belowThis 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).
- External-TH30S-Probe-Humidity Rises above or Drops belowThis 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).
- External-Soil-Probe-Moisture Rises above or Drops belowThis 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.
- External-Soil-Probe-Temperature Rises above or Drops belowThis 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.
- External-PT100-Probe Temperature Rises above or Drops belowThis 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.
- Vibration Index Rises above or Drops belowThis trigger monitors the WS1 vibration sensor readings and fires whenever the vibration index rises above or drops below the value you provide.
- Carbon Dioxide (CO2) Rises above or Drops belowThis 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.
Queries (With)
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of vibration index rises above or drops below thresholdThis 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.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of light crossed a thresholdThis 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.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of External-Soil-Probe-Moisture Rises above or drops belowThis 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.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of Sensor Data ReceivedThis 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.
- History of spreadsheets added to folderThis 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 worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
- (Universal) Send Command to Any ChannelSend Action Command to Any Target Channel
- Add row to spreadsheetThis 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.
- (Universal) Send RAW Command to Any ChannelSend Action RAW Command to Any Target Channel
- Update cell in spreadsheetThis 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.
- Turn On or Off your UbiBot Smart PlugSend Action Command to Turn On or Off your UbiBot Smart Plug
- Turn On or Off your Network Relay SwitchSend Action Command to Turn On or Off your UbiBot Network Relay Switch
IFTTT helps all your apps and devices work better together