Gorilla ROI is for Amazon sellers and agencies to load Amazon data inside Google Sheets

Google addon for Amazon sellers and agencies managing multiple seller accounts

“Amazon data updates that used to take hours is now automatic and requires almost no time and effort.”

Load seller central data inside Google sheets without manually accessing accounts and exporting Amazon reports multiple times a day.

gorilla roi agency addon

The bottleneck of managing multiple Amazon seller accounts

As you started managing multiple accounts, you likely noticed how little things add up and take away your productivity.

  • logging in to Amazon seller central
  • downloading reports
  • cleaning up files
  • creating reports
  • repeat for each account you manage

It used to take 15 minutes, but now eats up one hour before you even get to analyzing the data.

Delegating the manual process works for a while, but then your assistant quickly becomes overloaded. Whether you hire internally or outsource the process, it quickly adds up to hundreds of dollars a month.

The tediousness, slowness of manual updates and lack of visibility into the data starts to amplify.

gorilla agency amazon software tools

Inefficiency is draining your profits and growth

Amazon forces you to keep all your accounts separated .

You waste time collecting and cleaning up information from multiple accounts.

Hiring an assistant costs hundreds a month, errors still exist, and extra overhead costs.

You have to review it because manual entry still has errors.

Harder to see and provide expert insights in a timely manner.

The main problem is not being able to see the big picture of each account and giving insightful recommendations to your clients or team.

This severely limits your scaling and growth potential as you are handcuffed with the number of accounts you have.

How Gorilla helps your business manage multiple Amazon seller accounts

We created the Google Sheets addon called Gorilla ROI and Gorilla Agency to leverage time. As we grew our Amazon sales to over 7 figures, the number of brands and SKUs increased with it. We were falling behind the business and too busy putting out fires instead of staying ahead and steering it in the right direction.

If you are an agency or seller with multiple accounts, managing accounts efficiently with flexibility is important.

How much easier would it be if you could update the latest data across all accounts to come up with ideas and suggestions like:

How many units of each SKU are being sold between any period

Which SKUs are gaining traction and should be shipped out before it goes out of stock

How the account is doing compared to the same period from last year

Which products have potential and should be optimized further

See what’s working on one account and apply the same strategy to other accounts

gorilla agency google addon

All within Google Sheets and no coding knowledge required.

If you already use Google Sheets to analyze your data and share information within your teams and clients, Gorilla ROI will load your spreadsheets and models with data to eliminate the manual process.

It is plug and play.

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
Gorilla Agency 1

A look at one of the Gorilla ROI 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(SellerID, [marketplace], [filter_sku])

Examples:

=GORILLA_ASINLIST(SellerID)

If no attributes are entered, it will list all your current active and inactive ASIN’s from all marketplaces.

=GORILLA_ASINLIST(“A7302JHD38″,”US”,”B43″)

Lists all ASIN’s for the seller “A7302JHD38”, from US marketplace only where the ASIN starts with “B43”.

Say goodbye to logging into each account and pulling reports multiple times a day.

Pull seller central data for any seller account from within your spreadsheets

 

GET DATA FOR ANY SELLER WITHIN GOOGLE SHEETS

  • No more logging in and out
  • No generating reports
  • No cleaning up dirty csv files
  • No copying and pasting needed

100% control and flexibility with your spreadsheets and reports

Total control and flexibility when you automate data into your spreadsheets.

amazon sku inventory stages spreadsheet

FULLY CUSTOMIZABLE AND FLEXIBLE TO MEET YOUR NEEDS

  • Works just like a regular spreadsheet formula like =SUM
  • Works with your existing spreadsheets
  • Create your own internal apps
  • Use our templates to get started easily

Other ways Gorilla ROI can be used

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.

Who is Gorilla Agency for?

Businesses that manage multiple Amazon FBA and/or FBM accounts

Agencies who need to keep data separate between clients for easier reporting

Amazon businesses that manage 3 or more seller accounts

Amazon brokers that sell FBA or FBM accounts and listings

Consultants hired to improve conversions and find areas of improvement

Good Fit Users

Agency, consultant or company managing 3 or more Amazon accounts and needing detailed data per account.

You want to scale without extra work

Your clients want detailed data driven recommendations

You are trying to simplify workflow

You already run models and reports through Google Sheets

Bad Fit Users

Manage or own 1-2 seller accounts only (Use Gorilla ROI Single Seller instead)

You manage small volume seller accounts

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

