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

=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:A100) in your formula wherever possible for quicker results and to prevent Google 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)

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?