Google Sheets Functions

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

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

GORILLA_MYPRICE()

Description:
Get the lowest seller price for the SKU or ASIN.

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

Examples:

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

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

How can we help?