Gorilla ROI helps Amazon sellers and agencies easily load Amazon data inside Google Sheets

Connect Amazon Seller Central and Google Sheets to create flexible, custom reports that fit your business needs

Google Sheets addon for Amazon sellers.

Get direct access to Amazon data inside Google spreadsheets.

No sign-up required for self demo

gorilla sheets functions for Amazon Seller

The annoying pain of getting Amazon data into your reports

TEDIOUS, TIME CONSUMING, REPETITIVE

Amazon Seller Central and Google Sheets Integration 2021 1

Stale data after one day

After one day (or less), your Amazon data is old and needs to be updated. Needs constant updates.

Constant logging in

Are you wasting energy clicking 10 times to generate a report for each account, multiple times a day?

Manual data entry

Do you waste time cleaning up raw data files, copying numbers, and polishing tables, rather than analyzing and understanding your data?

Repetitive, non-productive work

Are you wasting time and money doing the same repetitive work or paying someone for work that can be automated?

Amazon Seller Central and Google Sheets Integration 2021 2

Wasting time

Decreasing margins

Missed growth opportunities

Always something out of stock

Stop working for data. Let data work for you.

GET YOUR LATEST AMAZON DATA AUTOMATICALLY WITHOUT ANY MANUAL WORK

THE OLD WAY

Amazon Seller Central and Google Sheets Integration 2021 3

THE NEW WAY

Amazon Seller Central and Google Sheets Integration 2021 4

Get fresh data quickly and easily

Fetch data from Amazon seller central to Google sheets with a simple spreadsheet formula. No need to download reports.

Automatic updates to your reports

Data is refreshed and updated automatically to your spreadsheet. No more manual data entry.

Centralize data for all your Amazon stores

Whether you have 1 store or 20 stores, you can access a specific store data or SKU from your spreadsheet. Create custom reports that fit your analysis and reporting needs.

Works like a regular spreadsheet

Know how to use spreadsheet functions like SUM, AVERAGE, VLOOKUP? Our functions work the same way to fetch Amazon data.

Custom reports and data you can generate on the fly

Improved inventory planner than Amazon’s to stay ahead

Sales performance report by marketplace and SKU

Track listing details that hijackers try to change

Custom sales velocity calculations to know your best sellers

You can dedicate more time towards growth opportunities

Month by month profit and loss details

Share reports of review and ratings performance by ASIN

Detailed list of fees and charges you are paying to Amazon

Break even product cost calculator

Sales forecasting calculator using sales and inventory data

Big or small, Amazon sellers are saving 20 hours a month

WORK MADE EASIER, FASTER AND CUSTOMIZABLE

Generate accurate business snapshots

Quicker management report generation

Use up to date data for running operations

Operate with actionable and insightful data analysis

Utilize data driven forecasts to optimize sales

Amazon Seller Central and Google Sheets Integration 2021 5

“If you are spending more time collecting and entering data than getting work done, check out Gorilla ROI.”


What users say about us

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

3 vital and custom reports for your business

CREATE YOUR IN-HOUSE ADVANTAGE WITH CUSTOM ANALYTICS

1. Sales performance reports by SKU or ASIN

Track and view your best and worst sellers by SKU over any time period.

Create this dashboard with our functions:

  • GORILLA_ASINLIST()
  • GORILLA_SALESCOUNT()
  • GORILLA_PRODUCT()
amazon best sellers

Easily identify best and worst products at a glance

Make accurate and data-driven investment decisions

Spot products with high traction and prepare accordingly

2.Inventory planning reports to prevent going out of stock

Know what to send, when to send with your inventory data.

Create this dashboard with our functions:

  • GORILLA_SKULIST()
  • GORILLA_INVENTORY()
  • GORILLA_INVENTORYHIST()
amazon seller central and google sheets inventory data

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 uses update to date data to know what inventory needs to be sent in

Fulfill your data and custom reporting needs today

3.Amazon monthly profit loss tracker and detailed finances

Track all your finances automatically inside Google sheets. No CSV exporting and importing required.

Create this dashboard with our functions:

  • GORILLA_PROFITLOSS()
  • GORILLA_CHARGETOTAL()
  • GORILLA_FEETOTAL()
amazon profit loss report

Merging 5 different reports no longer needed

Your data and reports are updated automatically

All finances and transactions are categorized and aggregated for ease of use

More reasons Amazon sellers love Gorilla ROI

Automate your existing spreadsheets

