Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. 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

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(D2)
=GORILLA_ISFBA(A1:A1000, “US”)
=GORILLA_ISFBA(A1:E10)

Syntax Description

gorilla isfba

Description:

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

Syntax:

GORILLA_MYPRICE(sku, [marketplace])

for Gorilla AGENCY, the syntax is

GORILLA_MYPRICE(sellerID, sku, [marketplace])

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. Amazon Marketplace ID like ATVPDKIKX0DER can be used too.

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(D2)

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

=GORILLA_ISFBA(A1:A1000, “US”)

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

=GORILLA_ISFBA(A1:E10)

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

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_ISFBA(“SELLER8832”, D2)
=GORILLA_ISFBA(“SELLER8832”, A1:A1000, “US”)
=GORILLA_ISFBA(“SELLER8832”, A1:E10)

How can we help?