Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_LOWESTPRICE() – Get lowest price in the Amazon buy box

GORILLA_LOWESTPRICE() – Get lowest price in the Amazon buy box

Sample Usage

=GORILLA_LOWESTPRICE("B03H39FJ32", "US", "New", "ListingPrice")

Syntax Description


Get the lowest price of the SKU or ASIN that’s competing for the buy box. Only pulls a number if there is more than one seller on the listing.


GORILLA_LOWESTPRICE(sku, [marketplace], [condition], [returnStyle], [priceType])

for Gorilla Agency, the syntax is

GORILLA_LOWESTOFFER(sellerID,sku,[marketplace], [returnStyle], [priceType])


Condition Attributes:

  • New
  • Used
  • Collectible
  • Refurbished
  • Club

    priceType Attributes:

  • LandedPrice
  • ListingPrice
  • ShippingPrice
  • RegularPrice


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


Uses the ASIN or SKU entered in cell D2 and shows the price being offered by the seller.


Will return the current price for ASIN B03H39FJ32 being sold in the US with new condition only. Will not return any prices for used or other conditions.

=GORILLA_LOWESTPRICE("B03H39FJ32", "US", "New", "ListingPrice")

Filtering formula to get the price of ASIN B03H39FJ32 that is sold in the US, in new and mint condition. Returns the listing price.


Supports 2 dimensional ranges. Also works horizontally. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A2:C10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

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

=GORILLA_LOWESTPRICE("SELLER23HH", "B03H39FJ32", "US", "New", "ListingPrice")

How can we help?