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

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

Syntax descriptionbybox winner

Description:

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 closed 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_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)

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?