Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_COMPETITIVEPRICE(...

GORILLA_COMPETITIVEPRICE() – Get competitive price

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_COMPETITIVEPRICE("TOY STORE", A1:A1000, , "FullWithHeader", "LandedPrice")

Syntax description

COMPETITIVEPRICE Gorilla ROI

Description:

Get the current competitive price for your SKU or ASIN

Syntax:

GORILLA_COMPETITIVEPRICE(Seller ID, sku, [marketplace], [returnStyle], [priceType)

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

SKU – REQUIRED
SKU or ASIN of the product. Use arrays and ranges like A1:A1000 to bulk load data. See examples below. If a range of SKU is used in the formula, it will display the buy box price only.

marketplace – OPTIONAL
Marketplace filter. Use Default for the seller default. Other valid values are country codes US, DE, etc.

returnStyle – OPTIONAL
Format of the results returned. Default is price for the lowest competitive 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
Type of price to return. Default is ListingPrice. Other Valid values are: LandedPrice, ShippingPrice or ‘TradeInValuePrice’. This parameter is ignored when returnStyle is full

  • LandedPrice – Displays the results based on the LandedPrice of the SKU that is entered in Seller Central
  • ListingPrice – Displays the results based on the ListingPrice of the SKU that is entered in Seller Central
  • ShippingPrice – Displays the results based on the ShippingPrice of the SKU that is entered in Seller Central
  • TradeInValuePrice – Displays the results based on the TradeInValuePrice of the SKU that is entered in Seller Central

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_COMPETITIVEPRICE("TOY STORE", A1:A1000)

Returns a list of prices only where A1:A1000 is the list of SKUs or ASINs.

=GORILLA_COMPETITIVEPRICE("TOY STORE", A1:A1000, "US", "FullWithHeader")

Returns the competitive prices only for all SKUs in A1:A1000. Pulls from the US and displays a full table with headers.

=GORILLA_COMPETITIVEPRICE("TOY STORE", A1:A1000, , "FullWithHeader", "LandedPrice")

Returns the competitive price for the list of SKU or ASIN in the default marketplace because no marketplace is defined. Looking up landed price with a full table with header.

 =GORILLA_COMPETITIVEPRICE("TOY STORE", "B00YD545CC")

If only the SKU or ASIN is entered, it will display the price for that single product only.

Tags

EBOOKS tO HELP unleash your amazon success

Enter your name and email for the full download package now.

Want SPREADSHEETS CREATED BY 7-Figure AMAZON Sellers?

Enter your name & email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.