Gorilla Sheets

Integrates Amazon Seller Central

with Google Sheets

Create and share spreadsheets with latest Amazon Seller data using easy spreadsheet formulas

Quick and Easy to Install and Use 

Get set up in minutes. Connect and start importing your Amazon data to your spreadsheets and forget about the weekly CSV exports.


Who Benefits with Gorilla Sheets?

Successful Sellers

Focus on running the business and improve efficiency. Reduce employee cost by eliminating low value hours.

Data Driven Owners

Easier to know your numbers. Auto calculate sales in any period, inventory levels and inventory values.

Warehouse Managers

Get the latest instock, inbound and FC processing numbers without errors, lag or manual data entry.

Spreadsheet Users

Enter formulas to load data into your current Sheets. Eliminate the painful task of cleaning up Amazon reports.

Get back to doing what you do best – growing your Amazon business. Not manually copying and pasting data and messing with pivot tables.

How Gorilla Sheets Functions Work

Just like any Google Sheet or Excel function, Gorilla Sheets work the same way.

 

We have a large list of functions and variables that you can use to get pinpoint accurate data straight from your seller account.

 

No bloat.

 

If you know how to use spreadsheet functions, you already know 90% of how to use the Gorilla Sheets Add-on. 

gorilla sheets addon formula
GORILLA_ASINLIST( ) – Get list of ASIN’s from your marketplace

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 from all marketplaces.

 

=GORILLA_ASINLIST(“ALL”,”B43″)

Lists all ASIN’s from all marketplaces where the ASIN starts with “B43”.  

Here Are Better Things You Can Do Than Manually Dig for Data from Amazon

  • PREVENT STOCK OUT
  • KNOW YOUR BEST SELLERS
  • COMPARE GROWTH
  • GET THE DATA YOU NEED
PREVENT STOCK OUT

Stop Losing Money with Stock Out

Import real time inventory levels using our =GORILLA_INVENTORY( ) 

One of the biggest momentum killers in business is inventory stock out. Use Gorilla Sheets to know when to restock and stop leaking money.

KNOW YOUR BEST SELLERS

Know Your Best and Worst Sellers

Identify products worth investing and which ones to improve or discontinue

Create this dashboard using excel functions like SUM( ) and our custom =GORILLA_SKUASIN( ), =GORILLA_SALESCOUNT( ), =GORILLA_PRODUCT( )

COMPARE GROWTH

Compare Your Business Growth

Track your sales performance over different time periods to see how you are growing

Our custom and flexible formulas help you quickly look up sales figures over various time periods so you can compare your growth. Use functions like =GORILLA_SALESTOTAL & =GORILLA_SALESCOUNT

GET THE DATA YOU NEED

Get Pinpoint Data Without the Mess

No more multiple csv files and doing the same thing over and over again

Get the Amazon data you need without the mess. Set it once and forget it. The data is imported and loaded automatically to your spreadsheet.

What to Expect with Gorilla Sheets Addon

Start With 2 Years of Data

We immediately provide you with 2 years of historical data. Other software services don’t pull past data and force you to start and wait a few months before you have any useful data. 


Send Auto PDF Reports

Set how often you want to receive a PDF version of your spreadsheet and it will be sent to your email automatically. Helps to automate and simplify your decision making.


Detailed Preset Time Periods

Quickly see the big picture of your sales with our preset time periods. Get data for periods like yesterday, 1 week ago, last 60 days, year to date and more.

Easy Access to Your Data

You will benefit from having quick and easy access to all your product data without entering each item and date period one at a time. Stay on top of your business with ease. 


Secure Data and Privacy 

We keep your data secure and private. Data is only collected at a machine level so that you are the only person that has access to your data.


Control Who Sees Your Data

Rather than creating accounts and giving access to your Amazon account, you can pull only required data into Sheets and share it with employees without revealing everything.

See it in Action

Save the hassle and procrastination.

With Gorilla Sheets, integrate Amazon Seller Central and Google Sheets so that you don’t have to manually update data and spreadsheets. Feel the difference of how much hassle you save yourself and others.

Free Templates Included with Gorilla Sheets

These basic versions of the advanced  PRO SPREADSHEET PACKAGE  are included for free to help you get started.

amazon inventory replenish template spreadsheet

INVENTORY REPLENISH REPORT

Get a clear, accurate and easy to understand dashboard of what to send and how many to send based on sales velocity.

amazon sales performance spreadsheet

SALES PERFORMANCE REPORT

See top sellers, rank, how much sales has been generated per product and how many units have been sold over various time periods with ease. 

amazon product details spreadsheet

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. 

Some More Things You Can Do

SEE BEST SELLER RANK

=GORILLA_RANKING( ) shows Best Seller Rank of your product. Keep track of your BSR history during your subscription.

ANALYZE SALES TRENDS

=GORILLA_SALESCOUNT( ) identifies sales trends. Compare units sold today vs same day last year, this quarter, and any custom period.

CATCH HIJACKERS

=GORILLA_PRODUCT( ) can display product info so that you can catch it quickly if something changes without permission.

BULK CONVERT ASIN/SKU

=GORILLA_SKUASIN( ) can take a list of SKU’s or ASIN’s and convert it from one to another.

Use GORILLA_SKUFNSKU( ) also.

TRACK INVENTORY LEVELS

=GORILLA_INVENTORY( ) gives you latest instock, transfer, inbound numbers so you can plan inventory and stay in stock.

MANAGE REVIEWS 

=GORILLA_REVIEW( ) gives you fine control over your reviews. Stay on top of customer satisfaction.

Are You Ready to Let Gorilla Sheets Work For You?

About

Gorilla ROI provides tools for Amazon sellers to increase ROI, efficiency and save time. Focus on the important things – like growing the business.