Get the weather forecast every day at 7:00 AM
How this automation works
Track tomorrow’s weather automatically by logging it in your Microsoft 365 Excel workbook. This Applet runs when Weather Underground reports that tomorrow’s forecast will be clear and updates a specified cell in your chosen worksheet. Perfect for keeping historical weather records, managing outdoor plans, or feeding weather data into your reporting sheets.
If
Trigger ingredients
ForecastUrl
TomorrowsCondition
ConditionImageURL
HighTempFahrenheit
HighTempCelsius
LowTempFahrenheit
LowTempCelsius
TomorrowsDate
Then
Action fields
path
filename
worksheet_name
cell
value
Services used in this Applet
You might also like...
View more Applets
Related services
Create your own Weather Underground and Microsoft 365 Excel 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.
33 triggers, queries, and actions
Cell updated in workbook
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 condition changes to
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 monitors changes in the current weather condition. When one of those conditions is met the Trigger fires. Currently only these simple conditions are supported: Rain, Snow, Cloudy, Clear.
Current humidity level 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 monitors your local humidity and fires every time the humidity rises above the value you specify.
Current pollen count 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 monitors your local pollen levels and fires every time the pollen count rises above the value you specify (1-12). NOTE: Available only in the USA.
Current temperature 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 monitors your local temperature and fires whenever the temperature drops below the value you provide.
Current 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 monitors your local temperature and fires whenever the temperature rises above the value you provide.
Current UV index 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 monitors your local UV levels and fires every time the UV index rises above the value you specify (0-16).
New row added to workbook
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.
Sunrise
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 within 15 minutes of the sunrise in your location.
Sunset
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 within 15 minutes of the sunset in your location.
Today's weather report
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 retrieves today's current weather report within 5 minutes of the time you specify. NOTE: Pollen count available only in the USA.
Tomorrow's forecast calls for
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 monitors changes in tomorrow’s forecasted weather condition.
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 workbook.
Current weather
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.
Get the current weather
History of humidity level rose above 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 monitors your local humidity and returns a list of times when the humidity rose above the value you specified. Note: this query will only return future events after this Applet is created.
History of pollen count rose above 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 monitors your local pollen levels and returns a list of times when the pollen count rose above the value you specified (1-12). NOTE: Available only in the USA. Note: this query will only return future events after this Applet is created.
History of specified forecast conditions
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 times when the forecasted weather changed to meet a specific condition (Rain, Snow, Cloudy, or Clear).
History of specified weather conditions
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 times when the observed weather changed to meet a specific condition (Rain, Snow, Cloudy, or Clear).
History of Sunrises
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 history of sunrises in your location. Note: this query will only return future events after this Applet is created.
History of Sunsets
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 history of sunsets at your location.
History of temperatre rose above 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 monitors your local temperature and returns a list of times when the temperature rose above the value you provided. Note: this query will only return future events after this Applet is created.
History of temperature dropped below 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 monitors your local temperature and returns a list of times when the temperature dropped below the value you provide. Note: this query will only return future events after this Applet is created.
History of Tomorrow's Forecast drops below 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 alerts when tomorrows forecasted low temperature dropped below a value you provided. Note: this query will only return future events after this Applet is created.
History of Tomorrow's Forecast was above threshold 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 times when tomorrows forecasted high temperature rose above a value you provided. Note: this query will only return future events after this Applet is created.
Add row to workbook
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.
Update cell in workbook
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
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.
Cell updated in workbook
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 condition changes to
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 monitors changes in the current weather condition. When one of those conditions is met the Trigger fires. Currently only these simple conditions are supported: Rain, Snow, Cloudy, Clear.
Current humidity level 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 monitors your local humidity and fires every time the humidity rises above the value you specify.
Current pollen count 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 monitors your local pollen levels and fires every time the pollen count rises above the value you specify (1-12). NOTE: Available only in the USA.
Current temperature 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 monitors your local temperature and fires whenever the temperature drops below the value you provide.
Current 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 monitors your local temperature and fires whenever the temperature rises above the value you provide.
Current UV index 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 monitors your local UV levels and fires every time the UV index rises above the value you specify (0-16).
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 workbook.
Current weather
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.
Get the current weather
History of humidity level rose above 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 monitors your local humidity and returns a list of times when the humidity rose above the value you specified. Note: this query will only return future events after this Applet is created.
History of pollen count rose above 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 monitors your local pollen levels and returns a list of times when the pollen count rose above the value you specified (1-12). NOTE: Available only in the USA. 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
Then
Select an action the automation will perform
You can add delays, queries, and more actions in the next step!
More on Weather Underground and Microsoft 365 Excel
About Weather Underground
Connect the services and devices you love to hyperlocal weather data, powered by the world's largest Personal Weather Station Network.
Connect the services and devices you love to hyperlocal weather data, powered by the world's largest Personal Weather Station Network.
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.
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.