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

=GORILLA_MYPRICE(D2)
=GORILLA_MYPRICE("B03H39FJ32", "US", "New", "mint", "ListingPrice")
=GORILLA_INVENTORY(A2:C10)

Syntax Description

Get the lowest seller price for the SKU or ASIN.

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

Gorilla Agency, the syntax is

Gorilla_MYPRICE(sellerID, 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.

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

GORILLA_MYPRICE Attributes

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

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

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?