Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_REVIEWSFILTER() – Get number of reviews between any time period

GORILLA_REVIEWSFILTER() – Get number of reviews between any time period

Only up to 500 products are updated at a time (in batches).
Refreshes are done every 4 days.

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

REVIEWSFILTER 1 Gorilla ROI

Description:

Show reviews count for products.

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 reviews or use ‘custom’ to specify a start and end date.

marketplace – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, BE, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP, EG, SA. Use ‘ALL’ to combine values from a single account, ‘EU’ for all Europe markets EXCEPT UK, ‘EURO’ to combine countries using EURO currency. Amazon Marketplace ID like ‘ATVPDKIKX0DER’ can be used too.

sku – OPTIONAL
SKU or ASIN to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values

stars – OPTIONAL
Rating stars filter (defaults to “all”):

  • 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.

How can we help?