Quick Start Guide

Get up and running with VerveSheets in minutes. Install the add-on, sign in with your Verve key, and pull your first live value into a cell with =VERVE().

VerveSheets brings 300+ live sources into your spreadsheet through a single function. Type =VERVE("weatherforecast","Paris") in any cell and the value appears — weather, currency, stock prices, and more — refreshed automatically on a schedule.

There's nothing to install beyond the add-on and no code to write. Learn the formula once and every source works the same way.

1. Add the extension

Install VerveSheets from the Google Workspace Marketplace (Google Sheets) or the Excel add-in store (Excel), then open it from your spreadsheet's Extensions / Add-ins menu. There's nothing else to install — no code, no endpoints.

2. Sign in with your Verve key

Open the VerveSheets sidebar and paste your Verve key once. The same key powers every cell, in every sheet, across Google Sheets and Excel.

3. Write your first formula

In any cell, call a source by name with =VERVE(). The first argument is the source; the rest are its inputs:

Any cell
=VERVE("weatherforecast","Paris")                       → spills the full forecast
=VERVE("weatherforecast","Paris","field","tempC")       → 13.3
=VERVE("currencyconverter",100,"USD","EUR")             → 92.3
=VERVE("goldprice","field","ounce")                     → 4312
Live, and composable

Cells refresh automatically on a schedule (on open, hourly, or every 30 minutes), and =VERVE() nests inside normal formulas — e.g. =IF(VERVE("weatherforecast","London","field","tempC")>20,"Warm","Cool"). Learn the function once and all 300+ sources work the same way.

What's Next?

Continue your journey with these recommended resources

Was this page helpful?