Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_STORAGEFEES() – Get your Amazon storage fees report

GORILLA_STORAGEFEES() – Get your Amazon storage fees report

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_STORAGEFEES("2022-08", A1:A260)
=GORILLA_STORAGEFEES("Last 90 Days","B00H9D0D4G")
=GORILLA_STORAGEFEES("last month", A1:A1000, "oversize", "US")

Syntax Description

storage fees function

Description:

Get monthly storage fees report and details by ASIN.

Syntax:

GORILLA_STORAGEFEES(period, asin, [product_size_tier], [fc_location], [dangerous_goods_storage_type], [start_date], [end_date])

For Gorilla Agency users the syntax is

GORILLA_STORAGEFEES(seller id, period, asin, [product_size_tier], [fc_location], [dangerous_goods_storage_type], [start_date], [end_date])

period
REQUIRED – Predefined period to get storage fees data or use custom to specify a start and end date. As this is a monthly report, not all time periods will be supported.

TodayThis monthLast 3 Months
YesterdayThis quarterLast 12 Months
Same day last weekThis yearLast 7 Days Week Ago
Same day last monthThis Year-to-Last-MonthLast 7 Days Year Ago
Same day last yearLast WeekLast 30 Days Month Ago
Last 7 DaysLast MonthLast 30 Days Year Ago
Last 14 DaysLast QuarterLast Week Year Ago
Last 30 DaysLast YearLast Month Year Ago
Last 90 DaysLast 60 DaysYYYY-MM (change format to text)
 This weekYYYY YYYYQ1… YYYYQ4
Custom

ASIN
REQUIRED must use ASIN. SKU will not work. Can be a range of values like A1:A100 where A1 to A100 consists of values like ASIN111, ASIN222, ASIN333 or ASIN123.

If more than one ASIN is entered into the formula, please enter a single month for the period.

product_size_tier
OPTIONAL – Product size tier. Can be a range of values like A1:A100 where A1 to A100 consists of values like Standard-Size, Oversize. Use ALL to get values from all sizes (default).

  • Standard-size
  • Oversize
  • All

fc_location
OPTIONAL – Fulfillment center location filter.

Valid country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP. Use ALL to get values from all centers (default).
Default value is “ALL”.

dangerous_goods_storage_type
OPTIONAL – Dangerous goods storage type.

Valid values:

  • ALL (default)
  • NONE
  • AEROSOLS
  • FLAMMABLES

start_date
OPTIONAL – Starting date for the returning range when period is “custom”.

end_date
OPTIONAL – Ending date for the returning range when period is “custom”.

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_STORAGEFEES("2022-08", A1:A260)

This will load all the storage fees paid in the month of 2022-08 for the ASINs listed in column A. This function does not support looking up SKUs. Only ASINs.

=GORILLA_STORAGEFEES("Last 90 Days","B00H9D0D4G")

Returns the monthly storage fees over the last 90 days (or 3 months). The result is a table of the past 3 months like so.

storage fees last 90 days Gorilla ROI

You can only use one ASIN input if you select a time period other than a single month. If you wish to display for each ASIN, you MUST select only 1 month to enter into the time period.

=GORILLA_STORAGEFEES("last month", A1:A1000, "oversize", "US")
storage fees out results Gorilla ROI

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

=GORILLA_STORAGEFEES("toywonder", "2022-08", A1:A260)
=GORILLA_STORAGEFEES("whizbiz", "Last 90 Days","B00H9D0D4G")
=GORILLA_STORAGEFEES("A78398HDSD", "last month", A1:A1000, "oversize", "US")

How can we help?