GETTING STARTED GUIDE

Install Instructions

Make sure to follow the instructions that match your subscription plan

For Single Seller Plan users

1. Go to your “Seller Accounts
2. Click on the green add account icon in the top right corner and add the seller accounts

01.single seller add new seller Gorilla ROI

3. Select the marketplace and add a nickname label for easier identification

01.single seller select marketplace Gorilla ROI

4. Seller Central will open up. Authorize the connection from Seller Central.

01.single seller amazon permissions Gorilla ROI

5. Wait for the connection to finish and you will be redirected to your Gorilla account and the connection will show up as active.

01.single seller connection active Gorilla ROI

6. You can now check your data importing process. When everything shows 100%, it is finished but you can still use it in the meantime even if it isn’t 100% complete.

01.single seller see download status Gorilla ROI

For Multi-Seller (Agency) users:

1. Select “Agency Sellers
2. Click on the green add button in the top right corner and add the seller accounts

02.multi seller add new seller Gorilla ROI

3. Copy the link and provide it to the Seller Account owner to authorize the connection

02.multi seller copy link Gorilla ROI

4. Select the marketplace and click the authorize button

02.multi seller select marketplace Gorilla ROI

5. Seller Central will open up. Authorize the connection from Seller Central.

01.single seller amazon permissions Gorilla ROI

6. The seller account owner will see a success page and an email will be sent to the Gorilla ROI user

02.multi seller connect success Gorilla ROI

7. Wait for the connection to finish and you will be redirected to your Gorilla account and the connection will show up as active.

02.multi seller connection active Gorilla ROI

8. Add a nickname to easily identify the seller and to use in the formula

02.multi seller add nickname Gorilla ROI
02.multi seller nickname formula Gorilla ROI

9. Add emails of your “Agency Users

02.multi seller add email Gorilla ROI

10. Wait for the data to import. Check status on your account under “download status”.

01.single seller see download status Gorilla ROI

For Free Users

1. Create a free account at app.gorillaroi.com/registerFree.php
2. Follow ALL the steps in 2a for Single Sellers

Watch how to install and activate the addon

Written Version. Use Incognito Mode to Start Fresh.

3a. Single Seller Plans

  1. Log in to your main Google Sheets (Workspace Account highly recommended)
  2. Install the addon for Single Business Plan and Free Version
  3. Once installed
    • Menu > Add-ons > “Single Amazon Seller” -> Use this addon
    • Menu -> Addons -> “Single Amazon Seller” -> Add User ID
    • Enter your User ID you can find from your Gorilla Account dashboard
single seller user ID Gorilla ROI
  • If it doesn’t save, redo in incognito mode because Google is caching your G Drive.
  • Wait for the data import process. Will take a couple of hours or more based on your size.

3b. Multi-Seller (Agency) Plans

  1. Log in to your main Google Sheets (Workspace Account highly recommended)
  2. Install the addon for Multi Seller (Agency) Plan
  3. Follow prompts and install the add-on
    • Menu > Add-ons > “Multi-Seller (Agency)” -> Use this addon
    • Menu > Add-ons > “Multi-Seller (Agency)” -> Add Agency ID
    • Enter your Agency ID you can find from your Gorilla Account dashboard
multi seller agency ID Gorilla ROI
  • If it doesn’t save, redo in incognito mode because Google is caching your G Drive.
  • Wait for the data import process. Will take a couple of hours or more based on your size.

3c. Free Users

  1. Log in to your main Google Sheets (Workspace Account highly recommended)
  2. Install the addon for Single Business Plan and Free Version
  3. Once installed
    • Menu > Add-ons > “Single Amazon Seller” -> Use this addon
    • Menu -> Addons -> “Single Amazon Seller” -> Add User ID
    • Enter your User ID you can find from your Gorilla Account dashboard
single seller user ID Gorilla ROI
  • If it doesn’t save, redo in incognito mode because Google is caching your G Drive.

4. Enter the 3 free SKUs you want to use.

  • Menu > Add-ons > “Single Amazon Seller” > Add 3 Free SKUs (NOT ASIN)
  • Wait for the data import process. Will take a couple of hours or more based on your size.
subscription id

Option 1: Test in a new blank spreadsheet

Data must be imported first. Do this test a couple of hours after you have connected to Gorilla ROI.

  1. Create a new spreadsheet or use this shortcut link
  2. Menu -> Addons -> “Single Amazon Seller” or “Multi-Seller (Agency)”-> Use this addon
  3. Menu -> Addons -> “Single Amazon Seller” or “Multi-Seller (Agency)” -> Add User/Agency ID
  4. Enter your ID from your Gorilla ROI account
  5. Save
  6. In any cell type in =GORILLA_SKULIST() or =GORILLA_ASINLIST()
    • This formula will load the full list of SKUs or ASINs.
    • Here are some easy formulas you can use. Copy these into another cell.
    • =GORILLA_SKULIST()
    • =GORILLA_ASINLIST()
    • =GORILLA_SALESCOUNT(“this year”)
    • =GORILLA_SALESTOTAL(“last month”)
    • =GORILLA_FEETYPE()
    • =GORILLA_CHARGETYPE()
  7. For detailed examples, videos and more functions, go to the full list of formulas. More examples & videos.

1. The ID doesn’t save in Google Sheets

Please try again in incognito mode. Google is caching your drive. This can happen if you have Google Drive installed on your local computer, or have Chrome extensions to use drive in offline mode.

2. How do I let a team member access the data

Have each person install the same addon version you are using. Share the User ID or Agency ID with them. Each person must unlock the addon using the same ID.

3. My data isn’t showing up

Data can take a while to download depending on the history and size of the account.

Go to Gorilla Account > Download Status.

You’ll see two % numbers and the dates. Make sure both are at 100% otherwise the import process is still in progress. Transactions take longer as we have to go through each one by one.

We provide the most in-depth set of data than any other Amazon service provider. Because of this, the import process takes more time to gather fully.

4. The data doesn’t match my seller central data

Check the download status. If the data hasn’t fully downloaded, it will be different.

Our data matches up with seller central extremely closely. If you see a discrepancy, contact us. It is usually how we roll up some numbers together as there are over 150 different fees and charges.

5. I get an error about too many requests from Google

Google gives a daily quota for how often you can pull data into spreadsheets. This is so you don’t overload their servers.

Use ranges and array formulas.

If you do single references in the formula such as A1, A2, A3… A1000, you are asking Google to request data 1000 times.

e.g.
=gorilla_inventory(A1)
=gorilla_inventory(A2)
=gorilla_inventory(A3)

=gorilla_inventory(A1000)

If you use formulas like this in your spreadsheet and try to refresh your data, Google will think you are a bot as the spreadsheet is requesting hundreds of requests too quickly in a short period.

If you do A1:A1000, you get the same data, but it is only requesting 1 time.

=gorilla_inventory(A1:A1000)

To get around this, please transfer ownership of the spreadsheet to a different Google user account to use a fresh Google quota limit.

View our Amazon templates

Pre-built templates to copy to your account. Save time instead of recreating the wheel. Use ours and get started right away.