Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_MYPRICE() – Get the lowest seller price for the SKU or ASIN

GORILLA_MYPRICE() – Get the lowest seller price for the SKU or ASIN

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

Syntax Description

gorilla myprice Gorilla ROI

Description:

Get your selling price for the SKU or ASIN.

Syntax:

GORILLA_MYPRICE(sku, [marketplace], [condition], [subcondition], [priceType])

for Gorilla Agency, the syntax is

Gorilla_MYPRICE(sellerID, sku, [marketplace], [condition], [subcondition], [priceType])

GORILLA_MYPRICE Attributes

Condition Attributes:

  • New
  • Used
  • Collectible
  • Refurbished
  • Club

SubCondition Attributes:

  • Mint
  • Very Good
  • Good
  • Acceptable
  • Poor
  • Club
  • OEM
  • Warranty
  • Refurbished Warranty
  • Refurbished
  • Open Box
  • Other

priceType Attributes:

  • 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_MYPRICE(D2)

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

=GORILLA_MYPRICE("B03H39FJ32", "US", "New", "mint", "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_INVENTORY(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_MYPRICE("SELLER ID", D2)
=GORILLA_MYPRICE("SELLER ID", "B03H39FJ32", "US", "New")
=GORILLA_MYPRICE("SELLER ID", "B03H39FJ32", "US", "New", "mint", "ListingPrice")
=GORILLA_INVENTORY("SELLER ID", A2:C10)

How can we help?