The Scenario
You are three months into evaluating 35 target cities for the air purifier line launch. The market scoring model has population, household income, and retail density by city. The product team added a new requirement last week: AQI, humidity, and temperature for each city need to be in the model before the launch strategy goes to leadership.
Nobody budgeted time for this. The model presentation is in four days.
The bad version:
- Open IQAir for each of the 35 cities, read the AQI, humidity, and temperature off the current conditions card, and manually enter three data points per city into the existing model columns.
- Halfway through, realize the AQI values are in different index scales for some non-US cities and you are not sure if you should be using US EPA or local AQI for the cross-country comparison.
- Get a follow-up from the product team asking for PM2.5 too, which means going back through all 35 cities again.
The model is supposed to drive a launch decision. Doing the environmental data layer by hand across 35 cities, twice, is not a sound process for a decision with that much attached to it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your city columns and pulls AQI, humidity, and temperature from IQAir AirVisual, landing all three in the columns you specify without requiring you to touch the interface for each city.
I have a list of 35 cities in my Excel sheet. Pull the current US AQI, temperature, and humidity for each from AirVisual and paste the results into columns D, E, F.
What You Get
- Column D: current US AQI for each target city.
- Column E: current temperature in the unit returned by IQAir.
- Column F: relative humidity at the monitoring station for each city.
- Cities where IQAir returns partial data come back with a status note in column G rather than a silent blank that would make the scoring formula throw an error.
What If the Data Is Not Quite Ready
Some cities are listed as metro areas that IQAir does not recognize directly
Column A in my Market Research workbook uses metro area names like Greater Boston and Silicon Valley. Resolve each to the nearest IQAir-recognized city, then fetch US AQI, temperature, and humidity and write the values into columns D, E, F.
The product team also wants PM2.5 alongside the three existing fields
For each city in my Market Research workbook, fetch the current US AQI, PM2.5 concentration, temperature, and humidity from IQAir, and write the values into columns D, E, F, G respectively.
You need to join the environmental data with a second worksheet of regional market tiers
Fetch AQI, temperature, and humidity from IQAir for each city in my Market Research workbook and write into columns D, E, F. Then join against my Market Tiers worksheet using city name as the key and add the tier label from column B of that worksheet into column G.
Pull all metrics, compute a composite environmental score, and rank the cities in one step
For each city in my Market Research workbook, fetch US AQI, PM2.5, humidity, and temperature from IQAir, write the raw values into columns D through G, compute a composite environmental demand score in column H as AQI divided by 50 plus humidity divided by 100 rounded to two decimals, and sort the workbook by column H descending so the highest-opportunity cities appear first.
The scoring and the sort in one instruction alongside the data pull.
Try It
Get the 7-day free trial of SheetXAI and open the market research workbook with your city list, then ask it to populate the AQI, temperature, and humidity columns and compute the environmental demand score. For related workflows, see the spoke on bulk-fetching air quality readings for a city list, or the hub overview on connecting IQAir AirVisual to Excel.