Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_BUYBOXOFFERS() – Get list of sellers competing for the buy box

GORILLA_BUYBOXOFFERS() – Get list of sellers competing for 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_BUYBOXOFFERS("TOY STORE", "B00YD545CC", "US", "TRUE")
=GORILLA_BUYBOXOFFERS("TOY STORE", "B00YD545CC", "DE", "FALSE")
=GORILLA_BUYBOXOFFERS("TOY STORE", "B00YD545CC")

Syntax description

BUYBOXOFFERS 2 Gorilla ROI

Description:

Get the list of all sellers and offerings on the listing and competing for the buy box. Does not pull information for SKUs that you do not sell. Only works for SKUs and ASINs in your inventory.

Syntax:

GORILLA_BUYBOXOFFERS(Seller ID, sku, [marketplace], [header])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

sku – REQUIRED
SKU or ASIN of the product. Unlike other functions, this one does NOT accept array inputs or ranges like {“SKU12345″,”ASIN12345”} or A1:A100.

marketplace – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, UK, CA etc.

header – OPTIONAL
Display header in the table of results

  • TRUE = auto creates a header as the first row of results. Selected by default if no values are entered.
  • FALSE = only shows the table of data. No headings or titles.

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_BUYBOXOFFERS("TOY STORE", "B00YD545CC", "US", "TRUE")

Returns all sellers for the listing in the US market along with details of the buy box. A header row is automatically generated.

=GORILLA_BUYBOXOFFERS("TOY STORE", "B00YD545CC", "DE", "FALSE")

Returns all sellers for the listing in the German market along with details of the buy box. A header row is not present. Only the data is displayed.

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

If only the SKU is entered, it will display data for all sellers in the default marketplace and include the header in the table.

How can we help?