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

gorilla sheets functions for Amazon Seller

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.

Are you still logging into accounts to download reports for basic data?

Do you waste a big portion of your time cleaning up raw data files, copying numbers, and polishing tables?

Do you constantly review your assistant’s work to ensure the data is accurate?

Is your business running reactively instead of proactively?

Is your team able to make decisions without your direction?

Is your business often crippled due to inaccurate, wrong or incomplete data entry? 

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:

leaking money

decreasing margins

missing growth opportunities

competitors leaving you behind

repeating the same mistake over and over..

“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:

Accurate and data driven forecasts to improve turnover

Better inventory planning to prevent your best products out of stock. No more emergency air shipments.

Optimizing images and copy to boost your conversion

Understanding the seasonality of your products to make informed decisions

Identifying the winners and losers to better allocate resources

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

gorilla roi time saver

You finally have up to date FBA and FBM data whenever you need it

No more hassles of reviewing manual data entry for accuracy

Foresee and make accurate data driven decisions – proactively

Easier to share and control data points with internal or external people

You can dedicate more time towards growth opportunities


“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.

gorilla roi amazon google sheets add-on install

A look at one of the Gorilla ROI Google Functions

=GORILLA_ASINLIST( ) – Get list of ASIN’s in your Amazon account

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

amazon best sellers

1. Get to know your best and worst SKUs up close

Easily identify best and worst products at a glance

Make accurate and data-driven investment decisions

Spot products with high traction and prepare accordingly

Create this dashboard with a mix of =GORILLA_SKUASIN(), =GORILLA_SALESCOUNT() and =GORILLA_PRODUCT()

amazon inventory planning

2. Stop going out of stock and losing money and rank

Sync real-time inventory reports in order to improve your planning

Know when to restock and stop your best seller from going out of stock and losing money

Your team knows when inventory needs to be sent in

Import real time inventory data with =GORILLA_INVENTORY() 

gorilla sheets sales growth

3. Understand your sales and growth patterns

Easily identify best and worst products at a glance

Understand your progress over time for better forecasts

Make accurate predictions and set realistic objectives

Get this data with =GORILLA_SALESTOTAL() and =GORILLA_SALESCOUNT()

Who is Gorilla ROI for?

Good Fit Users

You need Amazon FBA and FBM data

You want to automate workflow

You prioritize convenience & efficiency

You make data driven decisions

You already run calculations and reports through Google Sheets

Bad Fit Users

You don’t use Google Sheets. You don’t have time to learn formulas.

You only sell a few items a day

You are looking for accounting and research tools

You want free or cheap

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 template

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.

simple amazon profit inventory dashboard template report

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.

amazon sales performance spreadsheet

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.

amazon inventory replenish template spreadsheet

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.

amazon finances breakdown spreadsheet template

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.

amazon google sheets spreadsheet template integration

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. 

gorilla ROI sheets training spreadsheet

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

UNLIMITED

$199

PER MONTH

  • Unlimited Orders/mo
  • No overage charges

PRO SELLER

$89

PER MONTH

  • 3K – 10K orders/mo
  • Overage of 1c per order

STARTER

$49

PER MONTH

  • 1 – 3K orders/mo
  • Overage of 1c per order

FREE

  • No sign up required
  • Supports 3 SKUs

Single Seller Account Plan Upgrades

  • 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

What is Gorilla ROI addon?

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.

How does overage work?

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

See more examples

What is your refund policy?

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.

What’s included?

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.

Do you offer a trial?

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.

Is my seller data safe?

Your seller data is very safe.

Please read how we keep your seller and product data safe and private.

Can I connect multiple MARKETPLACES?

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.

Can I connect multiple 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.

Which payment is possible?

All major credit cards are accepted. We do not accept bitcoin or foreign currency. Prices in USD.

How do I install the add-on?
How do I access the sample spreadsheets?

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.

I signed up. Why is my data not showing?

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.

How come my numbers do not match what I see on Amazon Seller Central exactly?

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.

I am an EU seller and the formula gives errors

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.

How many SKUs can I use?

Unlimited SKUs for all accounts. The account pricing tier is only based on the number of monthly orders.

Does this work for FBM?

Yes. Fulfilled By Merchant (FBM) is fully supported.

How many users can use the addon?

Unlimited for all accounts. We only charge based on total orders per month.

Security and user permission features are only offered with Gorilla Agency.

Where can I see the full list of functions you support?

Head over to our full list of functions along with examples.