Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_INVENTORY() – Get quantity and status of inventory

GORILLA_INVENTORY() – Get quantity and status of inventory

Sample Usage

=GORILLA_INVENTORY(D2, "ALL", "instock")
=GORILLA_INVENTORY("B00YD545CC", "UK", "transfer")
=GORILLA_INVENTORY(A2:A10, "ALL", "inbound")

Syntax Description

GORILLA_INVENTORY() – Get quantity and status of inventory 1
Get inventory movement status of a product such as how many
is in stock, transfer or inbound.

GORILLA_INVENTORY(sku, [marketplace], [status])

Gorilla Agency, the syntax is

GORILLA_INVENTORY(sellerID,sku, [marketplace], [status])


SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.


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 – Supply status. Valid values are:

  • All
  • InStock
  • Inbound
  • Transfer


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_INVENTORY(D2, "ALL", "instock")

Uses the ASIN or SKU entered in cell D2 and shows the total number of instock units across all marketplaces.

=GORILLA_INVENTORY("B00YD545CC", "UK", "transfer")

Gets the total number of units for ASIN B00YD545CC that are in transfer status for Italy marketplace.

=GORILLA_INVENTORY(A2:A10, "ALL", "inbound")

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU. 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.


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


Check inventory values in UK marketplace

What you will see when using this is how Amazon provides inventory numbers across marketplaces.

For example, if you have 100 units in Germany, it is technically available in DE, UK, ES, FR, IT.

So Amazon enters your inventory as 100×5 = 500 inventory available.

So to get the number you want only for Germany, you have to enter the formula to be specific for the marketplace.


In any spreadsheet, try


And you will see the numbers for each marketplace.

We use the API, not the reports and so we use the data Amazon provides us. You just have to use more detail in the formula to get what you need for UK marketplace.


  • All
  • InStock
  • Inbound
  • Transfer

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?