Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_FEETYPE() – Return list of line item names associated as fees to Amazon account.

GORILLA_FEETYPE() – Return list of line item names associated as fees to Amazon account.

Description:
Return a list of the line item names associated as fees with to the Amazon account. All variables are optional.

GORILLA_FEETYPE([marketplace], [filter_fee], [direction], [full_list])

Gorilla Agency.the syntax is
GORILLA_FEETYPE(sellerID, [marketplace], [filter_fee], [direction], [full_list])

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_FEETYPE()
If no attributes are entered, it will list all the line items categorized as fees related to the Amazon account.

=GORILLA_FEETYPE("US", "FBA", "Column", "No")
Lists all fee types for the US marketplace, searching for any fees that start with “FBA”, displayed in a column and only displaying the fee’s associated with the Amazon account. If “YES” is used, it will return all Amazon fee names whether it is charged by the account or not.

For Gorilla Agency, the formulas will start with the seller ID: =GORILLA_FEETYPE("SELLER349d3")
=GORILLA_FEETYPE("SELLER349d3", "US", "FBA", "Column", "No")

Direction Attributes:

  • Column
  • Row

Full_list Attributes:

  • No – only shows fees related to the account
  • Yes – shows all fee names

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?