Table of Contents
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
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:
Binding | Brand |
IsAutographed | ItemDimensions |
ItemDimensions_Weight | ItemDimensions_Width |
ListPrice_Amount | ListPrice_CurrencyCode |
Model | PackageDimensions |
PackageDimensions_Weight | PackageDimensions_Width |
ProductGroup | ProductTypeName |
Size | SmallImage |
SmallImage_Width | Studio |
Color | IsAdultProduct |
ItemDimensions_Height | ItemDimensions_Length |
Label | ListPrice |
Manufacturer | MaterialType |
PackageDimensions_Height | PackageDimensions_Length |
PackageQuantity | PartNumber |
Publisher | Scent |
SmallImage_Height | SmallImage_URL |
Title |
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", "Scent")
Displays the scent name for ASIN B03H39FJ32. If no marketplace is assigned, it will grab the data from the main marketplace.
=GORILLA_PRODUCT(A2:A10,"Title")
Supports 2 dimensional ranges. Bulk return 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.
For Gorilla Agency, the formulas will start with the seller ID:
=GORILLA_FEETYPE("SELLER349d3")
=GORILLA_FEETYPE("SELLER349d3", "US", "FBA", "Column", "No")