Skip to main content
All CollectionsGoogle Sheets FunctionsMarket Data Plan Functions
GORILLA_REVIEW() – Get full review details of a product

GORILLA_REVIEW() – Get full review details of a product

Updated over a month ago

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_REVIEW("TOY STORE", "B00YD545CC", "US", 5)
=GORILLA_REVIEW("TOY STORE", A2:A10)

Syntax Description

REVIEW Gorilla ROI

Description:

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

Syntax

GORILLA_REVIEW(Seller ID, sku, [marketplace], [count])

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

sku – REQUIRED
SKU or ASIN of the product. Only one accepted.

marketplace – OPTIONAL
​ Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc.

count – OPTIONAL
Number of reviews to retrieve (default value is 5) or “ALL” to retrieve all reviews

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_REVIEW("TOY STORE", "B00YD545CC", "US", 5)

Returns the latest 5 reviews, title, name, link and rating for ASIN B00YD545CC selling in the USA marketplace.

=GORILLA_REVIEW("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. Default marketplace data is returned as no marketplace is set.

Did this answer your question?