Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. GORILLA_INBOUNDSHIP() ...

GORILLA_INBOUNDSHIP() – Load inbound shipment data

Sample Usage

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

Syntax Description

INBOUNDSHIP and INBOUNDSHIPITEMS 1 Gorilla ROI

Description:

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

Syntax:

🚨 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_INBOUNDSHIP(Seller ID, [SHIPMENTID], [STATUS], [COUNT], [PERIOD], [START_DATE], [END_DATE])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

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).

period – OPTIONAL
Predefined period to get returns or use ‘custom’ to specify a start and end date. Default “Last 60 days”.

start_date – OPTIONAL
Ending date for the returning range when period is ‘custom’.

end_date – OPTIONAL
Starting date for the returning range when period is ‘custom’.

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_INBOUNDSHIP("TOY STORE")

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

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

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

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

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

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