Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_REVIEW() – Get full review details of a product

GORILLA_REVIEW() – Get full review details of a product

Sample Usage

=GORILLA_REVIEW("B00YD545CC", "US", 5)
=GORILLA_REVIEW(A2:A10, ,)

Syntax 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”.

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

Gorilla Agency, the syntax is

GORILLA_REVIEWCOUNT(sellerID, sku, [marketplace])

SKU

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. or Amazon Marketplace ID like ATVPDKIKX0DER.

COUNT

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

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

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

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

review count

For Gorilla Agency, the formulas will start with the seller ID:

=GORILLA_REVIEWCOUNT("SELLER ID", "B00YD545CC", "CA")
=GORILLA_REVIEWCOUNT("SELLER ID", A2:A10, ,)

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?