Back
Google Nest Thermostat Temperature rises above. Google Sheets Add row to spreadsheet. Android SMS Send an SMS.

Log and text when temperature rises above threshold

Connect

How this automation works

Track and stay informed when your home gets warmer. This Applet logs temperature readings to Google Sheets and sends an SMS when your Nest Thermostat detects the temperature rising above a set level. It’s ideal for monitoring comfort or spotting anomalies while you’re away.

If
Google Nest Thermostat icon
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 the temperature rises above a given threshold.
MeasuredAt Temperature TempUnit Room
Then
Google Sheets icon
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.
filename formatted_row path
And
Android SMS icon
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 an SMS from your Android device to any phone number you specify.
phone_number text

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.

32 triggers, queries, and actions

Any new SMS received

Pro icon
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 you receive any new SMS on your Android device.

Any new SMS sent

Pro icon
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 you send an SMS on your Android device.

Cell updated in spreadsheet

Pro icon
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.

Humidity drops below

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 the humidity drops below a given threshold.

Humidity rises above

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 the humidity rises above a given threshold.

New row added to spreadsheet

Pro icon
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 SMS received from phone number

Pro icon
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 you receive an SMS on your Android device from a phone number you specify.

New SMS received matches search

Pro icon
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 you receive an SMS on your Android device that matches a search you specify.

New SMS sent matches search

Pro icon
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 you send an SMS on your Android device that matches a search you specify.

New SMS sent to phone number

Pro icon
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 you send an SMS on your Android device to a phone number you specify.

New spreadsheet added to folder

Pro icon
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

Pro icon
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.

Current value of a cell

Pro plus icon
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

Pro plus icon
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

Pro plus icon
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

Pro plus icon
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 when Cell was updated in spreadsheet

Pro plus icon
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 particular cell was updated within the spreadsheet you specify.

History of worksheets in spreadsheet

Pro plus icon
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 worksheet is added to a spreadsheet you specify.

Add row to spreadsheet

Pro icon
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.

Send an SMS

Pro icon
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 an SMS from your Android device to any phone number you specify.

Set COOL temperature

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 desired temperature in the COOL mode.

Set HOT temperature

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 desired temperature in the HOT mode.

Set temperature range

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 desired temperature HEAT & COOL mode range.

Turn off Eco Mode

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 turn off your thermostat's Eco Mode. When the Eco mode is turned off, the thermostat mode will default to the last standard mode (HEAT, COOL, HEATCOOL, or OFF) that was active.

Turn off fan

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 turn off your thermostat's fan.

Turn on Eco Mode

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 turn on your thermostat with Eco Mode.

Turn on fan

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 turn on your thermostat's fan for X minutes.

Turn thermostat 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 will turn off your thermostat.

Turn thermostat 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 will turn on your thermostat.

Update cell in spreadsheet

Pro icon
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

Pro icon
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.

Any new SMS received

Pro icon
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 you receive any new SMS on your Android device.

Any new SMS sent

Pro icon
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 you send an SMS on your Android device.

Cell updated in spreadsheet

Pro icon
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.

Current value of a cell

Pro plus icon
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

Pro plus icon
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

Pro plus icon
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

Pro plus icon
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 when Cell was updated in spreadsheet

Pro plus icon
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 particular cell was updated within the spreadsheet you specify.

History of worksheets in spreadsheet

Pro plus icon
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 worksheet is added to a spreadsheet you specify.

Humidity drops below

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 the humidity drops below a given threshold.

Humidity rises above

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 the humidity rises above a given threshold.

Build an automation in seconds!

You can add delays, queries, and more actions in the next step!

More on these services

About Google Nest Thermostat

Nest thermostats keep you cozy, help save energy, and fit into your home. Learn more here

Explore Google Nest Thermostat

More integrations with Google Nest Thermostat

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.

Explore Google Sheets

More integrations with Google Sheets

About Android SMS

Android SMS is a native service that allows you to receive Short Message Service (SMS) messages on your device and send messages to other phone numbers. Standard carrier rates may apply. This service requires the IFTTT app for Android.

Explore Android SMS

More integrations with Android SMS

IFTTT helps all your apps and devices work better together

Get started for free