Skip to main content
All CollectionsGoogle Sheets FunctionsMarket Data Plan Functions
GORILLA_ISFBA() – Check if a SKU or ASIN is FBA or FBM or both

GORILLA_ISFBA() – Check if a SKU or ASIN is FBA or FBM or both

Updated over 2 months ago

GORILLA_ISFBA() – Check if a SKU or ASIN is FBA or FBM or both

Sample Usage

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources. 
=GORILLA_ISFBA("TOY STORE", D2)
=GORILLA_ISFBA("TOY STORE", A1:A1000, "US")
=GORILLA_ISFBA("TOY STORE", A1:E10)

Syntax Description

ISFBA Gorilla ROI

Description:

Check if a SKU or ASIN is FBA or FBM or both

Syntax:

GORILLA_ISFBA(Seller ID, sku, [marketplace])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

sku – REQUIRED
SKU or ASIN to filter the results. Can be a range of values like A1:A100 or SKU111, SKU222, SKU333 or ASIN123.

marketplace – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, SE, TR, IN, SE, AU, SG, JP. Use DEFAULT for seller default.

Examples:

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources. 
=GORILLA_ISFBA("TOY STORE", D2)

Uses the ASIN or SKU entered in cell D2 and returns the result of whether it is FBA or FBM

=GORILLA_ISFBA("TOY STORE", A1:A1000, "US")

Bulk method to check whether the SKUs or ASINs listed in A1:A1000 are FBA, FBM or both.

=GORILLA_ISFBA("TOY STORE", A1:E10)

Formula supports 2D directions. Not just a single row or column.

Did this answer your question?