Skip to main content
All CollectionsGoogle Sheets FunctionsMarket Data Plan Functions
GORILLA_BUYBOXSELLERS() – Show the number of sellers competing for buybox for a given product.

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

Updated over 2 months ago

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.

Did this answer your question?