Google Sheets Functions

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

GORILLA_PRODUCT() – Get product info such as title, brand, weight, color

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_PRODUCT("TOY STORE", "IPHONE7382", "Size", "US")
=GORILLA_PRODUCT("TOY STORE", "IPHONE7382", "PackageDimensions_Height_value", "US", "METRIC")
=GORILLA_PRODUCT("TOY STORE", "B03H39FJ32", "Scent")

Syntax Description

Product Gorilla ROI

Description:

Get product information such as title, size, weight, color and other supported attributes.

Syntax:

GORILLA_PRODUCT(Seller ID, sku, attributes, [marketplace], [system], [fulfillment])

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…

ATTRIBUTE – REQUIRED
Product’s attribute to retrieve shown below.

  • Brand
  • Bullets
  • Classification
  • Color
  • isExpirationDatedProduct
  • IsHeatSensitive
  • ItemDimensions_Height_Units
  • ItemDimensions_Height_value
  • ItemDimensions_Length_Units
  • ItemDimensions_Length_value
  • ItemDimensions_Width_Units
  • ItemDimensions_Width_value
  • ItemTypeKeyword
  • Keywords
  • Language
  • ListPrice_Amount
  • ListPrice_CurrencyCode
  • Manufacturer
  • Model
  • PackageDimensions_Height_Units
  • PackageDimensions_Height_value
  • PackageDimensions_Length_Units
  • PackageDimensions_Length_value
  • PackageDimensions_Width_Units
  • PackageDimensions_Width_value
  • PackageDimensions_Weight_Units
  • PackageDimensions_Weight_value
  • PackageQuantity
  • PartNumber
  • ProductTypeName
  • RecommendedBrowseNodes
  • Scent
  • Size
  • Style
  • Title
  • UnitCount
  • VariationTheme

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

SYSTEM – OPTIONAL
Determines the measurement system to use when displaying sizes and weights. Valid values are: Imperial (DEFAULT), Metric.

FULFILLMENT – OPTIONAL
‘ALL’ shows any SKU matching the search criteria. ‘FBM’ displays fulfilled by merchant SKU’s only. ‘FBA’ displays fulfilled by Amazon SKU’s only. Default is set to ‘ALL’.

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_PRODUCT("TOY STORE", "IPHONE7382", "Size", "US")

This formula will pull the main Size of SKU IPHONE7382 from the US marketplace.

=GORILLA_PRODUCT("TOY STORE", "IPHONE7382", "PackageDimensions_Height_value", "US", "METRIC")

This formula will pull the PackageDimensions_Height_value for IPHONE7382 in the US Marketplace, but in Metric system.

=GORILLA_PRODUCT("TOY STORE", "B03H39FJ32", "BULLETS")

Displays the bullets from the listing for ASIN B03H39FJ32. It will grab the data from the main marketplace if no marketplace is assigned.

=GORILLA_PRODUCT("TOY STORE", A2:A10,"Title")

Supports 2-dimensional ranges. Bulk returns an array of values by assigning the range of the SKU. In this example, the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

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.