Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_CHARGETYPE() – Returns list of line item names for all “charges” to Amazon account when related to sales

GORILLA_CHARGETYPE() – Returns list of line item names for all “charges” to Amazon account when related to sales

Sample Usage

=GORILLA_CHARGETYPE()
=GORILLA_FEETYPE("US", "Marketpl", "Column", "No")

Syntax Description

Returns a list of the line item names for all “charges” to your Amazon account when it is related to sales. Names include charges related to both income and expense.

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

for 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_CHARGETYPE()

If no attributes are entered, it will list all the line items categorized as fees related to the Amazon account.

=GORILLA_FEETYPE("US", "Marketpl", "Column", "No")

Lists all fee types for the US marketplace, searching for any fees that start with “Marketpl”, displayed in a column and only displaying the charges associated with the Amazon account. If “YES” is used, it will return all Amazon chargetype names.

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

=GORILLA_FEETYPE("SELLER349d3")
=GORILLA_FEETYPE("SELLER349d3", "US", "Marketpl", "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?