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

Syntax descriptionbybox winnerDescription:

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

Syntax:

GORILLA_BUYBOXWINNER(sku, [marketplace])

for Gorilla AGENCY, the syntax is

GORILLA_BUYBOXWINNER(seller ID, sku, [marketplace])

sku
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. or Amazon Marketplace ID like ATVPDKIKX0DER.

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

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

=GORILLA_BUYBOXWINNER("B00YD545CC")

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

=GORILLA_BUYBOXWINNER(A1:A1000)

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

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

=GORILLA_BUYBOXWINNER("SELLERID837834", A1:A1000, "US")
=GORILLA_BUYBOXWINNER("SELLERID837834", "B00YD545CC")
=GORILLA_BUYBOXWINNER("SELLERID837834", A1:A1000)

How can we help?