Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_INBOUNDSHIP() – Load inbound shipment data

GORILLA_INBOUNDSHIP() – Load inbound shipment data

Sample Usage

=GORILLA_INBOUNDSHIP()
=GORILLA_INBOUNDSHIP("FBA16FZYHNDU", "ALL", 50)
=GORILLA_INBOUNDSHIP(A1:A100, "ALL", 50)

Syntax Description

Description:

Get the full inventory shipment data of the shipments created in the seller central account.

Syntax:

GORILLA_INBOUNDSHIP([SHIPMENTID], [STATUS], [COUNT])

For Gorilla Agency, the syntax is

GORILLA_INBOUNDSHIP(SELLER ID, [SHIPMENTID], [STATUS], [COUNT])

shipmentID – OPTIONAL
FBA Shipment ID filter. Can be a range of values like A1:A100 where A1 to A100 consists of values like “FBA16FV6TKG3, FBA16FV5D2MW, FBA16FLJ360X”

status – OPTIONAL

The shipment status.

Valid values:

  • Closed
  • Receiving
  • Deleted
  • Delivered
  • Shipped
  • In_Transit
  • Canceled
  • All

count – OPTIONAL

The number of shipments to retrieve (default value is 50).

Examples:

Use ranges (e.g.A2:A100) 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_INBOUNDSHIP()

The default and easiest formula to use that will load the last 50 shipments located in your seller central account.

=GORILLA_INBOUNDSHIP("FBA16FZYHNDU", "ALL", 50)

Will output the 50 of the last shipments where the shipment ID is FBA16FZYHNDU

=GORILLA_INBOUNDSHIP(A1:A100, "ALL", 50)

Will output the last 50 shipments where the shipment ID is listed in A1:A100.

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

=GORILLA_INBOUNDSHIP("SELLER ID")
=GORILLA_INBOUNDSHIP("HOME GOODS STORE", "ALL", 50)
=GORILLA_INBOUNDSHIP("MAGIC SELLER", "FBA16FZYHNDU", "ALL", 50)

How can we help?