GORILLA_REVIEW( ) Function
Get the full reviews and details of a product based on SKU or ASIN. Only works for single marketplaces at a time. Not “ALL”.
GORILLA_REVIEW(sku, [marketplace], [count])
SKU or ASIN of the product. Only one accepted.
OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
OPTIONAL – Number of reviews to retrieve (default value is 5) or “ALL” to retrieve all reviews
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_REVIEW(“B00YD545CC”, “US”, 5)
Returns the latest 5 reviews, title, name, link and rating for ASIN B00YD545CC selling in the USA 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. Default marketplace data is returned as no marketplace is set.