Google Sheets Functions

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

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

Sample Usage

=GORILLA_PRODUCT("IPHONE7382", "SmallImage_URL", "US")
=IMAGE(GORILLA_PRODUCT("IPHONE7382", "SmallImage_URL", "US"))
=GORILLA_PRODUCT("B03H39FJ32", "Scent")

Syntax Description

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

GORILLA_PRODUCT(sku, attributes, [marketplace])

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.

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.

gorilla product function

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

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

GORILLA_PRODUCT Attributes:

BindingBrand
IsAutographedItemDimensions
ItemDimensions_WeightItemDimensions_Width
ListPrice_AmountListPrice_CurrencyCode
ModelPackageDimensions
PackageDimensions_WeightPackageDimensions_Width
ProductGroupProductTypeName
SizeSmallImage
SmallImage_WidthStudio
ColorIsAdultProduct
ItemDimensions_HeightItemDimensions_Length
LabelListPrice
ManufacturerMaterialType
PackageDimensions_HeightPackageDimensions_Length
PackageQuantityPartNumber
PublisherScent
SmallImage_HeightSmallImage_URL
Title

 

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.

How can we help?