Track global quakes from a cell. =VERVE("earthquake") returns 24-hour counts and the largest magnitude, auto-refreshing — Sheets or Excel.
It's one of 300+ live sources you reach with a single =VERVE()function — served from APIVerve's production data engine, billed at 1 credit per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — these inputs, and the values they land in your sheet.
Put your cities in a column and fill =VERVE("earthquake") 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.
Set the sheet to refresh on a schedule and Live Earthquake Data keeps a status board current without anyone re-typing a thing.
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("earthquake")Same function, same arguments, same key — in Excel on desktop, the web, or mobile. Drag to fill a whole column.
=VERVE("earthquake")Add a field name as the last argument to land just that value in the cell.
=VERVE("earthquake", "earthquakes_LastUpdated")=VERVE("earthquake", "earthquakes_LastHour")=VERVE("earthquake", "count24h")=VERVE("earthquake", "largestMagnitude24h")=VERVE("earthquake", "avgMagnitude24h")=VERVE("earthquake", "earthquakes")Everything you need to wire it into a sheet.
