Formulas you can paste in right now
A gallery of real =VERVE() recipes grouped by category — money, weather and places, web and language. Each card shows the exact formula and what it returns. Copy one into Google Sheets or Excel and watch the cell fill. For how the function itself works, see the formula reference.
- Copy & paste
- 300+ sources
- Sheets & Excel
- Weather"Paris"
- CurrencyUSD→EUR
- Goldper oz
- TimezoneA2:A9
Prices and rates, live
Exchange rates, metals and indices — into a cell that refreshes on your schedule.
Convert two currencies
The live exchange rate from US dollars to euros.
- =VERVE("currency","USD","EUR")
Live gold price
Current gold price per ounce — no arguments needed.
- =VERVE("goldprice")
Stock index level
The latest level for a market index, into a single cell.
- =VERVE("stockindex","S&P 500")
Anywhere on earth
Conditions, single fields, and whole columns of geo data from one call.
Weather for a city
Current conditions and temperature for any city.
- =VERVE("weather","Paris")
Just the temperature
A single field — the temperature in London — as one number.
- =VERVE("weather","London","temp")
Fill timezones down a column
Resolves the timezone for every row in A2:A9 in one call.
- =VERVE("timezone",A2:A9)
Enrich and clean in place
Domain lookups, translation and world time — no exports, no copy-paste.
Look up a domain's DNS
Pull DNS records for a site to validate or enrich a list.
- =VERVE("dnslookup",A2)
Translate a cell
Translate text from one language into another, in place.
- =VERVE("translator",A2,"es")
Precise world time
The current time for any place, to timestamp your data.
- =VERVE("worldtime","Tokyo")