Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_BUYBOXWINNER() – See if you are winning the buy box

GORILLA_BUYBOXWINNER() – See if you are winning the buy box

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

Syntax description

BUYBOXWINNER Gorilla ROI

Description:

Returns “winner” or “loser” based on whether you are winning or losing the buy box.

Syntax:

GORILLA_BUYBOXWINNER(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.

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

Returns “winner” or “loser” for each of the SKU or ASIN listed. The results are for the US marketplace.

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

Returns “winner” or “loser” for the ASIN B00YD545CC. The default marketplace is used as no marketplace is defined.

=GORILLA_BUYBOXWINNER("TOY STORE", A1:A1000)

Returns “winner” or “loser” for each of the ASINs or SKUs listed from A1 to A1000.

How can we help?