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

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

Syntax Description

LOWESTPRICE Gorilla ROI

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(Seller ID, sku, [marketplace], [condition], [returnStyle], [priceType])

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

sku – REQUIRED
SKU or ASIN to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123… If array is given, returnStyle is ignored and set to price

marketplace – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP, EG, SA. Use DEFAULT for seller default.

condition – OPTIONAL

  • New
  • Used
  • Collectible
  • Refurbished
  • Club

returnStyle – OPTIONAL
Format of the results returned. Default is price for the lowest price for each SKU/ASIN provided. If full is specified, a table with all results found and details is returned. If fullWithheader is specified, an additional header line is added before the results for reference.

priceType – OPTIONAL

  • LandedPrice
  • ListingPrice
  • ShippingPrice
  • RegularPrice

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_LOWESTPRICE("TOY STORE", D2)

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

=GORILLA_LOWESTPRICE("TOY STORE", "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("TOY STORE", "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("TOY STORE", 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.

How can we help?