SellerDragon pulls your Amazon Seller Central data straight into Google Sheets with custom functions like =DRAGON_SALES_COUNT(). This guide takes you from nothing to live data in about five minutes.
What you need
- A SellerDragon account with your Amazon store connected – sign up at sellerdragon.com.
- A Google account and a Google Sheet.
1. Install the add-on
Install SellerDragon from the Google Workspace Marketplace (in Sheets: Extensions → Add-ons → Get add-ons, then search for SellerDragon). Once installed it appears under the Extensions menu in every sheet.
2. Connect your account
Open Extensions → SellerDragon → Add/Edit Account ID and paste the Account ID from your SellerDragon dashboard. This links the spreadsheet to your store – you only do it once per spreadsheet.
3. Pull your first data
Type this into any cell (with your account name or id):
Every function fills a range starting at the cell you put it in – headers first row, one row per item.
4. Help is inside the sheet too
=DRAGON_HELP()– the full function reference as a table.=DRAGON_INVENTORY("help")– detailed help for one function (works with every function).
The same reference lives here under Sheet Functions, with parameter and period pages.
5. Good to know
- Parameters are positional – leave one blank to skip it:
=DRAGON_INVENTORY("youraccount", "", "US"). - Optional filters left blank include everything.
- Append
header/transposevalues to any function to control output shape – see any function page. - Filter parameters accept whole lists: a range like
A2:A100, comma-separated values, orINDIRECT(). Chain functions with it – pull your ASINs once with=DRAGON_CATALOG("youraccount")on one tab, then feed that column into other functions:=DRAGON_SALES_COUNT("youraccount", INDIRECT("Catalog!D2:D100"), "", "last_30_days").