Sample Usage

=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:A100) in your formula wherever possible for quicker results and to prevent Google 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")

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.