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
Description:
Get product and listing image URLs.
Syntax:
GORILLA_IMAGES(sellerId, sku, [marketplace], [variant], [size], [fulfillment])
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, BE, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP, EG, SA. Use ‘DEFAULT’ for seller default. Amazon Marketplace ID like ‘ATVPDKIKX0DER’ can be used too.
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)
FULFILLMENT – OPTIONAL
‘ALL’ shows any SKU matching the search criteria. ‘FBM’ displays fulfilled by merchant SKU’s only. ‘FBA’ displays fulfilled by Amazon SKU’s only. Default is set to ‘ALL’.
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