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
What This Report Covers
✅ AWD inbound shipment items give you one row per SKU per shipment — showing the exact products, quantities, packaging type, and prep category inside each AWD inbound order.
✅ Physical dimensions (height, length, width, weight) are included per package, giving you the data to verify Amazon's size tier assignments and storage fee calculations.
✅ The shipmentId field links every item row back to the parent shipment in the AWD Inbound Shipments report for full cross-reference.
The AWD Inbound Shipment Items report gives you one row per SKU per AWD inbound shipment. Use it alongside the AWD Inbound Shipments report to see exactly which products are in each inbound order, how they are packaged, and their physical dimensions.
Supported Fields
What Sellers Use This For
Packaging verification. Check the type field to confirm whether each SKU is shipping as a case or pallet, and flag any mismatches against what you arranged with your supplier or 3PL.
Prep compliance. The prepCategory field shows what Amazon requires for each item. Use it to audit whether your prep instructions to the warehouse match what Amazon has on record.
Dimensions audit. Cross-reference height, length, width, and weight against Amazon's size tier assignments to verify storage fees are being calculated correctly.
Shipment cross-reference. Use shipmentId to join item rows back to the parent shipment in the AWD Inbound Shipments report and see the full picture for any inbound order.
How Gorilla ROI Pulls This Data
Gorilla ROI connects to the Amazon SP-API using the getInboundShipment operation. Data updates automatically on a regular schedule. No csv exports. No manual downloads. The numbers are current the moment you open the sheet. Feed AI with our data to stay on top and ahead of your business.
For field definitions and query setup, see the AWD Inbound Ship Item documentation in our help center.
See also: AWD Inbound Shipments
Other Reports and Supported 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
