Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_PRODUCT() – Get product info such as title, image, weight

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

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("IPHONE7382", "SmallImage_URL", "US")
=IMAGE(GORILLA_PRODUCT("IPHONE7382", "SmallImage_URL", "US"))
=GORILLA_PRODUCT("B03H39FJ32", "Scent")

Syntax Description

show product info

Description:

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

Syntax:

GORILLA_PRODUCT(sku, attributes, [marketplace])

for Gorilla Agency, the syntax is

=GORILLA_PRODUCT("SELLER ID", "IPHONE7382", "SmallImage_URL", "US")
=GORILLA_PRODUCT("SELLER ID", "B03H39FJ32", "Scent")
=GORILLA_PRODUCT("SELLER ID", A2:A10,"Title")

SKU

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

Attribute

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. or Amazon Marketplace ID like ATVPDKIKX0DER.

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
  • SmallImage_URL
  • 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("IPHONE7382", "SmallImage_URL", "US")

This formula will pull the main small image URL of SKU IPHONE7382 from the US marketplace. You can then combine it with the regular IMAGE( ) to display it as an image.

=IMAGE(GORILLA_PRODUCT("IPHONE7382", "SmallImage_URL", "US")
=GORILLA_PRODUCT("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(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.

gorilla product function

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

=GORILLA_FEETYPE("SELLER349d3")
=GORILLA_FEETYPE("SELLER349d3", "US", "FBA", "Column", "No")

How can we help?