NO SIGN UP REQUIRED

Test Drive Our Demo Account

Uncertain about connecting your Amazon account? Play with our fully functional demo account.

  1. Save a copy of this free sales spreadsheet template to your G Drive.
  2. Keep the spreadsheet open.
  3. Install the Gorilla ROI Google Sheets addon from Google marketplace.
gorilla roi addon store Gorilla ROI
  1. Activate it by
    • Menu -> Addons -> our Amazon Seller addon -> Use this addon
  2. Add the user ID
    • Menu -> Addons -> our Amazon Seller addon -> Add Subscription ID
  3. Enter b1fe496a-3865-5908-ac4c-610a2efe2c49 in the text box.
  4. Save -> the addon is now activated.
  5. If the save button does not do anything, redo this stage in incognito mode to start fresh because Google is caching your G Drive.
save test seller user id Gorilla ROI
  1. Now that the addon is activated, test the formulas in the free spreadsheet you copied in Part 1.
  2. Open up the tab “SALES_STATS“.
  3. Menu -> Addons -> our Amazon Seller addon -> Refresh data
  • Data will start to update and load automatically in the spreadsheet
  • Play around with the formulas to pull in different types of data and time periods.
    • Create a new tab and enter in a blank cell
    • =GORILLA_ASINLIST()
    • =GORILLA_SKULIST()
    • =GORILLA_SALESCOUNT(“THIS YEAR”)
    • =GORILLA_REFUNDSTOTAL(“last month”)

Option 2: Test in a new blank spreadsheet

  1. Create a new spreadsheet or use this shortcut link
  2. Extensions > Our Amazon addon > Use this addon
  3. Extensions > Our Amazon addon > Add ID
  4. Enter your ID from your Gorilla ROI account
  5. Save (if it doesn’t save, do it in incognito mode)
  6. In any cell type in =GORILLA_SKULIST(“your store nickname”) or =GORILLA_ASINLIST(“your store nickname”). Use the nickname you saved in your seller accounts.
    • This formula will load the full list of SKUs or ASINs.
    • Here are some easy formulas you can use. Copy these into another cell.
    • =GORILLA_SKULIST(“store nickname”)
    • =GORILLA_ASINLIST(“store nickname”)
    • =GORILLA_SALESCOUNT(“store nickname”, “this year”)
    • =GORILLA_SALESTOTAL(“store nickname”, “last month”)
    • =GORILLA_FEETYPE(“store nickname”)
    • =GORILLA_CHARGETYPE(“store nickname”)
  7. For detailed examples, videos and more functions, go to the full list of formulas. More examples & videos.
  1. Save this training spreadsheet to your G Drive.
  2. Follow the instructions from section 1 & 2 to install and activate the addon as needed.
  3. Reload the spreadsheet (press F5) or
    • menu -> Addons -> Single Seller Amazon -> Refresh data on current sheet
  4. Follow the training in the spreadsheet to become a superstar.
training spreadsheet screenshot Gorilla ROI

View our Amazon templates

Pre-built templates to copy to your account. Save time instead of recreating the wheel. Use ours and get started right away.