Our Amazon to Google sheets connector will work with any existing spreadsheet. Upgrade your current custom reports with automated data updated.

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.

Speed up your team and operations

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 ROI for?

Good fit Amazon sellers

You already create reports with Google Sheets

You need Amazon FBA and FBM data

You want to automate workflow

You prioritize convenience & efficiency

You make data driven decisions

Bad fit Amazon sellers

You don’t use Google Sheets.

You don’t like advanced spreadsheet formulas

You only sell a few items a day

You are not technically inclined

You want free or cheap

Are you an agency or company that manages 3 or more seller accounts?

You qualify for Gorilla Agency.

Custom reporting and data flexibility comparison

Gorilla ROI
DIY or VA
Web based Providers
SUITED FOR
  1. Advanced and analytical sellers
  2. Data and spreadsheet lovers
  1. Manual data entry
  2. Delegate to VA
  1. Don’t need custom reports
  2. Non sophisticated sellers
PROS
  • Get data inside spreadsheets
  • Most robust data and flexible
  • Unlimited users and SKUs
  • In house solution
  • Learn to navigate seller central
  • Custom solution
  • Web based. No spreadsheets.
  • Simple. Not much to set up.
  • Lots of features
CONS
  • Very detailed, lots of data
  • Spreadsheet skills needed
  • Google sheets only
  • Slow and outdated data
  • Missing lots of data
  • Time consuming and error prone
  • Not flexible for custom needs
  • Jack of all trades, master of none
  • Focused on non-technical sellers
PRICING

Starts at $49/mo

$600-$2000 per month

$20-$399 based on SKU or Orders

CUSTOMIZABILITY

10/10

10/10

5/10

DATA PROVIDED 

8/10 (no PPC)

4/10

7/10

NUMBER OF USERS

Unlimited users

Anyone on the team

1 to 4 users

PLATFORMS

Google sheets only

Copy data to any platform

Web browser only

How Gorilla ROI works

QUICK EXAMPLE: HOW TO LOAD YOUR PROFIT LOSS DATA IN GOOGLE SHEETS

Integrate Amazon Seller Central into Google Sheets

Gorilla ROI is a Google Sheets addon. Once enabled, you can load your Amazon data with a single formula.

Simple formulas to load Amazon Seller Central data inside Google Sheets.

Works for all marketplaces, FBA, FBM, Multi Channel Fulfilled.

Easy to install with stellar support and documentation

We don’t win unless you win. That’s why we offer superb technical support and documentation.
gorilla roi amazon google sheets add-on install

Easy to install on any Google Sheets account.

Support tickets, live chat, training videos, documentation, instructions. You get it all.

Access the largest selection of Amazon data points

We offer the largest set of functions for Amazon sellers to get the data you need.
Amazon Seller Central and Google Sheets Integration 2021 13

Pick the data you need in your reports. No bloat. 100% flexibility.

We offer the largest set of functions for Amazon sellers to get the data you need.

A function to load your entire ASIN list in bulk

gorilla formula asinlist example
=GORILLA_ASINLIST( )

Description:

Return a list of ASINs from your marketplace(s) where you can filter by status, FBA, FBM and sort.

Syntax:

=GORILLA_ASINLIST([marketplace], [filter_sku], [status], [fulfillment], [sort])

Examples:

=GORILLA_ASINLIST()

If no attributes are entered, it will list your entire list of ASINs for the marketplace added to your account.

=GORILLA_ASINLIST(“US”, , “ACTIVE”, “FBA”)

Lists all active and FBA only ASINs from US marketplace.


“Saves us so much time and gives us insight on how to quickly modify our Amazon strategy”

FREE customizable templates included

Ready-to-go report templates included for all Amazon Sellers

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. 

Amazon Seller Central and Google Sheets Integration 2021 14

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

Best for smaller or single Amazon seller accounts

UNLIMITED

$399

PER MONTH

  • Unlimited Orders/mo
  • No overage charges

MEGA

$199

PER MONTH

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

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 card info required
  • Only 3 SKUs

Single Seller Account Plan Upgrades

Reimbursement Data Package
  • Additional flat monthly plan on top of the base plan above.
  • Access to reimbursement data to get money back from Amazon.
  • Alternative to paying agencies 10% of the amount collected.
  • 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.

30 days no questions asked

MONEY BACK GUARANTEE

If Gorilla does not return an ROI, cancel anytime.

Nothing to lose, but a whole lot to gain.

Amazon Seller Central and Google Sheets Integration 2021 15

Frequently Asked Questions

What is the 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.

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