Add new iOS Contacts to Google Sheets automatically
How this automation works
Capture event data automatically when your Webhook fires and record it in Google Sheets while resuming your Ecobee thermostat program. It runs whenever a Webhook event with your chosen event name is received and logs key details into a sheet. Ideal for monitoring environmental triggers or smart home automations that integrate data logging and comfort control. Note: This requires a reachable webhook endpoint (URL).
If
Trigger ingredients
EventName
Value1
Value2
Value3
OccurredAt
Then
Action fields
filename
formatted_row
path
And
Action fields
thermostat
Services used in this Applet
You might also like...
-
272K
-
-
Track time at locations with Google Sheets
157K
-
-
Log work hours in Google Sheets with a Button Widget
124K
-
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.
48 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.
Receive a web request
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires every time the Maker service receives a web request to notify it of an event. For information on triggering events, go to your Maker service settings and then the listed URL (web) or tap your username (mobile)
Receive a web request with a JSON payload
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires every time the Maker service receives a web request to notify it of an event. For information on triggering events, go to your Maker service settings and then the listed URL (web) or tap your username (mobile)
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.
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.
Make a web request
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 make a web request to a publicly accessible URL. NOTE: Requests may be rate limited.
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.
Turn light switch on
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 on one of your light switches.
Update cell in 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 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.
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 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 Webhooks
Learn to use webhooks and integrate other services on IFTTT with your DIY projects. You can create Applets that work with any device or app that can make or receive a web request. If you'd like to build your own service and Applets, check out the IFTTT Developer Dashboard. Connect a webhook to any of the 750+ apps and services on IFTTT.
Learn to use webhooks and integrate other services on IFTTT with your DIY projects. You can create Applets that work with any device or app that can make or receive a web request. If you'd like to build your own service and Applets, check out the IFTTT Developer Dashboard. Connect a webhook to any of the 750+ apps and services on IFTTT.
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.