Help Center · Getting Started

Getting Started

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 Sheets™ spreadsheet.

1. Install the add-on

Install SellerDragon from the Google Workspace™ Marketplace, or from inside Google 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 → Connect Account and paste your account key – you find it in your SellerDragon dashboard under Sheets. This links the spreadsheet to your store; you only do it once per spreadsheet. Keep the key private.

While you're there, set Extensions → SellerDragon → Default Marketplace (for example US). Functions that work on one marketplace use it whenever you leave the marketplace blank.

3. Build your first report – no formulas needed

Open Extensions → SellerDragon → Formula Builder. Pick a function such as DRAGON_SALES_TOTALS, choose your account, marketplace and period, and the builder shows the formula your choices produce. Click an empty cell with room for the results, then insert it as a live formula (updates on every refresh) or as static values (the report definition stays saved in the sidebar, so you can refresh it later).

The builder's Formulas tab lists the live formulas on the current tab and the saved static reports across the workbook, so you can jump to, edit or refresh any of them.

4. Or type a formula yourself

Mystore stands for your Amazon account's name – the alias you gave your Amazon account when you connected it to SellerDragon. You find it under Settings → Amazon Connections in your dashboard. Have only one Amazon account? Then you can leave it empty: =DRAGON_LISTINGS("") works just the same.

=DRAGON_LISTINGS("Mystore")
Your listings: ASIN, SKU, title, fulfillment, brand, status.
=DRAGON_SALES_COUNT("Mystore", "", "US", "", "last 30 days")
Units sold per product in the US over the last 30 days.

Every function fills a range starting at the cell you put it in – headers in the first row, one row per item.

5. 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 all parameters and period formats on the Reference page.

6. Good to know

  • Parameters are positional – leave one blank ("" or empty) to skip it: =DRAGON_INVENTORY("Mystore", "", "US",,).
  • Optional filters left blank include everything.
  • Most functions end with header and transpose options to control the output shape – see any function page.
  • Filter parameters accept whole lists: values separated by ;, a range like A2:A100, or INDIRECT(). Chain functions with it – pull your ASINs once with =DRAGON_CATALOG("Mystore") on a tab named Catalog, then feed its ASIN column into other functions: =DRAGON_SALES_COUNT("Mystore", INDIRECT("Catalog!B2:B100"), "US", "", "last 30 days").