Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_REVIEWCOUNT() – G...

GORILLA_REVIEWCOUNT() – Get number of reviews of a product


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_REVIEWCOUNT("TOY STORE", "B00YD545CC", "CA")
=GORILLA_REVIEWCOUNT("TOY STORE", A2:A10)

Syntax Description

REVIEWCOUNT Gorilla ROI

Description:

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

Syntax:

GORILLA_REVIEWCOUNT(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.

marketplaceOPTIONAL
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_REVIEWCOUNT("TOY STORE", "B00YD545CC", "CA")

Returns the number of reviews for ASIN B00YD545CC selling in the Canadian marketplace.

=GORILLA_REVIEWCOUNT("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.

REVIEWSCOUNT.2 Gorilla ROI
Tags ,

EBOOKS tO HELP unleash your amazon success

Enter your name and email for the full download package now.

Want SPREADSHEETS CREATED BY 7-Figure AMAZON Sellers?

Enter your name & email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.