You are looking for accounting and product research tools

You want free or cheap

What people are saying

Gorilla ROI is rated 4.6 stars out of 5 stars on the Google Marketplace. Good or bad, these are 100% honest and real, just like us

Create dynamic custom reports that update for each Amazon seller account

 

Without needing to know any code, you can create dynamic custom reports that update automatically for any seller account you need to report on.

Use basic Google Sheet style formulas to get detailed data on the fly for any seller account.

Anyone in your team can learn the simple functions to pull information and keep your operations running smoothly without having to:

  1. ask you for data
  2. logging in to each account and extracting data

You can keep it as broad or granular as you like.

Add extra parameters to the formula to get in-depth details for any seller like reviews, inventory numbers, sales, units sold, fees, and more.

Use a formula like

=GORILLA_REVIEW(“A8NHSOIUGK23H”, “DJHF-2322-ASKJ”, “US”, 3)

to get the last 3 reviews for SKU DJHF-2322-ASKJ from the seller account A8NHSOIUGK23H.

agency formula example

A look at another Gorilla ROI Function

=GORILLA_LOWESTOFFER( ) – Get the lowest offered listing price

Description:

Get the lowest offered listing price from any seller that is selling the SKU

Syntax:

GORILLA_LOWESTOFFER(sellerId, sku, [marketplace], [condition], [returnStyle], [priceType])

Examples:

=GORILLA_LOWESTOFFER(“A00AF234TO“, “SKU12345”)

The simplest version. Returns the current lowest price being advertised on the listing for the SKU. The seller ID is used to identify which seller and SKU to look up. If no other attributes are added, it uses the default conditions.

=GORILLA_LOWESTOFFER(“A00AF234TO“, “SKU12345”, “US”, “New”, “price”, “LandedPrice”)

This full formula looks up the lowest offered price on the listing for seller A00AF234TO and SKU “SKU12345” from the US market, in NEW condition. You can also look up other conditions like Used, Like New and other conditions supported by Amazon.

Better team sharing, data security and permission control

gorilla agency security feature

Want other people in your organization to use the Google Sheets addon, but limit their access to certain seller accounts?

Rather than allowing every member in your team to pull data from all accounts, you can assign the seller accounts a user can import data from.

This is especially helpful if you want to allow clients or junior employees to access data.

A simple case study

Let’s say you manage 4 accounts.

You have access to all accounts but you only want Jim Cortana from operations team to access accounts 2 and 4.

He should not be looking at data from account 1 and 3.

Easy to do with Gorilla Agency.

Select the accounts Jim or any other user should get access as you see in the screenshot below.

gorilla agency permissions

Why you should control access

Only users added to the Gorilla Agency account can access data

Centralize permissions to protect sensitive account data from the wrong people

Clients or partners have piece of mind knowing their data is safe

You can charge extra to clients for them to access their data via Google Sheets

Provide added value and upsells with subaccounts

Want to make your clients even happier and retain them longer?

Add value by creating sub user accounts for them. Provide basic spreadsheet dashboards that update automatically to help them with daily operations.

You could even charge a monthly fee for this added value as an upsell.

Gorilla Agency 9

Gorilla AGENCY vs Single Seller Addon

Gorilla Agency

Suited for large sellers

All functions included

3 unlimited accounts included in base plan

Supports unlimited number of accounts

Flat pricing. No overage charges.

Security and user controls

Express support

Regular Addon

Suited for small to medium sellers

All functions included

Max 2 sellers accounts included and charged based on orders/mo

Pricing based on orders/mo with overage charges

All users access the data

Slower email support

Just imagine how much…

Gorilla Agency 10

clients and teams will love you

Deliver rockstar reports, suggestions and insights before being asked.

Proactively manage accounts instead of responding to questions and requests.

See all your accounts with ease and cement your expertise and authority.

Gorilla Agency 11

you can scale with ease

You can take on more accounts without increasing your workload.

Your team can securely access the data and create reports for your review.

New seller accounts can be quickly integrated with minimal effort.

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 (included)

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 (included)

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 (included)

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. 

Gorilla Agency 12

SALES PROFIT DASHBOARD REPORT (included)

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 finances breakdown spreadsheet template

FINANCES BREAKDOWN OF FEES & CHARGES (included)

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 inventory replenish template spreadsheet

INVENTORY REPLENISH REPORT (included)

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 google sheets spreadsheet template integration

