Get the weather forecast every day at 7:00 AM
How this automation works
Automatically manage your comfort settings by syncing your ecobee thermostat with updates in your Google Sheets. This runs whenever a specific cell in your spreadsheet changes, setting your thermostat to Away mode for a set number of hours or resuming the regular schedule, and optionally sending a notification. Perfect for automating home climate control from spreadsheet data. Note: Install the IFTTT app on the device(s) where you want to receive notifications.
If
Trigger ingredients
Value
Path
SpreadsheetName
SpreadsheetUrl
UpdatedAt
Then
Action fields
thermostat
hold_hours
comfort_profile
And
Action fields
thermostat
And
Action fields
message
high_priority
Services used in this Applet
You might also like...
-
798K
-
-
Rain tomorrow? Get a mobile notification
504K
-
-
Get a notification when the International Space Station passes over your house
280K
-
Related services
Create your own 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.
45 triggers, queries, and actions
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.
Light switch is turned off
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 every time your ecobee light switch is turned off.
Light switch is turned on
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 every time your ecobee light switch is turned on.
New row added to 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 new row is added to a spreadsheet you specify.
New spreadsheet added to folder
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 new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
New worksheet 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 new worksheet is added to a spreadsheet you specify.
Thermostat enters Smart Home/Away
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 every time your ecobee thermostat and Room Sensors change to Smart Home or Smart Away comfort profiles.
Thermostat indoor humidity is greater than
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 every time your ecobee thermostat senses that the indoor humidity is greater than a specific value you supply.
Thermostat indoor humidity is less than
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 every time your ecobee thermostat senses that the indoor humidity is less than a specific value you supply.
Thermostat indoor temperature is greater than
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 every time your ecobee thermostat senses that the indoor temperature is greater than a specific value you supply.
Thermostat indoor temperature is less than
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 every time your ecobee thermostat senses that the indoor temperature is less than a specific value you supply.
Thermostat outdoor humidity is greater than
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 every time your ecobee thermostat senses that the outdoor humidity is greater than a specific value you supply.
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 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 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 thermostat indoor humidity is greater than
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 ecobee thermostat senses that the indoor humidity was greater than a specific value you supply.
History of Thermostat indoor humidity lower than 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 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.
History of thermostat indoor temperature is greater than
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 ecobee thermostat senses that the indoor temperature was greater than a specific value you supply.
History of thermostat indoor temperature is less than 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 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.
History of thermostat outdoor humidity is greater than
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 ecobee thermostat senses that the outdoor humidity was greater than a specific value you supply.
History of Thermostat outdoor temperature greater than alerts
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 events when your ecobee thermostat sensed that the outdoor temperature was greater than a value you specified
History of Thermostat overrides
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 events when your ecobee schedule was overridden with a Hold event (including vacations), a Utility Demand Response event, or a Smart Home/Away event.
History of Thermostat Smart Home/Away Profile changes
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 events when your ecobee thermostat or Room Sensors changed to Smart Home or Smart Away comfort profiles.
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.
Create vacation on thermostat
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 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.
Resume thermostat program
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 removes the currently running event on the selected thermostat providing the event is not a mandatory demand response event.
Send a notification from the IFTTT app
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 send a notification to your devices from the IFTTT app.
Send a rich notification from the IFTTT app
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 send a rich notification to your devices from the IFTTT app. Rich notifications may include a title, image, and link that opens in a browser or installed app.
Send a rich notification to the IFTTT mobile widget
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 send a rich notification to IFTTT mobile widget installed on your devices. Rich notifications may include a title, image, and link that opens in a browser or installed app.
Set thermostat comfort profile for X hours
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 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.
Set thermostat comfort profile until next transition
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 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.
Set thermostat hold for X hours
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 set the thermostat into a hold with the specified temperature for the specified number of hours.
Set thermostat hold until next transition
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 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.
Set thermostat indefinite hold
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 set the thermostat into an indefinite hold with the specified temperature.
Turn light switch off
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 turns off one of your light switches.
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.
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.
Create vacation on thermostat
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 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.
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 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 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 thermostat indoor humidity is greater than
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 ecobee thermostat senses that the indoor humidity was greater than a specific value you supply.
History of Thermostat indoor humidity lower than 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 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.
History of thermostat indoor temperature is greater than
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 ecobee thermostat senses that the indoor temperature was greater than a specific value you supply.
History of thermostat indoor temperature is less than 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 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.
History of thermostat outdoor humidity is greater than
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 ecobee thermostat senses that the outdoor humidity was greater than a specific value you supply.
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!
More on these services
About Notifications
Notifications work seamlessly on any Android or iOS device with the IFTTT app installed. Get the information you want, when you want it.
Notifications work seamlessly on any Android or iOS device with the IFTTT app installed. Get the information you want, when you want it.
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 ecobee
ecobee is the smarter wi-fi thermostat with remote sensors. For homes with more than one room.
ecobee is the smarter wi-fi thermostat with remote sensors. For homes with more than one room.