Syntax
=DRAGON_INVENTORY(account, [ASIN/SKU], [marketplace], [fulfillment], [period], [disposition], [columns], [header], [transpose])
Parameters in [brackets] are optional. Leave an optional parameter blank to include everything.
This page is also available inside Sheets – type
=DRAGON_INVENTORY("help") in any cell to get the same reference without leaving your spreadsheet.Sample output
Illustrative values – your sheet shows your account's live data.
A1fx
=DRAGON_INVENTORY("Myaccount", "", "US", "FBA", "last_7_days", "total")| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | sku | asin | 2026-07-21 | 2026-07-20 | 2026-07-19 | 2026-07-18 | 2026-07-17 |
| 2 | MB-TEE-BLK-L_FBA | B0EXAMPLE1 | 37 | 54 | 71 | 88 | 105 |
| 3 | MB-TEE-NVY-M_FBA | B0EXAMPLE2 | 68 | 85 | 102 | 22 | 39 |
| 4 | MB-HAT-GRY_FBA | B0EXAMPLE3 | 99 | 116 | 36 | 53 | 70 |
| 5 | MB-MUG-11OZ_FBA | B0EXAMPLE4 | 33 | 50 | 67 | 84 | 101 |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname or Amazon account id. |
| ASIN/SKU | Optional | Optional ASIN, SKU, or comma/space separated list. Also accepts a cell range like A2:A100 or INDIRECT() pointing to a list. |
| marketplace | Optional | Optional marketplace/country code such as US, CA, or MX. |
| fulfillment | Optional | Optional fulfillment filter: FBA or FBM. Default: FBA. |
| period | Optional | Optional period such as last 7 days, last 30 days, or last 90 days. Default: last 7 days. |
| disposition | Optional | Optional inventory disposition: sellable, incoming, reserved, unsellable, available, or total. Default: total. |
| columns | Optional | Optional comma-separated output columns before the date columns. |
| header | Optional | Use no, false, or 0 to suppress the output header row. Default: Yes. |
| transpose | Optional | Use yes, true, or 1 to transpose the output. |
The period accepts values like last_30_days, this_month, 2026Q1, or ranges like 2026-01-01..today – see the full period reference.
Columns
Columns are evaluated left to right: a field or group name adds columns, a leading - removes them. default and all select the default or full column set – for example compact,-marketplace.
| Column | Default | Description |
|---|---|---|
| marketplace | No | Marketplace |
| sku | Yes | SKU |
| asin | Yes | ASIN |
| fnsku | No | FNSKU |
| condition | No | Condition |
| fulfillment | No | Fulfillment |
| status | No | Status |
| per_unit_volume | No | Per unit volume |
| reserved_future_supply_quantity | No | FBA reserved future supply quantity |
Column groups
Groups select several columns at once and combine with single fields in the columns parameter.
compact
Examples
=DRAGON_INVENTORY("Myaccount", "", "US", "FBA", "last 30 days", "total")
=DRAGON_INVENTORY("Myaccount", "", "US", "FBA", "last 30 days", "sellable,incoming", "compact")
Notes
- fulfillment: defaults to FBA. use FBM or FBA,FBM only when those quantities should be included.
- disposition: additive and deduped. accepted values are sellable, incoming, reserved, unsellable, available, total. default is total.
- columns: use compact to show only inventory date columns. default and all are also supported.
- columns are evaluated left to right. A field or group adds columns; prefix with - to remove a field or group.