1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_RATINGS() – Get average review rating for product

GORILLA_RATINGS() – Get average review rating for product

GORILLA_RATINGS( ) Function

Description:
Get the average review rating of a product. Only works for single marketplaces at a time. Not “ALL”.

Syntax:
GORILLA_RATINGS(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:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_RATINGS(“B00YD545CC”, “CA”)
Returns the review rating for ASIN B00YD545CC for Canadian marketplace.

=GORILLA_RATINGS(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.

Was this article helpful to you? Yes No

How can we help?