Connect ecobee to Google Sheets and unlock powerful automations

This trigger fires every time your ecobee thermostat senses that the indoor temperature is greater than a specific value you supply.

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 every time your ecobee thermostat senses that the indoor temperature is less than a specific value you supply.

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

This trigger fires every time your ecobee thermostat senses that the indoor humidity is greater than a specific value you supply.

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

This trigger fires every time your ecobee thermostat senses that the indoor humidity is less than a specific value you supply.

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

This trigger fires every time your ecobee thermostat senses that the outdoor temperature is greater than a specific value you supply.

This trigger fires every time your ecobee thermostat senses that the outdoor temperature is less than a specific value you supply.

This trigger fires every time your ecobee thermostat senses that the outdoor humidity is greater than a specific value you supply.

This trigger fires every time your ecobee thermostat senses that the outdoor humidity is less than a specific value you supply.

This trigger fires every time your ecobee thermostat and Room Sensors change to Smart Home or Smart Away comfort profiles.

This trigger fires every time your ecobee schedule is overridden with a Hold event (including vacations), a Utility Demand Response event, or a Smart Home/Away event.

This trigger fires every time your ecobee light switch is turned off.

This trigger fires every time your ecobee light switch is turned on.

This query returns the history of when your ecobee thermostat sensed a temperature less than the value you specified.

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 events when your ecobee thermostat sensed that the outdoor temperature was greater than a value you specified

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

This query returns a list of events when your ecobee thermostat sensed that the indoor humidity was less than a specified value you supplied 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 your ecobee thermostat senses that the indoor humidity was greater than a specific value you supply.

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 ecobee thermostat senses that the indoor temperature was less than a specific value you supply. Note: this query will only return future events after this Applet is created.

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 your ecobee thermostat senses that the indoor temperature was greater than a specific value you supply.

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

This query returns a list of events when your ecobee schedule was overridden with a Hold event (including vacations), a Utility Demand Response event, or a Smart Home/Away event.

This query returns a list of events when your ecobee thermostat or Room Sensors changed to Smart Home or Smart Away comfort profiles.

This query returns a list of when your ecobee thermostat senses that the outdoor humidity was greater than a specific value you supply.

This action will set the thermostat into an indefinite hold with the specified temperature.

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 will set the thermostat into a hold with the specified temperature and the end date/time will be set to the next climate transition in the program.

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 the thermostat into a hold with the specified temperature for the specified number of hours.

This Action will create a vacation event on the selected thermostat with the specified setpoint. The vacation event will begin immediately and last the number of specified days.

This Action will set the thermostat into a hold using the settings from the specified comfort profile. This comfort profile hold will remain in effect until the next next comfort profile transition in the program.

This Action will set the thermostat into a hold using the settings from the specified comfort profile. This comfort profile hold will remain in effect for the specified number of hours.

This Action removes the currently running event on the selected thermostat providing the event is not a mandatory demand response event.

This action turns off one of your light switches.

This action turns on one of your light switches.