Automating AWD Inventory Tracking in Google Sheets: Gain Control Over Amazon Warehousing & Distribution Data
Automating AWD Inventory Tracking in Google Sheets: Get a Grip on Your Amazon Warehousing & Distribution Data
We'll show you how to streamline reconciliation, track fees, and manage inventory seamlessly... right in your spreadsheets.
At Hopted, we get to talk with a lot of Amazon sellers every day, digging into what's working and what's not. And lately, one thing that keeps coming up over and over is Amazon Warehousing & Distribution (AWD).
AWD provides bulk storage, FBA replenishment, and distribution to other sales channels. It is upstream storage, not the same service as fulfilling individual customer orders. (Amazon’s AWD overview)
We typically see sellers turn to AWD when they're hitting FBA capacity limits, dealing with seasonal inventory swings, looking for cheaper long-term storage than FBA rates, or just wanting to automate FBA replenishment to cut down on manual work.
If your Amazon business is in one of these boats, or if you use Amazon's transport services like AGL or PCP , then wrangling your AWD data is probably a major headache for you. The benefits sound great, but actually getting and using the data to manage AWD effectively... that’s a whole other challenge. This is where the need for reliable access to Amazon AWD reports in Google Sheets becomes critical.
Why Is Managing AWD Data Such a Pain?
Look, managing AWD effectively means you have to live in the data from all those Seller Central reports. Amazon gives you the information, but sellers constantly tell us that manually pulling, combining, and analyzing it is a massive time-sink.
And it's not just anoying; it's a real operational drag that can lead to bad decisions. The real problem we've seen is combining AWD information with FBA inventory reports. By the way, that's where Hopted superpower comes in place. Hopted can help you easily merge in a single view AWD, FBA, fees and listing info.
Based on what we're hearing from sellers, here are the hurdles that pop up constantly:
First off, it's incredibly time-consuming. Just the regular process of logging in, bouncing between the AWD Inbound Shipment report, the AWD Inventory Ledger, and all the different fee reports, downloading CSVs, then mashing it all together in a spreadsheet... it just eats up time you could be using to actually grow your business.
Second, the data is all over the place. AWD and FBA data live in separate parts of Seller Central. If you also have your own warehouse or another 3PL, getting a single, clear picture of your total inventory is a nightmare of copy-pasting. Trying to track inventory that's in transit between AWD and FBA, for example, is notoriously difficult with the standard reports.
Third, manual work means mistakes. It's inevitable. Beyond simple copy-paste errors, sellers tell us they run into issues with data just feeling... off. You see discrepancies between different reports, or billing cycles that don't seem to line up with the data. On top of that, the field definitions in the reports aren't always fully documented, so you're left guessing.
And finally, there's reconciliation. This is a big one. Trying to match what you shipped with what Amazon saysthey received, investigating every discrepancy (overages, shortages, damages noted in the Inbound Shipment report ), and tracing adjustments (lost, found, damaged) using the Inventory Ledger... it's vital, but it's messy, especially when you're trying to get reimbursed. Tracking transfers between AWD and FBA (with those "STAR-" IDs ) just adds another layer of complexity.
So, what's the result? You have poor visibility. AWD is supposed to make logistics simpler, but managing the data often requires better part of your day.
Introducing Solution: Automated AWD Data in Google Sheets
At Hopted, we've listened to all these frustrations. We know sellers love Google Sheets—it’s flexible, powerful, and everyone already knows how to use it. We saw a clear opportunity to bridge the gap between AWD's messy operational data and your favorite analysis tool.
So, we built a solution. Hopted now provides automated integration for key Amazon Warehousing & Distribution (AWD) reports directly into Google Sheets!
The useful starting point is a recurring view of inventory and inbound shipments. Hopted connects through Amazon’s SP-API and lets you combine compatible fields with your other reports:
AWD Inventory Levels: Track inbound, on-hand, available, reserved, and replenishment quantities. Add FBA stock from a compatible FBA source; these are refreshed snapshots, not a continuous live feed.
AWD Inbound Shipments: Compare expected and received quantities, shipment status, discrepancy quantities, order references, and carrier details. Check that the quantity units match before comparing totals.
AWD Inventory Ledger: Use Seller Central ledger exports alongside the synced data when investigating past movements. Do not assume the inventory snapshot includes every historical adjustment or a complete claims record.
How It Works
We designed this to be as simple and secure as possible, using the official Amazon Selling Partner API (SP-API).
Connect Securely: Link your Amazon Seller Central account to Hopted. (If you're already a user, you've likely done this. If not, our guided process uses Amazon's own secure login).
Configure Your Sync: Inside Hopted, just go to your Amazon connection settings and pick the specific AWD reports and combinding with other attributes you want to pull in your Google Sheet (e.g., Inventory Levels, Inbound Shipments, FBA fees etc.).
Automated Data Flow: Hopted refreshes the connected sheet on your configured schedule, subject to Amazon’s data availability and API limits.
See our tutorial video below
What You Actually Can Get from This
Your goal is to decide.
Getting your AWD data into Sheets automatically isn't just a small fix; it delivers real, tangible benefits that let you run your operations smarter.
Save a Ton of Time and Make Fewer Mistakes: The most immediate win. You get back all those hours you used to spend downloading and cleaning reports. By automating this, Hopted frees up your team for actual analysis, and it slashes the risk of costly human errors from manual data entry.
See the Whole Picture in One Place: Combine AWD and FBA stock with shipment statuses and your sales or cost data. Keep an eye on in-transit stock so the same units are not counted twice.
Make Reconciliation Easier: Compare expected and received units, then investigate differences using shipment references and Seller Central records. A discrepancy is a starting point for a claim, not proof that Amazon owes a reimbursement.
Plan Replenishment With Better Context: Review AWD, FBA, and in-transit quantities together before planning a top-up. Allow for receiving delays and demand changes; a current stock snapshot cannot guarantee that you will avoid a stockout.
Keep Cost Checks Separate: Compare storage, processing, and transportation charges with Amazon’s current rates and your fee statements. Inventory quantities alone do not establish Smart Storage eligibility or total profitability. (Current AWD rates)
Do More With Your Data in Sheets: This integration puts your AWD data into what is pretty much the most flexible analysis tool on the planet. Build custom dashboards, use complex formulas for your own KPIs, set up conditional formatting alerts (low stock, aging inventory), or even use Google Apps Script for advanced automations. The potential blows away the rigid, canned reports in other platforms.
At the end of the day, Hopted's AWD integration turns all that raw data into intelligence you can actually use to manage your inventory, control your costs, and make better decisions.
Why Amazon + Google Sheets?
There are dedicated inventory platforms too. The practical question is where your team wants to do the daily work.
But our hot take is that you need custom views. A dedicated focus on pulling this data directly into Google Sheets offers some clear advantages, especially for sellers who value flexibility and customization.
Here's the thing: sellers love Google Sheets. It's an open canvas. Unlike rigid platforms that lock you into their predefined reports, Sheets lets you model and visualize your AWD data exactly how your business needs to see it. And our team is there with you to support you in case you stuck and can't build what you've envisioned.
You can build dashboards and plug AWD metrics into existing financial models. Sheets still has size and performance limits, so keep large histories separate from the daily working view.
You can combine AWD data with financials, ad results, COGS, or manual notes when the identifiers and reporting periods line up. Start with a few SKUs and check the joins before trusting the totals.
For so many sellers, Google Sheets is already in place for stuff like reporting or tracking. We strongly believe that by bringing AWD data into this familiar environment, you don't have to learn yet another piece of software. Your team can use its existing expertise right away.
Streamline Those AWD Reports Once, and You Won't Go Back
AWD can be a great strategic tool, but you can only unlock its potential if you master the data.
We built this to cut the recurring download-and-cleanup work. How much time it saves depends on your reporting routine. Start with the report you dread updating most, its usually the best place to see the difference.
We'd love for you to see the difference that automated, reliable data can make. Sometimes the small things helps.