Call Log, Missed call
Other popular Google Sheets workflows and automations
-
3.86K
-
-
Keep a running Drive spreadsheet of Pocket articles
970
-
-
How strong is your currency in another country? Log the exchange rate every day
4.39K
-
-
Log People ringing door bell
1.25K
-
-
Log new items in Raindrop.io to a Google Sheet
1.1K
-
-
Record every time your phone's battery is low in a Google spreadsheet
3.04K
-
-
Rss Feed To Excel Sheet
881
-
-
Keep a simple spreadsheet of every Tweet you post
35.9K
-
-
Track every time the ISS passes over your house
4.07K
-
Build your own Google Sheets and Honeywell Home automations
Triggers (If this)
-
Camera sound detected
This trigger fires when the system detects a sound camera event.
-
New spreadsheet added to folder
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.
-
Water leak detected
This trigger fires when the system detects a water leak.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Camera motion detected
This trigger fires when the system detects a motion camera event.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Smart Home Security home mode activated
This trigger fires when the home security device enters Home mode
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Smart Home Security away mode activated
This trigger fires when the home security device enters Away mode.
-
Smart Home Security night mode activated
This trigger fires when the home security device enters Night mode.
-
Smart Home Security off mode activated
This trigger fires when the home security device enters Off mode.
-
Smart Home Security Alarm activated
This trigger fires when the home security device alarm has been activated
-
Smart Home Security Outdoor Motion Viewer activated
This trigger fires when a Honeywell Homes Outdoor Motion Viewer is activated.
Camera sound detected
This trigger fires when the system detects a sound camera event.
New spreadsheet added to folder
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.
Water leak detected
This trigger fires when the system detects a water leak.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Camera motion detected
This trigger fires when the system detects a motion camera event.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Smart Home Security home mode activated
This trigger fires when the home security device enters Home mode
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Smart Home Security away mode activated
This trigger fires when the home security device enters Away mode.
Smart Home Security night mode activated
This trigger fires when the home security device enters Night mode.
Smart Home Security off mode activated
This trigger fires when the home security device enters Off mode.
Smart Home Security Alarm activated
This trigger fires when the home security device alarm has been activated
Smart Home Security Outdoor Motion Viewer activated
This trigger fires when a Honeywell Homes Outdoor Motion Viewer is activated.
Queries (With)
-
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
-
History of Smart Home Security night mode activations
This query returns a list of when the home security device entered Night mode.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
History of Smart Home Security Outdoor Motion Viewer activations
This query returns a list of when a Honeywell Homes Outdoor Motion Viewer was activated.
-
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
-
History of Smart Home Security away mode activated
This query returns a list of when the home security device enters Away mode.
-
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
-
History of Smart Home Security home mode being activated
This query returns a list of when the home security device entered Home mode.
-
History of spreadsheets added to folder
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 Camera motion detected
This query returns a list of when the system detected a motion camera event.
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
History of Smart Home Security night mode activations
This query returns a list of when the home security device entered Night mode.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of Smart Home Security Outdoor Motion Viewer activations
This query returns a list of when a Honeywell Homes Outdoor Motion Viewer was activated.
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
History of Smart Home Security away mode activated
This query returns a list of when the home security device enters Away mode.
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of Smart Home Security home mode being activated
This query returns a list of when the home security device entered Home mode.
History of spreadsheets added to folder
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 Camera motion detected
This query returns a list of when the system detected a motion camera event.
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
-
Set temperature to a permanent hold
This Action will set your Honeywell thermostat to permanently hold the specified temperature until you change it.
-
Update cell in spreadsheet
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.
-
Set fan to on, auto or circulate
This Action will set the Honeywell thermostat fan to On where the fan is always on or Auto where the fan runs only when the heating or cooling system is on.
-
Add row to spreadsheet
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.
-
Arm my Honeywell Home Smart Home Security
This action will arm my Honeywell Home Smart Home Security in Night or Away Mode.
-
Set thermostat room priority
This action will let you select one of your sensors to prioritize, so that your T9 or T10 Smart Thermostat senses the temperature from that room.
-
Control my Z-Wave light or outlet
This action will set my Z-Wave light or outlet on or off, and control brightness (if available).
-
Change my thermostat setpoint temperature
This action will set a heat or cool setpoint temperature for my thermostat.
-
Set thermostat room priority to active rooms
This will set your T9 or T10 Smart Thermostat room priority to ‘active.’ Active Rooms lets your thermostat detect motion in the rooms that people are in, using your smart room sensors.
Set temperature to a permanent hold
This Action will set your Honeywell thermostat to permanently hold the specified temperature until you change it.
Update cell in spreadsheet
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.
Set fan to on, auto or circulate
This Action will set the Honeywell thermostat fan to On where the fan is always on or Auto where the fan runs only when the heating or cooling system is on.
Add row to spreadsheet
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.
Arm my Honeywell Home Smart Home Security
This action will arm my Honeywell Home Smart Home Security in Night or Away Mode.
Set thermostat room priority
This action will let you select one of your sensors to prioritize, so that your T9 or T10 Smart Thermostat senses the temperature from that room.
Control my Z-Wave light or outlet
This action will set my Z-Wave light or outlet on or off, and control brightness (if available).
Change my thermostat setpoint temperature
This action will set a heat or cool setpoint temperature for my thermostat.
Set thermostat room priority to active rooms
This will set your T9 or T10 Smart Thermostat room priority to ‘active.’ Active Rooms lets your thermostat detect motion in the rooms that people are in, using your smart room sensors.
How to connect Google Sheets and Honeywell Home
Find or create an Applet
Start by discovering an automation to connect or customizing your own. It's quick and easy.Connect IFTTT to your accounts
Securely connect your Google Sheets and Honeywell Home accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!
IFTTT helps all your apps and devices work better together