Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_CATEGORY() – Get categories product is listed under

GORILLA_CATEGORY() – Get categories product is listed under

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_CATEGORY("B00YD545CC", "US", "all", "full")
=GORILLA_CATEGORY("B00YD545CC", "US", "all", "inner")
=GORILLA_CATEGORY("B00YD545CC", "US", "top", "full")

Syntax Description

gorilla category 1 1 Gorilla ROI

Description:

Get the categories a product is listed under. Only works for single marketplaces at a time. Not “ALL”.

Syntax:

GORILLA_CATEGORY(sku, [marketplace], [queryType], [returnStyle])

for Gorilla Agency, the syntax is

Gorilla_CATEGORY(sellerID, [marketplace], [filter_sku])

SKU

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

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.

queryType

OPTIONAL – What to retrieve (defaults to “top”):

  • top = Top Level category;
  • all = All categories (only 1 SKU/ASIN allowed);
  • child = Child category.

returnStyle

OPTIONAL – Return style (defaults to “full”):

  • full = Full category path;
  • inner = Only inner-most category name.

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_CATEGORY("B00YD545CC", "US", "all", "full")

Returns all categories and child categories the product is listed under. If B00YD545CC is a garlic press, the result will show both “Home&Kitchen” and “Home&Kitchen->Kitchen Utensils”

=GORILLA_CATEGORY("B00YD545CC", "US", "all", "inner")

Returns all categories and child categories the product is listed under. If B00YD545CC is a garlic press, the result will show “Home&Kitchen” and “Kitchen Utensils” instead of the full category path.

=GORILLA_CATEGORY("B00YD545CC", "US", "top", "full")

If “top” is selected, you may use it for array inputs to bulk display the category information. “Top” returns only the main category. If B00YD545CC is a garlic press, the result will show only the main category “Home&Kitchen”.

gorilla category Gorilla ROI
gorilla category array Gorilla ROI

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

=GORILLA_CATEGORY("SELLERIDABC", "B00YD545CC", "US", "all", "full")
=GORILLA_CATEGORY("SELLERIDABC", "B00YD545CC", "US", "all", "inner")
=GORILLA_CATEGORY("SELLERIDABC", "B00YD545CC", "US", "top", "full")

How can we help?