Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_ASINLIST() – Get list of ASIN’s from your marketplace

GORILLA_ASINLIST() – Get list of ASIN’s from your marketplace

Sample Usage


Syntax description

GORILLA_ASINLIST() – Get list of ASIN’s from your marketplace 1
Return a list of active and inactive ASIN’s from your marketplace(s).

GORILLA_ASINLIST([marketplace], [filter_sku], [inactive])

for Gorilla Agency, the syntax is

Gorilla_ASINLIST(sellerID, [marketplace], [filter_sku], [inactive])


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.


OPTIONAL – Part of an ASIN to filter result. The filter will act only on the start of the ASIN like ASINPART*.


OPTIONAL – Enter “include” or “exclude” to show or hide inactive, deleted, closed, suppressed products.



Use closed 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.


If no attributes are entered, it will list all your current active and inactive ASIN from all marketplaces.


Lists all ASIN’s from all marketplaces where the ASIN starts with “B43”



This will list the entire list of ASINs in your account including all the deleted, inactive, closed, suppressed products.

If no inputs are entered like GORILLA_ASINLIST(), the default value is “EXCLUDE”.


This will list all SKUs for the US marketplace only. Will also show closed, inactive, deleted, suppressed SKUs.

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


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?