GETTING STARTED GUIDE

Install Instructions

Make sure to follow the instructions that match your subscription plan

Authorize Gorilla ROI on Seller Central

After you authorize the connection, you will see a page with your seller ID (merchant ID) and merchant token. Get your ID and token using the shortcut links below.

Our USA/CA/MX/BR Developer ID for Gorilla ROI is 447136896315


Our EU Developer ID is 642105350512


For Japan sellers our Developer ID is 626257519921


Our AUS/SG Developer ID is 690386913621

Add Seller Account(s) to Gorilla ROI

With the seller ID and token you created from step 1, enter it into your Gorilla ROI account.

For Single Seller Plan users

  1. Select “Seller Accounts
  2. Click on the green add account icon in the top right corner and add the seller accounts
  3. Enter a nickname to help identify the seller account
  4. Add and save
  5. Wait for the data to import. Check status on your account under “download status”.
download status

Add Seller Account(s) to Gorilla ROI

With the seller ID and token you created from step 1, enter it into your Gorilla ROI account.

For Multi-Seller (Agency) Plan users:

  1. Select “Agency Sellers
  2. Click on the green add account icon in the top right corner and add the seller accounts
  3. Enter a nickname to help identify the seller account
  4. Add and save.
  5. Select “Agency Users
  6. Add the email address of the people who will be using the addon.
  7. Wait for the data to import. Check status on your account under “download status”.
download status

Add Seller Account(s) to Gorilla ROI

Create a free account at app.gorillaroi.com/registerFree.php

With the seller ID and token you created from step 1, enter it into your Gorilla ROI account.

For Free Users:

  1. Select “Seller Accounts”
  2. Click on the green add account icon in the top right corner and add the seller accounts
  3. Enter a nickname to help identify the seller account
  4. Add and save
  5. Wait for the data to import. Check status on your account under “download status”.

Use Incognito Mode to Start Fresh without Issues

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
    • 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
    • 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
    • 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)
  5. 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 in the demo account.
    • Here are some easy formulas you can use. Copy these into another cell.
    • =GORILLA_SKULIST()
    • =GORILLA_ASINLIST()
    • =GORILLA_SALESCOUNT()
    • =GORILLA_SALESTOTAL()
    • =GORILLA_FEETYPE()
    • =GORILLA_CHARGETYPE()
  7. For more, 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.