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_REVIEWSFILTER("TOY STORE", "Custom", "US", "B00YD545CC", "5", "2021-01-01", "2021-01-21")
=GORILLA_REVIEWSFILTER("TOY STORE", "This Week","ALL",A2:A10,"ALL")
Syntax Description

Description:
Gets total number of 1,2,3,4,5 or all reviews for a product between any time period. Only the time period is required. Other attributes are optional.
Syntax:
GORILLA_REVIEWSFILTER(Seller ID, period, [marketplace], [sku], [stars], [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 the number of reviews. See full list of predefined periods below.
marketplace – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc.
sku – OPTIONAL
Any Seller SKU/ASIN to limit results. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.
stars – OPTIONAL
The review star rating to filter for
- All (default)
- 1
- 2
- 3
- 4
- 5
start_date – OPTIONAL
Starting date to get number of reviews from when period is custom.
end_date – OPTIONAL
Ending date to get number of reviews from when period is 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_REVIEWSFILTER("TOY STORE", "Custom", "US", "B00YD545CC", "5", "2021-01-01", "2021-01-21")
Gets total number of 5 star reviews for B00YD545CC in the US marketplace between Jan 1, 2021 and Jan 21, 2021.
=GORILLA_REVIEWSFILTER("TOY STORE", "This Week","ALL",A2:A10,"ALL")
Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns the count of all reviews 1-5. Can also work for rows and ranges like A1:Z1 or D3:G37.
=GORILLA_REVIEWSFILTER("TOY STORE", "2019Q1", "US", "B00YD545CC", "1")
=GORILLA_REVIEWSFILTER("TOY STORE", "2019-05", "US", "B00YD545CC", "3")
To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.
To get monthly data, use the format YYYY-MM as the preset period.
=GORILLA_REVIEWSFILTER("TOY STORE", "This Month", "ALL", "IPHN3724", "5")
Gets the total number of 5 star reviews for SKU IPHN3724 from all marketplaces.
=GORILLA_REVIEWSFILTER("TOY STORE", "Same Day Last Month", "ALL", “IPHN3724”, "1")
Gets the total number of 1 star reviews for SKU IPHN3724 from all marketplaces.
=GORILLA_REVIEWSFILTER("TOY STORE", "This Year")
Gets the total number of reviews all products, account across all marketplaces.