Check active severe weather warnings from a spreadsheet. Lists every warning in effect across a state, auto-refreshing — Sheets or Excel.
It's one of 250+ live sources you reach with a single =VERVE() function — served from APIVerve's production data engine, billed at 5 credits per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — the input you type, and the values you can pull from it. Click any cell to see the formula behind it.
Put your cities in a column and fill =VERVE("weatheralerts", "location.state") beside them — every row shows live conditions, so an ops or travel sheet reflects the real world, not last week.
Gate a plan on the weather: read the forecast into a cell and let an IF formula flag rows that need a backup date.
Keep Live Weather Alerts as live formulas on one board — edit a location and its row looks up again, with no re-typing.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("weatheralerts", "location.state")Same source, same arguments, same key — in Excel on desktop, the web, or mobile. Excel namespaces it as VERVE.CALL. Drag to fill a whole column.
=VERVE.CALL("weatheralerts", "location.state")Tune the result by adding name=value before the field argument — in any order. Leave one out and its default applies.
Latitude of the location to check. Send with lon
=VERVE("weatheralerts", "location.state", "lat", "38.627")Longitude of the location to check. Send with lat
=VERVE("weatheralerts", "location.state", "lon", "-90.1994")Two-letter US state or territory code (e.g., MO), or the full state name (e.g., Missouri, Puerto Rico), for every alert in effect across it. Used when lat and lon are not sent
=VERVE("weatheralerts", "location.state", "state", "TX")Add a field name right after the inputs to land just that value in the cell.
=VERVE("weatheralerts", "location")=VERVE("weatheralerts", "count")=VERVE("weatheralerts", "highestSeverity")=VERVE("weatheralerts", "alerts")=VERVE("weatheralerts", "alerts.0.id")=VERVE("weatheralerts", "alerts.0.event")=VERVE("weatheralerts", "alerts.0.headline")=VERVE("weatheralerts", "alerts.0.summary")=VERVE("weatheralerts", "alerts.0.severity")=VERVE("weatheralerts", "alerts.0.urgency")=VERVE("weatheralerts", "alerts.0.certainty")=VERVE("weatheralerts", "alerts.0.response")Everything you need to wire it into a sheet.