Gorilla ROI is for Amazon sellers and agencies to load Amazon data inside Google Sheets
Google Sheets addon for Amazon sellers
Connect Amazon Seller Central and Google Sheets to create flexible, custom reports that fit your business needs
Get direct access to Amazon data without manually pulling reports.
No sign-up required for self demo
Stop working for data. Let data work for you.
Skip the manual data extraction. Data updated and ready for your analysis when you open your spreadsheets.
How most Amazon businesses operate today
You have a lot on your plate as an Amazon FBA seller.
From managing listings, researching keywords, analyzing ad spend, creating better images and trying to stay on top of your inventory planning so that best sellers don’t go out of stock.
This is just some of the pain points you deal with and your to-do list never gets shorter.
Whether you are an operator, a partner or a manager, your time is precious. Long, tedious, and low-value tasks are your enemy. Your time should be allocated to activities with high ROI.
But you are bogged down with trivial tasks.
You could delegate this type of work to an assistant, but you still have to go through the trouble of hiring, training and reviewing the whole process.
Worst of all, you think to yourself: “I might as well do it myself .“
Inefficiency, errors and waste result in:
“Manual data updates that took hours is now automatic and on autopilot.”
THE OLD WAY
THE NEW WAY
Typical Amazon data collection vs using Gorilla ROI to get data
Your business needs to run efficiently to maximize margins because Amazon takes so much.
Imagine what you can do by saving five hours a week. That’s a full 20 hours a month. A major time investment.
Data entry might seem like a trivial task, but you only realize how much time it takes once you stop doing it manually.
Instead of worrying about managing people and constantly reviewing their work, you could focus on tasks that get your business results such as:
What is Gorilla ROI used for?
Auto feed data into existing spreadsheets
Automatically feed data into your existing spreadsheets and models without any code. If you like your spreadsheets, why not supercharge them with automation?
Create profit and loss statements
Ditch transaction reports and recreating reports in excel. Load your fees and charges automatically by day, month, quarter, year and more.
In-house warehouse management system
Most warehouse and inventory systems are overkill for small to medium businesses. Keep it simple and track your data and products by pulling data into G-Sheets.
Gorilla ROI integrates Amazon Seller Central with Google Sheets
Once you start automating and streamlining your workflow to automatically load the latest data into your spreadsheets, it becomes one of those “why didn’t I do this sooner?” moments.
By integrating Amazon Seller Central with Google Sheets, you can automatically import your seller data into Google Sheets and automate multiple aspects of your workflow for you and your team.
Gorilla ROI saves you the trouble that comes with data input and processing.
“Saves us so much time and gives us insight on how to quickly modify our Amazon strategy”
Why you’ll love using Gorilla ROI
“If you are spending more time managing your business than actually getting work done, check out Gorilla ROI.”
How Gorilla ROI works
Gorilla ROI is a Google Sheets addon. Once enabled, it works just like any Google Sheet or Excel formula.
Gorilla ROI offers a large set of functions that will retrieve the data from your seller account. Automate your current spreadsheets and models. Or use our included templates.
No bloat. 100% flexibility.
Your current knowledge of Google Sheets will be enough for you to enjoy all the functionalities of Gorilla ROI.
A look at one of the Gorilla ROI Google Functions
Description:
Return a list of active and inactive ASIN’s from your marketplace(s).
Syntax:
GORILLA_ASINLIST([marketplace], [filter_sku])
Examples:
=GORILLA_ASINLIST()
If no attributes are entered, it will list all your current active and inactive ASIN’s from all marketplaces.
=GORILLA_ASINLIST(“US”,”B43″)
Lists all ASIN’s from US marketplace only where the ASIN starts with “B43”.
3 easy wins using Gorilla ROI today
1. Get to know your best and worst SKUs up close
Create this dashboard with a mix of =GORILLA_SKUASIN(), =GORILLA_SALESCOUNT() and =GORILLA_PRODUCT()
2. Stop going out of stock and losing money and rank
Import real time inventory data with =GORILLA_INVENTORY()
3. Understand your sales and growth patterns
Get this data with =GORILLA_SALESTOTAL() and =GORILLA_SALESCOUNT()
Who is Gorilla ROI for?
Good Fit Users
Bad Fit Users
Are you an agency, consultant or company that manages 3 or more seller accounts?
You qualify for Gorilla Agency.
FREE pre-made templates included
Pre-made Google Sheets are included for free when you sign up.
AMAZON PROFIT LOSS SPREADSHEET
Calculate your Amazon profit and loss accurately by automatically pulling your transactions into this template. Categorized into income and expenses so you get the true P&L of your SKU and account.
PROFIT & INVENTORY DASHBOARD REPORT (NEW)
A simple way to track your inventory and profit on Amazon. Select a SKU and get a quick overview of your profits and inventory status.
SALES PERFORMANCE REPORT
See top sellers, BSR rank, how much sales has been generated per product and how many units have been sold over various time periods with ease.
SALES PROFIT DASHBOARD REPORT (NEW)
A simple high level sales report overview of your Amazon product. Select a SKU and marketplace and it will load your sales stats and key performance indicators.
INVENTORY REPLENISH REPORT
Track and manage your inventory based on sales velocity. Get a clear, accurate and timely update on your stock to stay on top of your business and avoid stock out.
FINANCES BREAKDOWN OF FEES & CHARGES
Pull in your finances related to all sales, charges and fees associated with your account and products.
Contains over 50 preset periods to compare and analyze the performance of your business.
PRODUCT DETAILS SPREADSHEET
Keep an eye on product stats like title, rank, review count, review rating and more.
Quickly identify if something was changed without your permission.
GET STARTED TRAINING SPREADSHEET
A simple step by step tutorial to the basics of using Gorilla Sheets. Custom function examples and more.
Reduce your learning curve if you are learning spreadsheets.
Single Seller Account Pricing (pay what you use)
Best for smaller or single Amazon seller account
Single Seller Account Plan Upgrades
PRO Spreadsheet Package
- One time payment. Lifetime updates.
- Pre-made and ready to use dashboards, calculators, Chinese to English agreements and more.
- Save money and time. Created by spreadsheet masters and nerds that have mastered the art of spreadsheets, design and usability.
1YR Total Support Package
- Includes PRO spreadsheet package.
- Includes set up service, 1 year support and warranty.
- Blazing fast support over email, chat or video.
- Mess things up? We’ll get you back on track.
- Not advanced with sheets? We’ll walk you through.
CUSTOM Work Package
Custom Work Package by Spreadsheet Nerds
- INCLUDES 10 hours of work.
- Additional hours billed at $130/hr.
- We are Amazon + spreadsheet + design specialists.
- We take you step by step through the entire process.
For basic integration to existing sheets, select the Total Support Package above.
30 days no questions asked
MONEY BACK GUARANTEE
If Gorilla does not return an ROI, cancel anytime. What have you got to lose?
Don’t take our word for it.
Google marketplace reviews showing what changed for the better with Gorilla ROI
As my FBA is growing I have tried a few other software to get a grip on my numbers but always found their potential too limited… that was until I came across GorillaROI. I can design now the spreadsheets any way I like and this works for me/my business perfectly.
Pierre Noziere – Amazon Seller
The add-in makes the updates that used to take hours, automatic, and therefore requires almost no time and effort. The templates that come with the subscription are great time savers for those who do not want or do not have the bandwidth to create their own and need a plug and play solution.
I highly recommend it!
Leszek Lekstan – Amazon Agency
Amazing app. Wish I had this 5 years ago.
Colin – 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 the moment we open the sheet.
Eric Eichhorn – Amazon Seller
Been looking for something like this for ages to get rid of all the manual work we were doing to update our accounts. We can update reports for clients much quicker and look brilliant for being able to give clients what they want, so quickly.
Margaret Landon – Amazon Agency
This has made analyzing store activity so much easier! There’s no reason to rely on Excel Sheets that are only as current as your latest export.
Trent Guyer – Amazon Seller
Great product. I use it to monitor my category ranking. If you have many ASINs it’s the only way to keep track of it.
Google Marketplace Review – Amazon Seller
Great software which allows you to take control of your sales and inventory in your own hands. You can build your own reports for your specific needs and change/customize them when and as needed. Or you can use provided pre-designed plug-and-play reports. It does require you to be a bit more tech savvy, than users of other apps, but after you learned how it works, the benefits you’ll get will be unmatched by any other software.
Hades Mcr – Amazon Seller
Works great. Can load seller central data directly. SO much flexibility with what you can build if you have the data.
Google Marketplace Review – Amazon Seller
We have used the tools to rewrite pretty much all of our business management sheets – replacing our screen scraping and manual processes with GorillaROI addins. The addins themselves are well documented and are easy to use and the example sheets provided (the free ones it comes with) accelerate understanding and allowed us to get running very quickly.
Gareth Stagemen – Amazon Seller
Data automation at it’s finest. I run a 2 million dollar business with 2 employees. Tools like Gorilla allow me to do it.
Cory Stout – Amazon Seller
Love using Gorilla – quickened my analysis time and I can easily manage my costs across all my products.
Google Marketplace Review – Amazon Seller
Gorilla is amazing. I highly recommend it. Especially, if you’re looking for accurate snapshots of how your business is doing.
BUBS Natural – Amazon Seller
It saves us so much time and gives us insights on how to quickly modify our Amazon strategy on the fly. I recommend Gorilla ROI to anyone with an amazon FBA business.
Google Marketplace Review – Amazon Seller
Gorilla ROI has enabled me to build my own dashboard for tracking things that are important to me, and it has significantly cut down on the manual data extraction that I previously needed to track a products performance. Highly recommend!
Google Marketplace Review – Amazon Seller
Not only a time saver tool that gets my Amazon data ready to use in google sheets, you also get ready-to-use sheets to start working with.
The customization you can do in the reports with no effort is limitless.
Google Marketplace Review – Amazon Seller
Amazing app. There are a lot of different software out there for Amazon data, but this is the only one I have found that gives you the data directly so you can work with it any way you want instead of pre-programmed reports and charts. It is also very reasonably priced.
Google Marketplace Review – Amazon Seller
Huge time saver! Got great support from the onboarding team – the app is giving us exactly what we need to better run our business. Would highly recommend!
Google Marketplace Review – Amazon Seller
Superb product. We use a lot of software to pull in sales/financial data from Amazon. They all lack the flexibility of Gorilla ROI. A great product that allows us to do custom reports on the fly.
John Bond – Amazon Seller
I was looking to make my own reports the way I want and filter them the way I want and other software simply did not allow me to have as much flexibility as this does. Also I have multiple investors who invested in their own brands from my account and I can give them limited visibility to sales.
Google Marketplace Review – Amazon Seller
I am able to pull data from all my clients and use a template to generate documents weekly.
Wes Beckman – Amazon Agency
Now I get my sales data for top sellers nice and concise inside a single spreadsheet.
Dylan Young – FBA Seller
Love this add-on!
I can create my own reports, the way I want.
Google Marketplace Review – 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. Now I can pull product price, shipping price, ratings, and review count data from Amazon, for each of the 3600 ASINs I have.
Tyler Harris – Amazon, Ebay, Etsy Seller
I have looked at many inventory apps, but they are costly and heavy to learn. I decided to build my own at zoho creator but I didn’t want to learn their scripting language. Then I found you and I can pull FBA gorilla data into my appsheets business app directly from google sheets.
Pecanshop.com – Amazon, Wholesale, Shopify Seller
We found Gorilla ROI because we were looking for a way to automate our Amazon sales into a spreadsheet. We want to track our sales to see trends and also better track our profit.
Chase Crawford – FBA Seller
Frequently Asked Questions
Gorilla ROI addon is a Google Sheets Add-on that allows you to connect and import data directly from your Amazon Seller Central account into Google Sheets.
Let’s say you sign up for the monthly STARTER plan which includes up to 3,000 FBA orders a month.
You grow to 3,500 orders this month. Your overage is 500 orders.
Your monthly bill is an extra 500x$0.01=$5.00
Please refer to the refund policy.
The Gorilla ROI addon and Gorilla Agency are valid for a 30 day money back guarantee.
PRO Spreadsheets are non-refundable.
All plans receive access to the full feature set of the Google Sheets Addon as well as Free Spreadsheet templates.
PRO Spreadsheets are sold separately.
We have a free version. You may use the addon for free for up to 3 SKUs.
All Gorilla ROI premium plans come with a 30 day money back guarantee.
Your seller data is very safe.
Please read how we keep your seller and product data safe and private.
Yes, you can connect multiple marketplaces with a single account.
If you are not on an unlimited or agency plan, the total number of orders across your account is used to calculate any overage charges.
Unlimited plans come with 2 unlimited seller accounts.
Yes, you can connect multiple marketplace IDs with a single account.
If you are not on an unlimited or agency plan, the total number of orders across your seller accounts are used to calculate any overage charges.
Unlimited plans come with 2 unlimited seller accounts.
All major credit cards are accepted. We do not accept bitcoin or foreign currency. Prices in USD.
Follow the getting started guide.
You must sign up and be signed in to your account at app.gorillaroi.com
From your account, go to the basic spreadsheets and the click the button to copy them to your Google drive.
After sign up, give it at least 24 hours for the data to populate.
Data is never provided instantly by Amazon and it takes some time to backfill – especially if you are a big seller.
Data like reviews and BSR are not provided by Amazon. We use our own algorithms to import the information which takes time once you have connected.
It is not instantaneous.
There are many variables involved.
Amazon operates in different marketplaces, timezones and currencies. Our service is based on USA Pacfic time. Therefore there can be a slight difference due to different cut off times.
Amazon’s API is not an accounting API. If you need accounting accuracy to the nearest cent, manually reconciling is the only way possible.
A formula in USA uses comma such as =GORILLA_SKUASIN(“SKU12345”, “sku2asin”).
If you are in EU a comma may not be used on your system. You may have to use semicolon =GORILLA_SKUASIN(“SKU12345”; “sku2asin”).
Use the correct format that matches your local language settings.
Unlimited SKUs for all accounts. The account pricing tier is only based on the number of monthly orders.
Yes. Fulfilled By Merchant (FBM) is fully supported.
Unlimited for all accounts. We only charge based on total orders per month.
Security and user permission features are only offered with Gorilla Agency.
Head over to our full list of functions along with examples.