GORILLA_RATINGS() – Get average review rating for product
Only up to 500 products are updated at a time (in batches). Refreshes are done every 4 days.
We have disabled the function because Amazon is currently not sharing review information.
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_RATINGS("TOY STORE", "B00YD545CC", "CA")=GORILLA_RATINGS("TOY STORE", A2:A10)Syntax description
Description:
Get the average review rating of a product. Only works for single marketplaces at a time. Not “ALL”.
Syntax:
GORILLA_RATINGS(Seller ID, sku, [marketplace])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
sku – REQUIRED
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.
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_RATINGS("TOY STORE", "B00YD545CC", "CA")Returns the review rating for ASIN B00YD545CC for Canadian marketplace.
=GORILLA_RATINGS("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.
