Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_BUYBOXSELLERS() &...

GORILLA_BUYBOXSELLERS() – Show the number of sellers competing for buybox for a given product.

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_BUYBOXSELLERS("TOY STORE", A1:A1000, "US")
=GORILLA_BUYBOXSELLERS("TOY STORE", "B00YD545CC")
=GORILLA_BUYBOXSELLERS("TOY STORE", A1:A1000, "FR")

Syntax description

Gorilla ROI

Description:

Show the number of sellers competing for buybox for a given product.

Syntax:

GORILLA_BUYBOXSELLERS(Seller ID, sku, [marketplace])

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

sku – REQUIRED
SKU or ASIN of the product. Use arrays and ranges like A1:A1000 to bulk load data. See examples below. If a range of SKU is used in the formula, it will display the buy box price only.

Marketplace – OPTIONAL
Marketplace filter. Use Default for the seller default. Other valid values are country codes US, DE, etc.

Screenshot:

BUYBOXSELLERS SCREENSHOT 2 Gorilla ROI

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_BUYBOXSELLERS("TOY STORE", A1:A1000, "US")

Returns the number of sellers competing for buybox in the United States based on the SKU list from A1 to A100.

=GORILLA_BUYBOXSELLERS("TOY STORE", "B00YD545CC")

Returns the number of sellers competing for buybox based on the SKU ‘B00YD545CC’.

=GORILLA_BUYBOXSELLERS("TOY STORE", A1:A1000, "FR")

Returns the number of sellers competing for buybox in France based on the ASIN list from A1 to A100.

EBOOKS tO HELP unleash your amazon success

Enter your name and email for the full download package now.

Want SPREADSHEETS CREATED BY 7-Figure AMAZON Sellers?

Enter your name & email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.