FalconScrape for Google Sheets™

1688 to Google Sheets

Bring 1688.com wholesale listings into Google Sheets with ALIBABA1688_SEARCH. Retrieve price tiers, minimum order quantity and supplier details with ALIBABA1688_DETAIL.

=ALIBABA1688_SEARCH("phone case", 1, "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

• =ALIBABA1688_SEARCH("手机壳", 2, "limit=5")
• =ALIBABA1688_DETAIL(A2)

Columns

Search costs 1 credit per returned row; detail costs 2 credits per offer. Results are limited by the upstream page and may contain fewer rows than requested. Detail adds minOrderQuantity, tierPrices and supplier fields; paste an offer ID or URL into A2 and run that formula in a separate empty area. 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:

=ALIBABA1688_SEARCH("phone case", 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

Is this Alibaba.com or 1688.com?

This formula covers 1688.com, the China wholesale marketplace. It does not query Alibaba.com.

Which currency and search language are used?

Prices are returned in CNY. Search phrases may be Chinese or English; Chinese terms can match different listings.

Where are minimum order quantities and price tiers?

Use ALIBABA1688_DETAIL with the offer ID from the search result's id column, or its offer URL. These fields are in detail results, not the search table, and availability depends on the offer.

Can I request another page?

Yes. The second argument is the page number. The third argument supports limit, for example limit=5; it does not guarantee five matches.