NO SIGN UP REQUIRED
Test Drive Our Demo Account
Uncertain about connecting your Amazon account? Play with our fully functional demo account.
- Install the Gorilla ROI Google Sheets addon from Google marketplace.
- Save a copy of this free sales spreadsheet template to your G Drive.
- Keep the spreadsheet open.
- Activate it by
- Extensions -> our Amazon Seller addon -> Use this addon
- Add the Subscription ID
- Extensions -> our Amazon Seller addon -> Add Subscription ID
- Enter b1fe496a-3865-5908-ac4c-610a2efe2c49 in the text box.
- Save -> The addon is now activated. It shall not take more than a few seconds for the prompt to disappear.
- If the save button does not do anything, redo this stage in incognito mode to start fresh because Google is caching your G Drive.
- Now that the addon is activated, test the formulas in the free spreadsheet you copied in Part 1.
- Open up the tab “SALES_STATS“.
- Extensions -> our Amazon Seller addon -> Refresh Dynamic Formulas -> Refresh Current Sheet
- 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(“TESTSELLER”)
- =GORILLA_SKULIST(“TESTSELLER”)
- =GORILLA_SALESCOUNT(“TESTSELLER”, “THIS YEAR”)
- =GORILLA_PRODUCT(“TESTSELLER”, “PAC00-14234”, “BULLETS”)
Option 2: Test in a new blank spreadsheet
- Create a new spreadsheet or use this shortcut link
- Extensions > Our Amazon addon > Use this addon
- Extensions > Our Amazon addon > Add Subscription ID
- Enter our Demo Subscription ID mentioned above
- Save (if it doesn’t save, do it in incognito mode)
- In any cell type in
- =GORILLA_ASINLIST(“TESTSELLER”)
- =GORILLA_SKULIST(“TESTSELLER”)
- =GORILLA_SALESCOUNT(“TESTSELLER”, “THIS YEAR”)
- =GORILLA_PRODUCT(“TESTSELLER”, “PAC00-14234”, “BULLETS”)
For detailed examples, videos and more functions, go to the full list of formulas. More examples & videos.
- Save this training spreadsheet to your G Drive.
- Follow the instructions from section 1 & 2 to install and activate the addon as needed.
- Reload the spreadsheet (press F5) or
- menu -> Extensions -> our Amazon Seller addon -> Refresh Dynamic Formulas -> Refresh Current Sheet
- Follow the training in the spreadsheet to become a superstar.
Google Marketplace Reviews
There is a lot of different software out there for Amazon data. Gorilla ROI is the only one that gives you the data directly so you can work with it any way you want instead of pre-programmed reports.
Google Review
Amazon Seller
Gorilla ROI has enabled me to build my dashboard for tracking things that are important to me, and it has significantly cut down on manual data extraction that I needed to track a product’s performance.
Google Review
Amazon Seller
I have tried a few other software to get a grip on my numbers but always found it limited. That was until I came across GorillaROI. I can design spreadsheets any way I like and this works for my business perfectly.
Pierre Noziere
Amazon Seller
We were generating/copying/pasting tons of reports from Seller Central to calculate our FBA inventory replenishments. Now all the data is pre-filled with current data.
Eric Eichhorn
Amazon Seller
Data automation at its finest. I run a 2 million dollar business with 2 employees. Tools like Gorilla allow me to do it.
Woodies
Amazon Seller
Gorilla is amazing. Highly recommended. Especially if you’re looking for accurate snapshots of how your business is doing.
BUBS Natural
Amazon Seller
The tool I developed inexpensively stopped working after 5 months so I was pulling reports manually, which takes longer and doesn’t always have all the complete data I need.
Tyler Harris
Amazon, Ebay, Etsy Seller
Great software to take control of your sales and inventory in your own hands. You can build your own report for your specific needs and change /customize them when and as needed.Â
Hades Mcr
Amazon Seller
Ready to unlock the power of your Amazon data?
Reduce operating costs, scale easier and automatically sync your Amazon data to Google Sheets 24/7