When a song is added to a Spotify playlist, song details appended to Google Sheet
Other popular Google Sheets workflows and automations
-
1.23K
-
-
Back up your bitlinks in a Google Drive Spreadsheet
869
-
-
Keep track of my completed tasks in a Google Spreadsheet
1.26K
-
-
Keep a log of your recently played tracks
1.33K
-
-
Log all players that killed my character
3.87K
-
-
Automatically track your Fitbit weight logs in a Google spreadsheet
8.59K
-
-
Track New Followers in Spreadsheet
2.3K
-
-
Track every time the ISS passes over your house
4.07K
-
-
Press a button to track work hours in Google Drive
123K
-
Build your own Google Sheets and UbiBot automations
Triggers (If this)
-
(Universal) Any Channel Field Value Rises above or Drops below
This trigger monitors the UbiBot device's selected Field readings and fires whenever the reading rises above or drops below the value you provide.
-
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.
-
Temperature Rises above or Drops below
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.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Humidity Rises above or Drops below
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.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Light Rises above or Drops below
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.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Voltage Rises above or Drops below
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.
-
External Power Supply is Up or Down
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.
-
Device is offline
This trigger fires when your UbiBot device is offline.
-
Motion is Detected or Undetected from Motion Sensor
This 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 below
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
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-TH30S-Probe-Temperature Rises above or Drops below
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).
-
External-TH30S-Probe-Humidity Rises above or Drops below
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-Soil-Probe-Moisture Rises above or Drops below
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
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-PT100-Probe Temperature Rises above or Drops below
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.
-
Vibration Index Rises above or Drops below
This 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 below
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.
(Universal) Any Channel Field Value Rises above or Drops below
This trigger monitors the UbiBot device's selected Field readings and fires whenever the reading rises above or drops below the value you provide.
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.
Temperature Rises above or Drops below
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.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Humidity Rises above or Drops below
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.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Light Rises above or Drops below
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.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Voltage Rises above or Drops below
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.
External Power Supply is Up or Down
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.
Device is offline
This trigger fires when your UbiBot device is offline.
Motion is Detected or Undetected from Motion Sensor
This 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 below
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
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-TH30S-Probe-Temperature Rises above or Drops below
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).
External-TH30S-Probe-Humidity Rises above or Drops below
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-Soil-Probe-Moisture Rises above or Drops below
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
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-PT100-Probe Temperature Rises above or Drops below
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.
Vibration Index Rises above or Drops below
This 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 below
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.
Queries (With)
-
Current values of a row
This 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 threshold
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.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
History of light crossed a threshold
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
This 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 below
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 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 Sensor Data Received
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
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 worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Current values of a row
This 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 threshold
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.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of light crossed a threshold
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
This 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 below
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 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 Sensor Data Received
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
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 worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
-
(Universal) Send Command to Any Channel
Send Action Command to Any Target Channel
-
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.
-
(Universal) Send RAW Command to Any Channel
Send Action RAW Command to Any Target Channel
-
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 or Off your UbiBot Smart Plug
Send Action Command to Turn On or Off your UbiBot Smart Plug
-
Turn On or Off your Network Relay Switch
Send Action Command to Turn On or Off your UbiBot Network Relay Switch
(Universal) Send Command to Any Channel
Send Action Command to Any Target Channel
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.
(Universal) Send RAW Command to Any Channel
Send Action RAW Command to Any Target Channel
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 or Off your UbiBot Smart Plug
Send Action Command to Turn On or Off your UbiBot Smart Plug
Turn On or Off your Network Relay Switch
Send Action Command to Turn On or Off your UbiBot Network Relay Switch
How to connect Google Sheets and UbiBot
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 UbiBot accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!
IFTTT helps all your apps and devices work better together