FalconScrape for Google Sheets™

Mercari Japan to Google Sheets

Search Mercari Japan from a Google Sheets cell. Return item names, prices in JPY, availability status and links; look up individual items for seller and description fields.

=MERCARI_SEARCH("nintendo switch", "limit=5")

Install and activate the add-on from Extensions → FalconScrape → Activate / Account. 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

• =MERCARI_SEARCH("nintendo switch", "limit=5;priceMin=1000;priceMax=20000")
• =MERCARI_DETAIL(A2)

Columns

Search costs 1 credit per returned row, up to 50 rows; detail costs 2 credits per item. Prices are in JPY. Paste an item ID or URL into A2 and run the detail formula in an empty area or another sheet. 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:

=MERCARI_SEARCH("nintendo switch", "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

Does this cover Mercari US?

No. These formulas cover Mercari Japan at jp.mercari.com.

Does MERCARI_SEARCH take a page number?

No. Its arguments are query, optional options, then optional refresh. Put limit=5 directly in the second argument. Inserting a page number there causes an argument error.

Which filters can I use?

The Sheets formula supports limit, priceMin, priceMax and categoryId. Separate options with semicolons, for example limit=5;priceMin=1000;priceMax=20000. Price filters are in JPY.

What does MERCARI_DETAIL return?

Pass an m-prefixed item ID from the search result, or a Mercari Japan item URL. Detail adds description and seller fields, including available rating information. Fields may be blank if the source does not provide them.