Back
Ambient Weather Parameter rises above. Microsoft 365 Excel Add row to workbook. Android SMS Send an SMS.

Send Android SMS and log data to Excel when Ambient Weather parameter rises above a threshold

Connect

How this automation works

Stay informed about important weather changes and keep automatic records in Excel. This Applet runs when a selected Ambient Weather parameter, like wind speed or temperature, rises above your defined threshold—sending you an Android SMS alert and logging the information in Microsoft 365 Excel. Ideal for weather enthusiasts or professionals tracking live outdoor conditions.

If
Ambient Weather 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 given parameter exceed a given threshold.
Date Value Parameter DeviceName
Then
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
And
Microsoft 365 Excel 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 worksheet you specify in the workbook.
path filename formatted_row worksheet_name

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.

28 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 workbook

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 workbook you specify.

Daily Rain rises above

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 when the Daily Rain measurement rises above a given threshold.

Device stops reporting

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 when your device hasn't reported for 20 minutes.

New row added to workbook

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 workbook 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.

Outdoor Temperature falls below

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 when the Outdoor Temperature falls below a given value.

Outdoor Temperature 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 outdoor temperature rises above a given value.

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 workbook.

History of Daily Rain rises above

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 the Daily Rain measurement rises above a given threshold. Note: this query will only return future events after this Applet is created.

History of Device not reporting alerts

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 events when your device stopped reporting for at least 20 minutes.

History of Outdoor Temperature drops

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 the Outdoor Temperature has fallen below the given value. Note: this query will only return future events after this Applet is created.

History of outdoor temperature rising above a temperature

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 the outdoor temperature rose above a given value. Note: this query will only return future events after this Applet is created.

History of Parameter exceeds threshold

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 events when a given parameter exceed a given threshold. Note: this query will only return future events after this Applet is created.

History of parameter falls

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 events when the parameter fell below a certain threshold. Note: this query will only return future events after this Applet is created.

History of when UV rose above a threshold

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 the UV Index rose above a given value. Note: this query will only return future events after this Applet is created.

History of Wind Speed rises above threshold

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 the wind speed rose above a given value. Note: this query will only return future events after this Applet is created.

Add row to workbook

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 worksheet you specify in the workbook.

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.

Update cell in workbook

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 workbook you specify.

Add row to workbook

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 worksheet you specify in the workbook.

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 workbook

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 workbook 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 workbook.

Daily Rain rises above

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 when the Daily Rain measurement rises above a given threshold.

Device stops reporting

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 when your device hasn't reported for 20 minutes.

History of Daily Rain rises above

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 the Daily Rain measurement rises above a given threshold. Note: this query will only return future events after this Applet is created.

History of Device not reporting alerts

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 events when your device stopped reporting for at least 20 minutes.

History of Outdoor Temperature drops

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 the Outdoor Temperature has fallen below the given value. Note: this query will only return future events after this Applet is created.

History of outdoor temperature rising above a temperature

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 the outdoor temperature rose above a given value. Note: this query will only return future events after this Applet is created.

History of Parameter exceeds threshold

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 events when a given parameter exceed a given threshold. Note: this query will only return future events after this Applet is created.

Build an automation in seconds!

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

More on these services

About Microsoft 365 Excel

Microsoft 365 Excel is a powerful spreadsheet program used for organizing, analyzing, and visualizing data. Leverage its capabilities to manage finances, track projects, and perform complex calculations with ease. Connect Microsoft 365 Excel to IFTTT to automate data entry, generate reports, and trigger actions based on spreadsheet changes. Optimize your data workflows and enhance productivity across your personal and professional tasks.

Explore Microsoft 365 Excel

More integrations with Microsoft 365 Excel

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

About Ambient Weather

Your personal weather data dashboard. Create IFTTT Applets using information from your personal AmbientWeather.net-enabled weather station to perform tasks based on temperature, wind, rainfall, and many other weather parameters.

Explore Ambient Weather

More integrations with Ambient Weather

IFTTT helps all your apps and devices work better together

Get started for free