The Scenario
You are a construction project manager. It is 7 AM and the daily site report goes to the client at 8:30 AM. You have 12 active job sites in an Excel workbook, city names in column A. Columns E through G are blank.
Your contract requires flagging any site where current conditions might delay outdoor work.
The bad version of this morning:
- You open the weather app, search for site 1's city, read the temperature and conditions, type them into the workbook
- Site 4 has the same city name as a city in a different state and the app shows the wrong location
- You redo sites 3, 4, and 5 to make sure
- 8:30 AM passes. The report is not ready. The client calls.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your site list and calls HERE Weather for each location, writing results back before the report deadline.
Open the SheetXAI sidebar and type:
For each city name in column A of my workbook, fetch the current weather observation from HERE and write temperature in Celsius to column E, current conditions to column F, and wind speed in km/h to column G.
SheetXAI reads all 12 city names, calls HERE Weather for each, and writes the three weather fields back. If a city name is ambiguous, SheetXAI uses the state or region in column B to disambiguate.
What You Get
A weather-enriched site report in three new columns:
- Column E — current temperature in Celsius for each site
- Column F — current conditions description
- Column G — wind speed in km/h
Highlight column F where conditions contain "Rain" or "Storm" and the flagged sites stand out immediately.
What If the Data Is Not Quite Ready
Weather data needs change by report type and site type. SheetXAI handles the variation in the same prompt.
When sites are identified by coordinates rather than city names
Some newer sites have lat/lng in columns B and C instead of a city name.
For rows where column A has a city name, fetch current HERE weather by city name. For rows where columns B and C have lat/lng values, fetch current HERE weather by coordinates. Write temperature, conditions, and wind speed to columns E, F, and G for all rows.
When you need a 7-day forecast instead of current conditions
The client wants the weekly outlook to plan crane lifts and concrete pours.
For each lat/lng pair in columns B and C, pull a 7-day weather forecast from HERE and write the daily high temperature to columns E through K (one per day, labeled with the date). Write the daily low to columns L through R.
When you need to flag sites that exceed a wind threshold
Crane operations must stop at winds above 40 km/h.
Fetch current HERE weather for each city in column A and write wind speed in km/h to column G. Add a flag in column H: write "Crane Hold" if column G is greater than 40, otherwise write "Clear". Sort by column G descending so the highest-wind sites appear first.
When you need current weather plus a delay-risk assessment in one pass
The client wants weather data and a risk call: "Low", "Medium", or "High" delay risk.
Fetch current HERE weather for each city in column A and write temperature to column E, conditions to column F, and wind speed to column G. Then add a delay risk assessment to column H: "High" if conditions contain Rain, Storm, or Snow, or if wind speed exceeds 40; "Medium" if temperature is below 2°C or wind speed is between 25 and 40; "Low" otherwise. Highlight all "High" rows in red.
The pattern: weather pull and risk classification in one prompt, so the client report arrives with the data and the call already made.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with site locations, then ask it to pull current weather from HERE. The HERE integration is included in every SheetXAI plan. See also how to pull live traffic incidents for delivery zones or the HERE in Excel overview.