Pull current weather into your spreadsheet. =VERVE("weatherforecast", "London") returns temperature, humidity and more, 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 5 credits 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.
List your destinations down column A and fill =VERVE("weatherforecast", A2) beside them — every row shows the current condition and temperature, so a travel or events sheet always reflects what's actually happening outside.
Read the forecast into a cell and let an IF flag any outdoor booking, shoot, or delivery whose day looks risky — the sheet does the checking for you.
Set a 30-minute refresh and a facilities or logistics board stays current on its own, no one re-checking a weather site all day.
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("weatherforecast", "London")Same function, same arguments, same key — in Excel on desktop, the web, or mobile. Drag to fill a whole column.
=VERVE("weatherforecast", "London")Add a field name as the last argument to land just that value in the cell.
=VERVE("weatherforecast", "London", "tempC")=VERVE("weatherforecast", "London", "tempF")=VERVE("weatherforecast", "London", "windMph")=VERVE("weatherforecast", "London", "windKph")=VERVE("weatherforecast", "London", "windDegree")=VERVE("weatherforecast", "London", "windDir")=VERVE("weatherforecast", "London", "pressureMb")=VERVE("weatherforecast", "London", "pressureIn")Everything you need to wire it into a sheet.
