Google Sheets addon for Amazon FBA sellers
Connect Amazon Seller Central and Google Sheets to auto import your seller data
Supercharge your Google Sheets by automatically importing your Amazon data and say goodbye to manual data entry
Get work done. Not work to get data.
Streamline your workflow and transform your process into a smart, fast, and automated task.
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:
Supercharge your Amazon seller spreadsheets without any code
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 with at least five extra hours a week. That might sound small, but in reality, it has a lot of impact.
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?” moment.
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.
“Finally. I can automatically import my seller data from Amazon into Google Sheets without knowing code…”
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 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 SKU’s 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 (NEW)
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.
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.
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.
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 Pricing
Best up to 2 seller accounts
Best for low volume sellers
Pay only what you use
UNLIMITED
$119
- Unlimited Orders/mo
- No overage charges
- Unlimited ASINs
- Unlimited Users
- All features included
- All marketplaces supported
- Free templates included
- Express support
PRO SELLER
$79
- 3K – 10K orders/mo
- Overage of 1c per order
- Unlimited ASINs
- Unlimited Users
- All features included
- All marketplaces supported
- Free templates included
- Priority support
STARTER
$39
- 1 – 3K orders/mo
- Overage of 1c per order
- Unlimited ASINs
- Unlimited Users
- All features included
- All marketplaces supported
- Free templates included
- Email support
FREE
$0
- No sign up required
- Works for any 3 FBA SKU’s
- Slow data updates
- Free for any 3 SKU’s
- All features included
- All marketplaces supported
- Free templates here
- Install instructions here
Single Seller Boosters
PRO spreadsheet package
- Calculators, templates, Chinese NNN agreement to help you optimize your operations.
- One time payment.
- Separate purchase without data plan possible.
1YR Total Support Package
- Includes PRO spreadsheet package.
- Includes set up service, 1 year support and warranty.
- Blazing fast support over email, chat or phone.
- We fix any broken files, formulas.
- We help with integrations with our templates.
Need high volume or more than 2 seller accounts?
- Multiple user (agency) plans are unlimited
- Unlimited users, ASINs, orders
- Flat monthly fee
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.
Here’s what customers said changed for the better after implementing Gorilla ROI.
“I am able to pull data from all my clients and use a template to generate documents weekly.“
Wes Beckwith – Amazon Agency
“I have finally found a flexible inventory management system for my FBA business”
J T – FBA 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
“Now I get my sales data for top sellers nice and concise inside a single spreadsheet.”
Dylan Young – 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.
A trial is not offered because you can test the add-on for free.
You may use the addon for free for up to 3 SKU’s.
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 ID’s 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 SKU’s for all accounts. The account pricing tier is only based on the number of monthly orders.
No. Fulfilled By Merchant (FBM) is not supported. Only FBA.
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.