Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_REVIEWCOUNT() – Get number of reviews of a product

GORILLA_REVIEWCOUNT() – Get number of reviews of a product

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_REVIEWCOUNT("B00YD545CC", "CA")
=GORILLA_REVIEWCOUNT(A2:A10, ,)

Syntax Description

review count guide

Description:

Get the number of reviews for a given product based on SKU or ASIN. Only works for single marketplaces at a time. Not “ALL”.

Syntax:

GORILLA_REVIEWCOUNT(sku, [marketplace])

for Gorilla Agency, the syntax is

GORILLA_REVIEWCOUNT(sellerID, sku, [marketplace])

SKU

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

MARKETPLACE

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

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_REVIEWCOUNT("B00YD545CC", "CA")

Returns the number of reviews for ASIN B00YD545CC selling in the Canadian marketplace.

=GORILLA_REVIEWCOUNT(A2:A10, ,)

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 all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37. Default marketplace data is returned as no marketplace is set.

review count

For Gorilla Agency, the formulas will start with the seller ID:

=GORILLA_REVIEWCOUNT("SELLER ID", "B00YD545CC", "CA")
=GORILLA_REVIEWCOUNT("SELLER ID", A2:A10, ,)

How can we help?