Google Sheets Functions

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

GORILLA_BUYBOXOFFERS() – Get list of sellers competing for the buy box

Sample Usage

=GORILLA_BUYBOXOFFERS(sku, [marketplace], [header])

amazon buy box offers

Syntax description

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

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

for Gorilla Agency, the syntax is

GORILLA_BUYBOXOFFERS(sellerID, sku, [marketplace], [header])

sku

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

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 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_BUYBOXOFFERS(“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(“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(“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.

For Gorilla Agency, the formulas will start with the seller ID:

=GORILLA_BUYBOXOFFERS(“SELLERID837834”, “B00YD545CC”, “US”, “TRUE”)
=GORILLA_BUYBOXOFFERS(“SELLERID837834”, “B00YD545CC”, “US”, “FALSE”)
=GORILLA_BUYBOXOFFERS(“SELLERID837834”, “B00YD545CC”)

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?