Gas Prices in Google Sheets & Excel

What this pulls

Track fuel prices from a cell. Returns weekly petrol, diesel and LPG prices, auto-refreshing in Sheets or Excel.

It's one of 250+ live sources you reach with a single =VERVE() function — served from APIVerve's production data engine, billed at 2 credits per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.

See it in a cell

A real example — the input you type, and the values you can pull from it. Click any cell to see the formula behind it.

gasprices.xlsxsample data

A2fx=VERVE("gasprices", "field", "country")

Country

Country Name

Area

Area Name

Area Type

United States

national

click any cell to see its formula2 credits / cell

Ways to use it

Live financial model

Drop =VERVE("gasprices", "field", "country") into a cell and your model reads the latest number every refresh — no more pasting figures from a browser tab into a stale sheet.

Track a whole watchlist

Fill a column beside your list of tickers or currencies and every row updates together, so a hundred-row watchlist stays current on its own.

Dashboards that don't rot

Point a chart at the cell =VERVE("gasprices", "field", "country") feeds and the chart re-draws as the data moves — a finance dashboard that's live instead of a Monday-morning snapshot.

Use it in your sheet

The same function works in both apps — install once, sign in with your key, and type it into any cell.

Google SheetsAdd-on

Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.

=VERVE("gasprices", "field", "country")

Microsoft ExcelAdd-in

Same source, same arguments, same key — in Excel on desktop, the web, or mobile. Excel namespaces it as VERVE.CALL. Drag to fill a whole column.

=VERVE.CALL("gasprices", "field", "country")

Optional inputs

Tune the result by adding name=value before the field argument — in any order. Leave one out and its default applies.

country
Country to get prices for: US, GB, EU (the EU average) or any EU member code such as DE, FR or PL. Defaults to US. Countries other than US require a paid plan.
=VERVE("gasprices", "country", "US")
area
US only: a state code (CA, CO, FL, MA, MN, NY, OH, TX, WA), a region (eastcoast, midwest, gulfcoast, rockymountain, westcoast and the PADD 1 sub-regions) or a city (losangeles, chicago, houston, newyorkcity and more). Omit for the national average. Requires a paid plan.
=VERVE("gasprices", "area", "CA")
currencyPremium
Currency to return prices in, as an ISO code (e.g. USD, EUR, GBP). Defaults to the country's own currency.
=VERVE("gasprices", "currency", "USD")
unit
Volume unit to price per: liter or gallon. Defaults to the source's unit (gallon for the US, liter elsewhere).
=VERVE("gasprices", "unit", "liter")
datePremium
Date to look up (YYYY-MM-DD). Returns the survey week in effect on that date. Omit for the latest week.
=VERVE("gasprices", "date", "2024-06-15")

Fields you can pull

Add a field name as the last argument to land just that value in the cell.

Country Name
=VERVE("gasprices", "field", "countryName")
Area Name
=VERVE("gasprices", "field", "areaName")
Area Type
=VERVE("gasprices", "field", "areaType")
Week
=VERVE("gasprices", "field", "week")
Native Currency
=VERVE("gasprices", "field", "nativeCurrency")
Native Unit
=VERVE("gasprices", "field", "nativeUnit")
Exchange Rate
=VERVE("gasprices", "field", "exchangeRate")
Prices
=VERVE("gasprices", "field", "prices")
Prices › Regular
=VERVE("gasprices", "field", "prices.regular")
Prices › MidgradePremium
=VERVE("gasprices", "field", "prices.midgrade")
Prices › PremiumPremium
=VERVE("gasprices", "field", "prices.premium")
Prices › DieselPremium
=VERVE("gasprices", "field", "prices.diesel")

Premium marks data included on paid plans. On the Free plan a marked field is withheld and a marked input is ignored — either way the cell reads #PREMIUM(name) instead of a value, so a gated answer can never be mistaken for a real one. Everything unmarked works on every plan. Compare plans

Gas Prices, answered

Everything you need to wire it into a sheet.

How do I pull Gas Prices into Google Sheets?

Install the VerveSheets add-on, sign in once with your key, and type =VERVE("gasprices", "field", "countryName") into any cell. The "field" argument names the value you want back, so the cell resolves to a single number or string you can chart, sort, or feed into another formula.

What data can I pull from Gas Prices?

Gas Prices returns countryName, areaName, areaType, week and nativeCurrency, plus 4 more — name any one of them as the "field" argument and that value lands in the cell. Leave the field out and the whole record spills into a two-column table instead.

Can I narrow what Gas Prices returns?

Yes — Gas Prices takes "country", "area", "currency" and "unit", plus 1 more as optional inputs. They go in as "name", value pairs after the required ones, in any order, so =VERVE("gasprices", "country", "US") shapes the result without changing anything else.

Which Gas Prices fields need a paid plan?

prices.midgrade, prices.premium and prices.diesel are included from the Starter plan up. On the Free plan the cell returns #PREMIUM(field) rather than a wrong or empty value, so it's always obvious which one to upgrade for. Every other field works on Free.

Can I fill a whole column of Gas Prices at once?

Yes. Reference a range instead of a single cell and one call returns a value for every row, or drag =VERVE("gasprices") down like any spreadsheet function.

How many credits does each Gas Prices cell cost?

Each resolved cell costs 2 credits. A cell only re-bills when it actually refreshes, so a sheet you aren't touching doesn't keep charging.

Does Gas Prices work in Excel as well as Google Sheets?

Yes — same arguments, same key, same fields. Excel namespaces custom functions, so the call is =VERVE.CALL() there and =VERVE() in Google Sheets; nothing else about it changes.

How current is Gas Prices?

It draws on 29 countries, served live from APIVerve's production data engine, and cells recalculate on the cadence you choose — every open, hourly, or every 30 minutes.

Gas Prices

Live financial model

Track a whole watchlist

Dashboards that don't rot

Gas Prices, answered

Put Gas Prices in your next spreadsheet. Add the extension, paste the formula, and the cell keeps itself current.

Scaling up?