Google Sheets Functions

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

GORILLA_BUYBOXWINNERFULL() – Show the Buy Box winner details for the selected products.

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

Syntax description

BUYBOXWINNERFULL Gorilla ROI

Description:

Show the Buy Box winner details for the selected products.

Syntax:

GORILLA_BUYBOXWINNER(Seller ID, sku, [marketplace], [header], [transpose])

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.

Header – OPTIONAL
Include a header line in the results. Possible values: TRUE/FALSE. Default: TRUE

Transpose – OPTIONAL
 If empty or “false”, returns datapoints as column headers.

Screenshot:

BUYBOXWINNERFULL.EXAMPLE 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_BUYBOXWINNERFULL("TOY STORE", A1:A1000, "US")

Returns the details of buybox winner for each of the ASINs or SKUs listed from A1 to A1000 in the United States.

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

Returns the details of the buybox winner for the SKU ‘B00YD545CC’.

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

Returns the details of the buybox winner for each of the ASINs or SKUs listed from A1 to A1000.

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.