Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_REMOVALS() –...

GORILLA_REMOVALS() – Get FBA Recommended Removals Data

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_REMOVALS($A$1, $A$5:$A$24)
=GORILLA_REMOVALS("TOY STORE", "ABC-XYZ-AMZ01")
=GORILLA_REMOVALS("TOY STORE", "ABC-XYZ-AMZ01", "sellable-removal-quantity")
=GORILLA_REMOVALS("TOY STORE", "B0811T2N2Z", "unsellable-quantity")

Syntax Description

GORILLA REMOVALS Gorilla ROI

Description:

Get FBA Recommended Removals Data.

Syntax:

GORILLA_REMOVALS(sellerId, sku, [datapoint])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

sku – REQUIRED
SKU, ASIN or FNSKU to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or FKSKU123… If datapoint is not specified, only single value or a column of SKU’s can be provided, not a matrix.

datapoint OPTIONAL
Return data for specific data points. Can be a range of values like A1:E1 where A1 to E1 consists of different datapoint values. Default is empty value for all data points.
Other Valid values are:

  • snapshot-date
  • sellable-quantity
  • unsellable-quantity
  • sellable-removal-quantity
  • sellable-365+-days
  • sellable-271-365-days
  • sellable-181-270-days
  • sellable-121-180-days
  • unsellable-61-90-days
  • unsellable-8-60-days
  • unsellable-0-7-days

header OPTIONAL
Include the header line in the results.
Possible values: TRUE/FALSE.
Default: TRUE

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_REMOVALS($A$1, $A$5:$A$24)

$A$1 being the Seller ID, $A$5:$A$24 being SKU, ASIN, or FNSKU will return removal data for all the datapoints.

=GORILLA_REMOVALS("TOY STORE", "ABC-XYZ-AMZ01")

This will return removal data for all the datapoints for the SKU ABC-XYZ-AMZ01.

=GORILLA_REMOVALS("TOY STORE", "ABC-XYZ-AMZ01", "sellable-removal-quantity")

This will return sellable-removal-quantity datapoint for the SKU ABC-XYZ-AMZ01.

=GORILLA_REMOVALS("TOY STORE", "B0811T2N2Z", "unsellable-quantity")

This will return unsellable-quantity datapoint for the ASIN B0811T2N2Z.

EBOOKS tO HELP unleash your amazon success

Enter your name and email for the full download package now.

Want SPREADSHEETS CREATED BY 7-Figure AMAZON Sellers?

Enter your name & email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.