Export a Mercari Japan search to Google Sheets

Created by

Adriana Voss

Actor

Mercari Japan Scraper: New Listings & Sold Prices

Export a Mercari Japan search to Google Sheets: one flat row per listing, $2 per 1,000 returned. No login needed. Fast and reliable.

Try for free

Mercari Japan Scraper: New Listings & Sold Pricesaccountable_eel/mercari-jp-listing-lookup

Search submitted

Found?

Status

Details

+55 fields

Input

Mercari Japan searches to run (keywords, or a pasted search URL)(required):nintendo switch

Most listings to return per search:100

Output fields

Search submitted

Found?

Status

Details

Listing type (active / sold / all)

Listings returned

Total matching on Mercari (capped at 15,000)

More results were available

New listings this run

Price drops this run

Gone since last run (sold or delisted; monitoring only)

Sell-through rate, watchlist lifetime (0-1; monitoring only)

Median price of the search, JPY (fixed-price listings; monitoring only)

Brand filter resolved to (MKT-FILTERS "brands" input; empty when not set)

Active listings counted in the comps summary (sold comps only)

Sold listings counted in the comps summary (sold comps only)

Span of the sold comps, oldest to newest last-status-change date, in days (sold comps only)

Median asking price of fixed-price active listings, JPY (sold comps only)

Median sold price, JPY (sold comps only)

Asking vs. sold median price gap in % (sold comps only)

Median days from posted to sold; always empty on Mercari, which publishes no sale date (sold comps only)

All listings found (full list)

Mercari item ID

Listing link

Title

Price (JPY)

Currency

Sold price, JPY (sold listings only — Mercari is fixed-price, the price IS the sale price)

Status (on_sale / trading / sold_out)

Status (standard: available / reserved / sold)

Condition ID (1 best to 6 worst)

Condition

Condition (Japanese)

Condition (standard grade: new, like_new, good, fair, unknown — lossy on purpose, see help text)

Condition, raw (Mercari's own id + Japanese label, verbatim)

Category ID

Brand

Seller type (private / Mercari Shops business)

Shipping paid by

Auction listing

Auction ends

Listed at

Listed at (standard column name, same value as "Listed at"/postedAt)

Last updated (sold time for sold items)

Image

Seller (anonymous hash)

Seller ID (only with seller info on)

Is this listing new?

Change (new / price-drop / gone / seen)

Previous price (JPY)

Price drop %

First seen on a run

Last seen on a run

Days listed (first to last seen)

Last price seen before it went, JPY (gone rows)

Sold or presumed sold (gone rows)

Sale confirmed by Mercari (true sold / false deleted or paused / empty unknown)

Checked at

How it works

Sign up on Apify or log in

The Mercari Japan Scraper: New Listings & Sold Prices Actor is ready to run with the inputs already set for "Export a Mercari Japan search to Google Sheets". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Export a Mercari Japan search to Google Sheets" task

The Mercari Japan Scraper: New Listings & Sold Prices Actor will start running based on the input automatically. You can also change all the input fields, like mercari japan searches to run (keywords, or a pasted search url) and most listings to return per search, to match your specific use case.

Receive the "Export a Mercari Japan search to Google Sheets" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as search submitted, found?, status, and more.

Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also run the "Export a Mercari Japan search to Google Sheets" task via API.