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(D2)
=GORILLA_LOWESTPRICE("B03H39FJ32", "US", "New")
=GORILLA_LOWESTPRICE("B03H39FJ32", "US", "New", "ListingPrice")
=GORILLA_LOWESTPRICE(A2:C10)

Syntax Description

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.

Syntax:

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

for Gorilla Agency, the syntax is

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

GORILLA_LOWESTPRICE Attributes

Condition Attributes:

  • New
  • Used
  • Collectible
  • Refurbished
  • Club

    priceType Attributes:

  • LandedPrice
  • ListingPrice
  • ShippingPrice
  • RegularPrice

Examples:

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.

=GORILLA_LOWESTPRICE(D2)

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

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

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.

=GORILLA_LOWESTPRICE(A2:C10)

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", D2)
=GORILLA_LOWESTPRICE("SELLER23HH", "B03H39FJ32", "US", "New")
=GORILLA_LOWESTPRICE("SELLER23HH", "B03H39FJ32", "US", "New", "ListingPrice")
=GORILLA_LOWESTPRICE("SELLER23HH", A2:C10)

How can we help?