Google Sheets Functions

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

GORILLA_SETTLEMENT() – Get the list of settlement IDs

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_SETTLEMENT("TOY STORE", "LAST WEEK")
=GORILLA_SETTLEMENT("TOY STORE", "LAST MONTH", "DEPOSIT")
=GORILLA_SETTLEMENT("TOY STORE", "CUSTOM", , "2022-10-01", "2022-11-10")

Syntax Description

image 9 Gorilla ROI

Description:

Get the settlements data. SETTLEMENT is a dump of the Settlement IDs where the Settlements occurred.

WARNING: For large sellers, do NOT use this function for a long time period, like “last year”. It will try to load thousands of orders. Google will timeout and will block your requests for the next 24hrs as it thinks you are a bot.

Syntax:

=GORILLA_SETTLEMENT(Seller ID, period, [period_filter], [start_date], [end_date])

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

period – REQUIRED
Predefined period to get refunded units. See full list of predefined periods below.

period_filter – OPTIONAL
Datapoint used for period filter, valid inputs are: “Settlement”(DEFAULT), “Deposit”

start_date – OPTIONAL
Starting date to get sales from when period is custom. To use custom dates, specify the period as “CUSTOM”.

end_date – OPTIONAL
Ending date to get sales from when period is custom. To use custom dates, specify the period as “CUSTOM”.

GORILLA_SETTLEMENT Attributes

Period Attributes

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

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_SETTLEMENT("TOY STORE", "LAST WEEK")

This will list all settlements over the last week. You will get details such as the Settlement ID, Settlement Start Date, Settlement End Date, Deposit Date, Total Amount, Currency.

=GORILLA_SETTLEMENT("TOY STORE", "LAST MONTH", "DEPOSIT")

Returns a list of all deposits from last month.

=GORILLA_SETTLEMENT("TOY STORE", "CUSTOM", , "2022-10-01", "2022-11-10")

Use custom date ranges to extract data between Oct 1st, 2022 and Nov 10th, 2022. Listing all settlements within this period.

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.