Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_FEESESTIMATE() – Get estimated fees for product

GORILLA_FEESESTIMATE() – Get estimated fees for product

Sample Usage

=GORILLA_FEESESTIMATE(D2)
=GORILLA_FEESESTIMATE(A2:C10)
=GORILLA_FEESESTIMATE("738-JDUY-32F", "default", "fullwithheader")

Syntax Description

Get the estimated fees associated with the product. (Not the actual settlement product fees and charges to your accounts).

GORILLA_FEESESTIMATE(sku, [marketplace], [returnStyle])

Gorilla Agency, the syntax is

GORILLA_FEESESTIMATE(sellerID,sku, [marketplace], [returnStyle])

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.

returnstyle

OPTIONAL

  • Full – displays full information of each seller offering the product without header information.
  • Fullwithheader – autocreates a header row and displays fulls information of each seller offering the product.

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_FEESESTIMATE(D2)

Uses the ASIN or SKU entered in cell D2 and shows the total estimate fee (Fulfillment fee + referral fee) for the SKU. If Amazon does not have the price information, no estimate will be provided.

=GORILLA_FEESESTIMATE(A2:C10)

Supports 2 dimensional ranges. Also works horizontally. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A2:C10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

=GORILLA_FEESESTIMATE("738-JDUY-32F", "default", "fullwithheader")

Entering all the attributes will display the full breakdown of the fee estimate for the product.“Default” refers to your main marketplace. “Fullwithheader” creates another row before the results with the table headers to make it easy to identify.

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

=GORILLA_FEESESTIMATE("SELLER ID", D2)
=GORILLA_FEESESTIMATE("SELLER ID", "A2:C10")
=GORILLA_FEESESTIMATE("SELLER ID", "738-JDUY-32F", "default", "fullwithheader")

 

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?