Start from a live dashboard, not a blank grid.
Every template here is built from a handful of =VERVE() calls — so it fills itself in and stays current in both Google Sheets and Excel. Copy the formulas, point them at your rows, and set a refresh cadence.
- Sheets & Excel
- Auto-refresh
- Copy & go
Numbers that used to be a morning ritual
The prices and rates people paste in by hand — pulling themselves instead.
Live portfolio tracker
Tickers down column A, live prices and day-change beside them, a total that updates itself. Built on =VERVE("stockindex", …) and refreshed on open.
- stockindex
- exchangerate
- auto-refresh
Currency P&L board
Convert a column of invoices to your home currency at live rates, and see FX drift across the month. =VERVE("currency", "USD", "EUR") in every row.
- currency
- exchangerate
Commodities watchlist
Gold, silver, and crypto in one always-current panel — the numbers people paste in by hand every morning, pulling themselves instead.
- goldprice
- silverprice
- bitcoinprice
Location, weather, and time — in place
Enrich a whole column from a range in a single call.
Multi-city weather board
A row per location, live conditions and temperature filling in from =VERVE("weather", A2). Point it at a range and the whole column fills in one call.
- weather
- range fill
Store & site locator sheet
Turn a column of addresses into coordinates, timezones, and local time — geocoding a whole list without leaving the grid.
- reversegeocode
- timezone
Global standup planner
See the current local time for every team member's city at a glance, always right — no more counting hours in your head.
- worldtime
- timezone
Enrich and clean without a script
Domain checks, lead enrichment, and text cleaning, all from the grid.
Domain & SSL monitor
A watchlist of domains with live DNS, WHOIS, and SSL status beside each — validate a list of sites or keep an eye on renewals in place.
- dnslookup
- whois
- sslchecker
Lead enrichment sheet
Drop in a column of company domains and enrich each row with details your CRM export left blank — cleaning without a script.
- whois
- dnslookup
Translation workspace
A source column and a translated column that fills itself, plus sentiment scoring for a batch of feedback. Text cleaning, one formula per cell.
- translator
- sentiment
From template to live in about two minutes
No downloads to trust — just a few formulas you paste and own.
- 01
Add the extension
Install VerveSheets from the Google Workspace Marketplace or the Excel add-in store and sign in with your key.
- 02
Copy the formulas
Each template above is just a handful of =VERVE() calls. Paste them into a fresh sheet and point them at your own rows.
- 03
Set it to refresh
Choose a cadence — every open, hourly, or every 30 minutes — and your copy keeps itself current without another thought.
Your next dashboard can update itself. Add the extension, copy a template, and never paste static data again.
Want a specific one?
Tell us the dashboard you need and we'll help you build it from the right sources.
Talk to the team