PRODUCT DETAILS SPREADSHEET (included)

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 (included)

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. 

Multiple Seller Accounts (AGENCY) Flat Pricing

Best for managing multiple seller accounts and marketplaces

AGENCY 50

$699

PER MONTH

50 accounts included

+ $10 ea

PER EXTRA SELLER


  • Only pay for extra accounts
  • Unlimited everything else

AGENCY 20

$499

PER MONTH

20 accounts included

+ $10 ea

PER EXTRA SELLER


  • Only pay for extra accounts
  • Unlimited everything else

AGENCY 10

$299

PER MONTH

10 accounts included

+ $20 ea

PER EXTRA SELLER


  • Only pay for extra accounts
  • Unlimited everything else

BASE

$199

PER MONTH

3 accounts included

+ $25 ea

PER EXTRA SELLER


  • Only pay for extra accounts
  • Unlimited everything else

Have complex questions? Need a demo?

Have a unique business model or need to see how Gorilla ROI can fit your needs?

Book a demo time that is convenient to you.

Multiple Seller 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 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.
No question we can’t answer. See if we fit your needs.

Have a unique business model or need to see how Gorilla ROI can fit your needs?

Book a demo time that is convenient to you.

30 days no questions asked

MONEY BACK GUARANTEE

If Gorilla Agency does not return an ROI, cancel anytime.

What have you got to lose?

Gorilla Agency 13

Don’t take our word for it.

Google marketplace reviews showing what changed for the better with Gorilla ROI

Gorilla Agency 14

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

Gorilla Agency 15

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

Gorilla Agency 16

Amazing app. Wish I had this 5 years ago.

Colin – Amazon Seller

Gorilla Agency 14

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

Gorilla Agency 18

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

Gorilla Agency 19

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

Gorilla Agency 14

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

Gorilla Agency 14

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

Gorilla Agency 22

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

Gorilla Agency 23

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

Gorilla Agency 24

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

Gorilla Agency 14

Love using Gorilla – quickened my analysis time and I can easily manage my costs across all my products.

Google Marketplace Review – Amazon Seller

Gorilla Agency 26

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

Gorilla Agency 27

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 Agency 28

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

Gorilla Agency 14

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

Gorilla Agency 30

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

Gorilla Agency 31

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

Gorilla Agency 14

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

Gorilla Agency 33

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

Gorilla Agency 14

I am able to pull data from all my clients and use a template to generate documents weekly.

Wes Beckman – Amazon Agency

Gorilla Agency 14

Now I get my sales data for top sellers nice and concise inside a single spreadsheet.

Dylan Young – FBA Seller

Gorilla Agency 36

Love this add-on!

I can create my own reports, the way I want.

Google Marketplace Review – Amazon Seller

Gorilla Agency 14

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

Gorilla Agency 14

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

Gorilla Agency 14

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.

What is included in the Agency plan?

The base plan includes 3 unlimited accounts.

To add more accounts, it is a flat price per month.

All accounts are unlimited usage.

Basic spreadsheet templates are available for you to get up and running quickly. PRO spreadsheets are not included in the package unless you also purchase the installation package which includes the PRO Spreadsheet as a bonus.

What is the difference between Agency and Regular?

Check out the differences here

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?

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 an unlimited number of marketplaces.

Can I connect multiple SELLER accounts?

Yes, you can connect multiple accounts from your account by logging in at app.gorillaroi.com

Extra accounts are flat pricing. No overage charges. Unlimited orders, unlimited users.

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.

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 addon?

Follow the AGENCY getting started guide.

How do I add users to my agency account?

You must sign up and be signed in to your account at app.gorillaroi.com

From your account, go to AGENCY USERS and add the google drive email of the user you wish to give access.

Select which seller account the user gets access to.

How do users use the addon?

The user must have the AGENCY addon installed to their Google Sheets.

Activate and add the unique Agency ID that can be found from your account at app.gorillaroi.com

All valid users can access the data with this unique Agency ID.

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 100% 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.

Why choose us?

We specialize in delivering data from seller central straight to your spreadsheets.

The way you want it, when you want it, how you want it.

WE UNDERSTAND AMAZON SELLERS AND AGENCIES

30 DAY MONEY BACK GUARANTEE NO QUESTIONS ASKED

HIGHEST RATED AMAZON ADDON FOR GOOGLE SHEETS

100% SECURE VIA 256-BIT SSL. DATA OWNED BY YOU.

STELLAR SUPPORT IS STANDARD