The Scenario
Someone on the facilities team got a message from the site inspector: they're coming on Thursday, and they want a list of all active weather sensors on the property — names, identifiers, and when each one last checked in. You're the one who manages the Ambient Weather account, which means you're the one who has to produce this.
You open the Ambient Weather dashboard. It shows you your stations, one at a time, in a UI designed for reading weather data — not for exporting an inventory.
The bad version:
- Click into the first station, write down the device name and MAC address, note the last-seen timestamp.
- Click back to the station list. Click into the second station. Write it down.
- Repeat for all eight stations. Transfer everything into a Google Sheet by hand, formatting as you go.
- Realize you're not sure if the MAC address you copied for station four is right — the dashboard shows partial addresses in the list view. Go back to verify.
The inspector's list takes forty minutes and you're still not certain it's accurate.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands what you have, and through its Ambient Weather integration it can pull device metadata for every station on your account in one call — no dashboard navigation required.
Open the SheetXAI sidebar and ask:
List all my Ambient Weather devices with their name, MAC address, last-seen date, and current outdoor temperature in this sheet
What You Get
- Column A: device name as registered in your Ambient Weather account
- Column B: the full MAC address for each station
- Column C: the last-seen date and time, so you can immediately see which devices are stale
- Column D: the current outdoor temperature reading — useful context for the inspector to confirm sensors are live
- Any station with a missing or null last-seen value gets flagged in the row rather than showing a blank
What If the Data Is Not Quite Ready
I need battery status too, not just temperature
List all my Ambient Weather devices with device name, MAC address, last-seen timestamp, outdoor temperature, and battery status (low or normal) in columns A–E on this sheet
Some stations have names that are abbreviations — I want the full site description next to them
My sheet has a tab called "Site Map" with device name in column A and full site description in column B. Pull all Ambient Weather device metadata and write device name, site description (matched from Site Map), MAC address, and last-seen timestamp into columns A–D on the "Inventory" tab
I only want stations that haven't reported in more than 24 hours
Pull all my Ambient Weather device metadata and filter to only stations where the last-seen timestamp is more than 24 hours ago. Write device name, MAC address, and last-seen time into a tab called "Offline Audit"
Full pre-inspection audit: offline devices, battery warnings, and a summary count in one shot
Pull all Ambient Weather device metadata. On the "Full Inventory" tab, write every station's name, MAC address, last-seen timestamp, outdoor temperature, and battery status. On a second tab called "Alerts," list any station that is either offline (last seen >24h ago) or has a low battery. Add a summary row at the top counting how many stations are in each alert state
That last prompt turns a four-step manual audit into a single ask.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you track your site's sensor infrastructure, then ask it to dump your full Ambient Weather device inventory into the sheet before Thursday's inspection. For pulling live sensor readings instead of metadata, see the station readings spoke or the hub overview.