Google Sheets Functions

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

GORILLA_SKULIST() – Get a list of SKU’s from your marketplace

Sample Usage


Syntax Description

bulk return list of skus in your account
Return a list of active and inactive SKU’s from your marketplace(s).

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

Gorilla Agency, the syntax is

GORILLA_SKULIST(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 SKU to filter result. The filter will act only at the start of the SKU. If there multiple SKU’s like 54145484, 5414345, 54145FD5, you can search for 5414* to list all SKU’s starting with 5414.


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


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.


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


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

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


Lists all SKU’s that start with the phrase “IPHONE” listed on the UK marketplace. You can enter any text string to use as a filter.


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?