Google Sheets Functions

⌘K
  1. Home
  2. Docs
  3. Google Sheets Functions
  4. 1.Seller Central Data/Fun...
  5. GORILLA_IMAGES() – Get image URLs of the product and listing

GORILLA_IMAGES() – Get image URLs of the product and listing

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_IMAGES("TOY STORE", "IPHONE7382", "US", "PT01", "MEDIUM")
=IMAGE(GORILLA_IMAGES("TOY STORE", "IPHONE7382", "US", , "MAIN"))
=GORILLA_IMAGES("TOY STORE", A10:A30, "US", "PT08", "MEDIUM")

Syntax Description

image 25 Gorilla ROI

Description:

Get product listing image URLs to convert to image inside the spreadsheet. Main images as well as secondary images in different sizes.

Syntax:

GORILLA_IMAGES(sellerId, sku, [marketplace], [variant], [size])

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

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

MARKETPLACE – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP, EG, SA. Use DEFAULT for seller default.

VARIANT – OPTIONAL
Image variation to retrieve. Valid values are:

  • MAIN (default value if input is empty)
  • PT01
  • PT02
  • PT03
  • PT04
  • PT05
  • PT06
  • PT07
  • PT08

SIZE – OPTIONAL
Size of image URL returned.

Valid values are:

  • small (75 x 75 px)
  • medium (200 x 200 px. This is the default value if input is empty.)
  • large (500 x 500 px)

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_IMAGES("TOY STORE", "IPHONE7382", "US", "PT01", "MEDIUM")

This formula will pull the URL for secondary picture # 1 (not the MAIN) of SKU IPHONE7382 from the US marketplace. You can then combine it with the regular IMAGE( ) to display it as an image.

=IMAGE(GORILLA_IMAGES("TOY STORE", "IPHONE7382", "US", "MAIN"))

This formula will pull the URL for the MAIN picture of SKU IPHONE7382 from the US marketplace. You can then combine it with the regular IMAGE( ) to display it as an image. Medium (default) size will be pulled since we did not define that.

=GORILLA_IMAGES("TOY STORE", A10:A30, "US", "PT08", "MEDIUM")

Supports 2-dimensional ranges. Bulk returns an array of values by assigning the range of the SKU/ASIN. In this example, the SKU or ASIN is listed in A2:A30 and returns picture # 8 for all at once. Marketplace is US and Size is Medium

Tags