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.
- Finish entering the data, then get a follow-up from the product team asking if you can also add a PM2.5 column, 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 Google Sheet 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.
For each city in my Market Research sheet (columns A-C), fetch the current AQI, humidity, and temperature from IQAir and write the values into columns F, G, H next to the existing population data.
What You Get
- Column F: current US AQI for each target city.
- Column G: relative humidity at the monitoring station for each city.
- Column H: current temperature in the unit returned by IQAir.
- Cities where IQAir returns partial data come back with a status note in column I 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 sheet uses metro area names like Greater Boston and Silicon Valley. Resolve each to the nearest IQAir-recognized city, then fetch AQI, humidity, and temperature and write the values into columns F, G, H.
The product team also wants PM2.5 alongside the three existing fields
For each city in my Market Research sheet, fetch the current US AQI, PM2.5 concentration, humidity, and temperature from IQAir, and write the values into columns F, G, H, I respectively.
You need to join the environmental data with a second tab of regional market tiers
Fetch AQI, humidity, and temperature from IQAir for each city in my Market Research sheet and write into columns F, G, H. Then join against my Market Tiers tab using city name as the key and add the tier label from column B of that tab into column I of the Market Research sheet.
Pull all metrics, compute a composite environmental score, and rank the cities in one step
For each city in my Market Research sheet, fetch US AQI, PM2.5, humidity, and temperature from IQAir, write the raw values into columns F through I, compute a composite environmental demand score in column J as (AQI divided by 50) plus (humidity divided by 100) rounded to two decimals, and sort the sheet by column J 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 sheet with your city list, then ask it to populate the AQI, humidity, and temperature 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 Google Sheets.