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

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

Syntax Description

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

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

for Gorilla Agency, the syntax is

Gorilla_ASINLIST(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: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_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”.

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")

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?