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
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:
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.