Log Ecobee Smart Home/Away events to Google Sheets
Connect popular automations
Quickly and easily enable Applets using ecobee and Google Sheets.-
-
-
Log ecobee Smart Home/Away events to Google Sheets
-
-
Log ecobee indoor temperature above set limit to Google Sheets
-
-
Add Webhook event data to Google Sheets and resume Ecobee program
-
-
Add Webhook event data to Google Sheets and adjust Ecobee comfort profile
-
-
Log high indoor humidity readings to Google Sheets
-
-
Set Ecobee thermostat comfort profile when Google Sheets cell updates
-
-
Adjust ecobee thermostat when Google Sheets cell updates
-
-
Log when everyone leaves and set Ecobee to Away
-
Automate ecobee and Google Sheets from your AI assistant
Ask Perplexity to create ecobee applets that adjust your thermostat based on occupancy, right from your AI assistant, with IFTTT MCP.
Set up IFTTT MCP
Create your own ecobee and Google Sheets 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.
47 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 multiple rows 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 up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
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.
Add row to top of 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 insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.
Create 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 create a new blank spreadsheet in a Google Drive folder you specify. If a spreadsheet with the same name already exists, no new file is created.
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.
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 multiple rows 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 up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
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.
Add row to top of 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 insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.
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 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 create a new blank spreadsheet in a Google Drive folder you specify. If a spreadsheet with the same name already exists, no new file is created.
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.
Build an automation in seconds!
If
Select a trigger the automation will use
Cell updated in spreadsheet
Light switch is turned off
Light switch is turned on
New row added to spreadsheet
New spreadsheet added to folder
New worksheet in spreadsheet
Thermostat enters Smart Home/Away
Thermostat indoor humidity is greater than
Thermostat indoor humidity is less than
Thermostat indoor temperature is greater than
Thermostat indoor temperature is less than
Thermostat outdoor humidity is greater than
Thermostat outdoor humidity is less than
Thermostat outdoor temperature is greater than
Thermostat outdoor temperature is less than
Thermostat schedule override
Then
Select an action the automation will perform
Add multiple rows to spreadsheet
Add row to spreadsheet
Add row to top of spreadsheet
Create spreadsheet
Create vacation on thermostat
Resume thermostat program
Set thermostat comfort profile for X hours
Set thermostat comfort profile until next transition
Set thermostat hold for X hours
Set thermostat hold until next transition
Set thermostat indefinite hold
Turn light switch off
Turn light switch on
Update cell in spreadsheet
Update multiple rows in spreadsheet
Update row in spreadsheet
You can add delays, queries, and more actions in the next step!
GET STARTED
How to connect to a ecobee automation
Find an Applet using ecobee and Google Sheets
Find an automation to connect to, or create your own!Connect IFTTT to your accounts
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 ecobee and Google Sheets
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.
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.