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).
It was introduced as this big solution for logistics, and it does offer potential perks: lower-cost bulk storage, a way around FBA capacity limits, automated replenishment, and even multi-channel fulfillment.
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!
This new feature is built specifically to kill the manual effort but even more data fragmentation. Hopted sets up a direct, secure connection (via the SP-API) to pull the essential data points you actually rely on, including:
AWD Inventory Levels: Get near real-time data on units Available in AWD, Inbound to AWD, In transit to FBA, and Available in FBA, plus crucial metrics like Replenishment Status and fee eligibility.
AWD Inbound Shipments: Pull detailed info from the AWD Inbound Shipment report, including shipment status, expected vs. received quantities, discrepancy details (problem type/quantity), PO IDs, and carrier info.
AWD Inventory Ledger: Track every historical inventory move with data from the Inventory Ledger report—Received, Departed, Lost, Found, and Damaged—complete with the reference IDs you need for reconciliation and claims.
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 handles the rest. Our system automatically fetches the data on the schedule Amazon provides and drops it right into your connected Google Sheet in designated tabs.
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: We break down those data walls. Now you can see your AWD inventory, FBA stock, in-transit units, shipment statuses, and fee breakdowns right next to your other business data (sales, ads, COGS) in a single Google Sheet. This unified view is how you get a true understanding of your inventory and costs.
Finally Make Reconciliation Easy: We hear it all the time: reconciliation is one of the worst parts of managing FBA and AWD. With Hopted, having inbound shipment details (expected vs. received), ledger adjustments, and fee breakdowns automatically organized in Sheets makes this process so much simpler. You can spot discrepancies fast, track movements, verify charges, and get the data you need for reimbursement claims.
Manage Your Inventory and Replenishment Smarter: You can't manage inventory well without good, timely data. Hopted gives you that clear picture of stock across the entire network—Available in AWD, Inbound into AWD, In transit to FBA, and Available in FBA. You can use this reliable data to confidently manage your auto-replenishment settings, trigger manual top-ups, or plan new inbound shipments to AWD, helping you prevent stockouts and avoid overage fees.
Track Your Costs and Profitability Accurately: Let's be honest, the AWD fee structure is confusing. You've got separate fees for storage, processing (inbound/outbound), and transportation. Hopted pulls this detailed fee data into Sheets, so you can finally do precise, SKU-level profitability calculations. And this is key: you can monitor the performance metrics (like auto-replenishment ratio and historical days of supply) needed to confirm you're eligible for discounted rates (like Smart Storage) or fee waivers. Simply using AWD doesn't guarantee the savings; you need the data to verify it.
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?
Look, we know there are other big inventory management platforms out there like InventoryLab, and many are adding AWD data.
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 your own dashboards, apply unique formulas, and plug your AWD metrics into your existing financial models without any platform limitations. Hopted just delivers the clean, reliable data where you can actually use it.
You can go a step further and merge your live AWD data with literally any other dataset that describes your Amazon store -- financials, ad campaign results, COGS, or your own manual info. This is how you get deep, cross-functional insights that are almost impossible to get in siloed apps and with fragmented CSVs.
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 because sellers like you can get back 7-9 hours a moonth. It's a good ROI, in my opinion. A few hours here and there, and you end up with and extra few days that free up.
We'd love for you to see the difference that automated, reliable data can make.
Authors
Alex Borisenko-Markovich