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


Syntax Description

review count guide


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


GORILLA_REVIEWCOUNT(sku, [marketplace])

for Gorilla Agency, the syntax is

GORILLA_REVIEWCOUNT(sellerID, sku, [marketplace])


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


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


Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.


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


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:


How can we help?