Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_MYPRICE() – Get t...

GORILLA_MYPRICE() – Get the 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("TOY STORE", D2)
=GORILLA_MYPRICE("TOY STORE", "B03H39FJ32", "US", "New", "mint", "ListingPrice")
=GORILLA_MYPRICE("TOY STORE", A2:C10)

Syntax Description

MYPRICE Gorilla ROI

Description:

Get seller price for product.

Syntax:

GORILLA_MYPRICE(Seller ID, sku, [marketplace], [condition], [subcondition], [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…

marketplace – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, BE, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP, EG, SA. Use ‘DEFAULT’ for seller default. Amazon Marketplace ID like ‘ATVPDKIKX0DER’ can be used too.

condition – OPTIONAL
Item condition. Default is ‘New’. Other Valid values are:

  • New
  • Used
  • Collectible
  • Refurbished
  • Club

subcondition OPTIONAL
Item subcondition. Default is ‘New’. Other Valid values are:

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

priceType OPTIONAL
Type of price to return. Default is ‘ListingPrice’. Other Valid values are:

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

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

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

GET YOUR SPREADSHEETS

Enter your email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.