Connect Google Sheets to TrickleStar Connected Products and unlock powerful automations

This trigger fires when TrickleStar Thermostat system mode or setpoint changes.

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 TrickleStar Thermostat occupancy changes.

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

This trigger fires every time your TrickleStar thermostat senses that the room temperature rises above the value you specified.

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

This trigger fires every time your TrickleStar thermostat senses that the room temperature drops below the value you specified.

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

This trigger fires when TrickleStar Water Heater Controller detects a leak.

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

This query returns a list of all my TrickleStar devices and their online status.

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

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

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 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.

This action turns on your TrickleStar Connected Product.

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 turns off your TrickleStar Connected Product.

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 set temporary hold on your TrickleStar thermostat using the specified system mode and setpoint. The temporary hold will last until the next schedule event.

This action will resume schedule on your TrickleStar thermostat.

This action sets the HVAC fan on on your TrickleStar Thermostat.

This action sets the HVAC fan to Auto on your TrickleStar Thermostat. The Auto fan state means the fan will turn on when the HVAC system is on, and the fan will turn off when the HVAC system is off.

This action turns on the HVAC fan for one run cycle, with a configurable fan run duration.

This action will schedule a vacation event on all devices of the selected site. It can be used with triggers like Google Calendar "Any event starts".