Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. 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("TOY STORE", "B00YD545CC", "US", "all", "full")
=GORILLA_CATEGORY("TOY STORE", "B00YD545CC", "US", "all", "inner")
=GORILLA_CATEGORY("TOY STORE", "B00YD545CC", "US", "top", "full")

Syntax Description

CATEGORY Gorilla ROI

Description:

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

Syntax:

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

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

SKU – REQUIRED
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.

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("TOY STORE", "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("TOY STORE", "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("TOY STORE", "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 1024x162 SID 2 1 Gorilla ROI
gorilla category 1024x162 SID Gorilla ROI

How can we help?