Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_RATINGSCOUNT() – Get number of ratings for product

GORILLA_RATINGSCOUNT() – Get number of ratings for product

Sample Usage

=GORILLA_RATINGSCOUNT(“B00YD545CC”, “CA”)
=GORILLA_RATINGSCOUNT(A2:A10, ,)

Syntax Description

Description:

Get the total number of ratings of a product. Includes local and global ratings.

Syntax:

GORILLA_RATINGSCOUNT(sku, [marketplace])

for Gorilla AGENCY, the syntax is

GORILLA_RATINGSCOUNT(sellerID, sku, [marketplace])

sku – REQUIRED

SKU or ASIN to filter the results. Can be a range of values like A1:A100 or SKU111, SKU222, SKU333 or ASIN123.

marketplace – OPTIONAL

OPTIONAL – Marketplace country filter. Country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, SE, TR, IN, SE, AU, SG, JP. Use DEFAULT for your market default. Amazon Marketplace ID like ATVPDKIKX0DER can be used too.

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_RATINGSCOUNT(“B00YD545CC”, “CA”)

Returns the review rating for ASIN B00YD545CC for Canadian marketplace.

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

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

=GORILLA_RATINGSCOUNT(“SELLERID38”, “B00YD545CC”, “CA”)
=GORILLA_RATINGSCOUNT(“SELLERID38”, 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?