Setup takes a few minutes. You connect your Amazon, Shopify, or Walmart account and choose the data you want in Google Sheets. After that, data loads and syncs automatically in the background going forward.
.svg "Gorilla ROI")
4.8 Rating · 11k+ Downloads · Trusted by Sellers
Last updated -
June 10, 2026
Review Summary
✅ Gorilla ROI pulls two AWD inbound reports: the shipment-level view (status, carrier, origin, destination, received quantity) and the item-level view (SKU, ASIN, packaging, dimensions per shipment).
✅ Use the Received Qty field to reconcile what you shipped against what Amazon confirmed receiving. Any discrepancy is a potential reimbursement or carrier claim.
✅ Data refreshes every 3 hours automatically. Gorilla ROI only reads your AWD data — we never write, update, or modify anything in your Amazon account.
Amazon Warehousing and Distribution (AWD) is Amazon's bulk storage and distribution service. Inventory ships to an AWD distribution center first, and Amazon replenishes FBA fulfillment centers from there automatically. Gorilla ROI pulls two AWD inbound reports: the shipment-level view and the item-level view.
What the AWD Inbound Shipments Report Covers
The AWD inbound shipments report gives you a row for every inbound shipment to an AWD distribution center. It covers shipment status, origin and destination addresses, carrier details, and the total quantity received.
This is the report to open when you need to know where a shipment is, whether it has been received, which carrier handled it, and how many units arrived.
AWD Inbound Ship — Fields
Shipment Identification
Dates
Destination (AWD Distribution Center)
Origin (Your Warehouse or Supplier)
Carrier
Quantity
AWD Inbound Ship Item — Fields
The item-level report gives you one row per SKU per shipment. Use it alongside the shipment-level report to see exactly which products are in each inbound order and their physical dimensions per package.
Shipment and Product Identification
Quantity and Packaging
Physical Dimensions
Dates
What Sellers Use This For
Receiving reconciliation. Compare Received Qty against the quantity you shipped. Any discrepancy between what left your warehouse and what Amazon confirmed receiving is a potential reimbursement or carrier claim.
Shipment status tracking. Pull the report on a schedule and filter by Shipment Status to see which AWD inbound orders are still in transit, which are being received, and which are closed.
Carrier performance. Filter by Carrier Code Value and cross-reference with Ship By dates and Received Qty to identify carriers with consistent delays or quantity discrepancies.
3PL and supplier coordination. The Origin fields give you the source address for every shipment. If you use multiple 3PLs or suppliers, you can break down inbound activity by origin location.
How Gorilla ROI Pulls This Data
Gorilla ROI connects to the Amazon SP-API using the listInboundShipments and getInboundShipment operations. Both are read-only. We pull and display your data. We never write, update, or modify anything in your Amazon account.
Data refreshes every 3 hours automatically. No csv exports. No manual downloads. The sheet your team works from is always current.
For field definitions and query setup, see the AWD Inbound Ship documentation and AWD Inbound Ship Item documentation in our help center.
Detailed Reports and Fields
Frequently
Asked Questions
How long does setup take?
How does it get data into Google Sheets?
Gorilla ROI connects directly to your ecommerce platforms and syncs structured data into Google Sheets automatically. Once connected, data stays available without re-downloading files.
What platforms can I connect?
Gorilla ROI supports Amazon, Shopify, and Walmart. The focus is ecommerce operations rather than connecting dozens of unrelated platforms.
Will my data stay accurate and update automatically?
Yes. Once connected, data syncs automatically based on your settings so Sheets stays current without manual exports or re-imports.
Does the data match my platform?
Yes. Gorilla ROI pulls data directly from the source. What you see in your sheet matches what the platform API reports.
Do I need coding or technical skills?
No. Gorilla ROI works through a point-and-click interface inside Google Sheets. Advanced users can use formulas if they want, but coding is not required.
Manual Exports Waste Your Team's Time
Replace the Manual Spreadsheet Work and Save 40 Hours a Month
