How to get Hungary Vehicle Auctions in Google Sheets

Scrape live Hungarian government vehicle auctions from MBVK, NAV, and MNV - HUF prices, year, km, optional public VIN. arveres.mbvk.hu is one page of it. A run reads that public list and saves one row per result.

Set up the Apify actor

Apify is where this run is collected. An actor is the program that collects the rows. A task is that program saved with your settings, so the next section can ask for the latest rows. You need a free Apify account.

01
Open Hungary Vehicle Auctions and click Try for free. Create an Apify account if you do not have one. The Free plan does not ask for a card.
02
You are on the input form. Keep the sample for this first run.
```
{
    "sources": [
        "mbvk"
    ],
    "maxResults": 5
}
```
03
Leave the proxy setting as it is. Click Start and wait until the run says Succeeded.
04
Open Storage, then Dataset. You should see source, listingId, title, price.
05
When you want the real list, raise the row limit on the input. The sample is only there so the first run stays small.
06
Go back to the input and choose Save as a new task. Name it after this list.
07
Open the task. Copy the task ID from the address bar. Excel, Sheets, Power BI, and the other guides ask for this ID.
08
On the task, open Schedules and add a weekly run if you want fresh rows. Each run pays the start charge and the charge for the rows. The amounts are in the price list on this page.
09
Open Settings, then API & Integrations, and copy an API token. Excel, Sheets, and the other guides put this token in a download link. Anyone with that link can download the rows, so treat it like a password.

How to set up in Google Sheets

Use the task ID and the API token from Set up the Apify actor, above.

In a Google Sheet, click cell A1 and paste this formula. Replace TASK_ID and YOUR_TOKEN.

=IMPORTDATA("https://api.apify.com/v2/actor-tasks/TASK_ID/runs/last/dataset/items?format=csv&clean=true&status=SUCCEEDED&token=YOUR_TOKEN")

02
Wait until the columns fill. Sheets refreshes IMPORTDATA on its own. Use Data, Data connectors, Refresh when you want it now.
03
After the next scheduled run, the same cell reads that task's newest successful dataset.

Schema

Examples come from the actor sample, not a live result.

Name	Description	Example
`source`	Source (mbvk\|nav\|mnv)	`mbvk`
`listingId`	Listing / auction ID	`949899`
`title`	Title	`CITROEN C8`
`price`	Price (HUF)	`592500`
`currency`	Currency	`HUF`
`year`	Year	`2005`
`odometerKm`	Odometer (km)	`128000`
`location`	Location	`1214 Budapest, II. Rákóczi Ferenc út 289-295.`
`auctionEnd`	Auction end	`2026-11-03 12:00:00`
`estimateHuf`	Estimate / put-up (HUF)	`790000`
`url`	URL	`https://arveres.mbvk.hu/#/auction/949899`

sourceSource (mbvk|nav|mnv)mbvk
listingIdListing / auction ID949899
titleTitleCITROEN C8
pricePrice (HUF)592500
currencyCurrencyHUF
yearYear2005
odometerKmOdometer (km)128000
locationLocation1214 Budapest, II. Rákóczi Ferenc út 289-295.
auctionEndAuction end2026-11-03 12:00:00
estimateHufEstimate / put-up (HUF)790000
urlURLhttps://arveres.mbvk.hu/#/auction/949899