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

Description:

Get product information for a SKU or ASIN such as title, size, weight, color and other supported attributes.

Syntax:

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

SELLER ID – REQUIRED
Enter the Seller ID or Nickname you entered in your Gorilla account.

SKU – REQUIRED
SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

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

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.

GORILLA_PRODUCT Attributes:

• 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

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.