Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_RATINGSCOUNT() – Get number of ratings for product

GORILLA_RATINGSCOUNT() – Get number of ratings for product

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_RATINGSCOUNT("TOY STORE", "B00YD545CC", "CA")
=GORILLA_RATINGSCOUNT("TOY STORE", A2:A10)

Syntax Description

RATINGSCOUNT Gorilla ROI

Description:

Get the total number of ratings of a product. Includes local and global ratings.

Syntax:

GORILLA_RATINGSCOUNT(Seller ID, sku, [marketplace])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

sku – REQUIRED
SKU or ASIN to filter the results. Can be a range of values like A1:A100 or SKU111, SKU222, SKU333 or ASIN123.

marketplace – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, SE, TR, IN, SE, AU, SG, JP. Use DEFAULT for your market default.

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_RATINGSCOUNT("TOY STORE", "B00YD545CC", "CA")

Returns the review rating for ASIN B00YD545CC for Canadian marketplace.

=GORILLA_RATINGSCOUNT("TOY STORE", 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.

How can we help?