FalconScrape for Google Sheets™

OLX to Google Sheets

Pull OLX listings (Poland, Bulgaria, Romania, Portugal, Ukraine) into Google Sheets with =OLX_SEARCH. Price, city, seller, URL — no IMPORTXML, no selectors.

=OLX_SEARCH("iphone 15", "pl", 1, "limit=5")

Install from Google Workspace Marketplace, choosing Individual install for your account. Open a spreadsheet, then Extensions → FalconScrape → Activate / Account → Activate with Google. Enter the formula in an empty area; results expand down and right with a header row. Cell references such as A2 must contain a valid input.

More examples

• =OLX_SEARCH("rower", "pl", 1, "limit=50;sort=price_asc;priceTo=500")
• =OLX_SEARCH("apartament", "ro", 2, "postedAfter=7d")
• =OLX_DETAIL(A2)

Columns

1 credit per row, up to 50 rows per call. OLX_DETAIL costs 2 credits and adds description, coordinates and seller join date. See plans and credits.

Refresh results

Run Extensions → FalconScrape → Refresh all once to create the FALCON_REFRESH named range. Then use this version of the formula:

=OLX_SEARCH("iphone 15", "pl", 1, "limit=5", FALCON_REFRESH)

Refresh all updates the marker. Formulas referencing a marker less than 60 seconds old request fresh results, which consume credits when successful. Formulas without the reference are unaffected. Normal cache hits cost nothing; there is no scheduled refresh or automatic price-history log.

FAQ

Why doesn't IMPORTXML work on OLX?

OLX renders listings with JavaScript and blocks Google's fetch IP range, so IMPORTXML returns #N/A or Loading… forever. FalconScrape calls a production OLX scraper with proxy rotation and returns a typed table.

What input does OLX_DETAIL need?

Use the numeric listing ID from column A of OLX_SEARCH, not the listing URL. If A2 contains that ID, enter =OLX_DETAIL(A2) in an empty area. For non-Polish results, use the matching country code, for example =OLX_DETAIL(A2, "ro"). URLs are not supported yet.

Which OLX countries are supported?

olx.pl (default), olx.bg, olx.ro, olx.pt and olx.ua — pass the country code as the second argument.

Can I filter or sort?

Yes: the options argument takes limit, sort (price_asc, price_desc, newest), priceFrom, priceTo, postedAfter (e.g. 7d) and categoryId, separated by semicolons.

Does it refresh automatically?

Refresh is manual. Include FALCON_REFRESH as the final argument, then use Extensions → FalconScrape → Refresh all. Formulas with a marker less than 60 seconds old request fresh results; successful fresh fetches consume credits. Normal cache hits are free.