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 a Google Sheet, city names in column A. Column E through G are blank.
Your contract requires flagging any site where current conditions might delay outdoor work. Right now you check a weather app one site at a time while drinking your coffee.
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 sheet
- 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 the data is right
- 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 spreadsheet 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 sheet, fetch the current weather observation from HERE and write temperature in Celsius to column E, current conditions (e.g. "Partly Cloudy") 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. The client report pulls from these columns automatically if you have it templated.
Need a forecast instead of current conditions? Ask SheetXAI to pull the 3-day forecast and write daily highs and lows to a new set of columns.
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
Your newer sites have been entered with 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 to see 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 column 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. The site foreman needs a flagged list before 7:30 AM.
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 the result 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 based on conditions.
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 sheet 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 Google Sheets overview.