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
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
Today | This month | Last 3 Months |
Yesterday | This quarter | Last 12 Months |
Same day last week | This year | Last 7 Days Week Ago |
Same day last month | This Year-to-Last-Month | Last 7 Days Year Ago |
Same day last year | Last Week | Last 30 Days Month Ago |
Last 7 Days | Last Month | Last 30 Days Year Ago |
Last 14 Days | Last Quarter | Last Week Year Ago |
Last 30 Days | Last Year | Last Month Year Ago |
Last 90 Days | Last 60 Days | YYYY-MM (change format to text) |
This week | YYYY | 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.