Keep track of a particular stock's daily closing price in a spreadsheet
Other popular Google Sheets workflows and automations
-
2.33K
-
-
All your new reminders in one Google Drive spreadsheet
3.3K
-
-
Archive every tweet from a specific handle to a spreadsheet
2.77K
-
-
Save notifications from all of your apps to a Google spreadsheet
14.1K
-
-
When a song is added to a Spotify playlist, song details appended to Google Sheet
2.43K
-
-
Track every time the ISS passes over your house
5.09K
-
-
Save the Tweets you like on Twitter to a Google Spreadsheet
4.67K
-
-
Save your Pixel 2 Now Playing song history to a spreadsheet in Google Drive.
3.73K
-
-
Add row to Google Sheets using MESH
2.73K
-
Create your own Google Sheets and UbiBot 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.
37 triggers, queries, and actions
(Universal) Any Channel Field Value Rises above or Drops below
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 monitors the UbiBot device's selected Field readings and fires whenever the reading rises above or drops below the value you provide.
Carbon Dioxide (CO2) Rises above or Drops below
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 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.
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.
Device is offline
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 your UbiBot device is offline.
External Power Supply is Up or Down
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 monitors the status of the external power supply (USB) that connects to the device and fires whenever the power supply is up or down.
External-DS18B20-Temperature-Probe-1 Rises above or Drops below
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 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 below
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 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-PT100-Probe Temperature Rises above or Drops below
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 monitors the UbiBot device's external PT100 probe Temperature readings and fires whenever the Temperature rises above or drops below the value you provide.
External-Soil-Probe-Moisture Rises above or Drops below
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 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 below
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 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-TH30S-Probe-Humidity Rises above or Drops below
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 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-TH30S-Probe-Temperature Rises above or Drops below
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 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).
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 External-Soil-Probe-Moisture Rises above or drops below
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 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 light crossed a threshold
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 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 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 Sensor Data Received
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 your UbiBot receives new sensor data. The raw data can be exported to other services, such as Google Spreadsheet.
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 vibration index rises above or drops below threshold
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 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.
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.
(Universal) Send Command to Any Channel
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.
Send Action Command to Any Target Channel
(Universal) Send RAW Command to Any Channel
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.
Send Action RAW Command to Any Target Channel
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.
Turn On or Off your Network Relay Switch
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.
Send Action Command to Turn On or Off your UbiBot Network Relay Switch
Turn On or Off your UbiBot Smart Plug
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.
Send Action Command to Turn On or Off your UbiBot Smart 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.
(Universal) Any Channel Field Value Rises above or Drops below
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 monitors the UbiBot device's selected Field readings and fires whenever the reading rises above or drops below the value you provide.
(Universal) Send Command to Any Channel
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.
Send Action Command to Any Target Channel
(Universal) Send RAW Command to Any Channel
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.
Send Action RAW Command to Any Target Channel
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.
Carbon Dioxide (CO2) Rises above or Drops below
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 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.
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.
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.
Device is offline
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 your UbiBot device is offline.
External Power Supply is Up or Down
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 monitors the status of the external power supply (USB) that connects to the device and fires whenever the power supply is up or down.
External-DS18B20-Temperature-Probe-1 Rises above or Drops below
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 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 below
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 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)
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
More on Google Sheets and UbiBot
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 UbiBot
UbiBot offers a revolutionary way to monitor multiple environmental parameters including temperature, humidity, ambient light, vibrations and more. All the data is automatically synchronised to our big data platform via low-power WiFi or mobile network.
UbiBot offers a revolutionary way to monitor multiple environmental parameters including temperature, humidity, ambient light, vibrations and more. All the data is automatically synchronised to our big data platform via low-power WiFi or mobile network.