Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SETTLEMENT() – Get the list of settlement IDs

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.

How can we help?