1. Home
  2. Docs
  3. Gorilla Agency Addon
  4. Gorilla AGENCY Getting Started

Gorilla AGENCY Getting Started

Step 1: Authorize Gorilla Addon for EACH Amazon account

Gorilla needs permission from every Amazon account to fetch and process your sales. For EACH Amazon Seller account, authorize Gorilla using the following steps:

1. Go to the page in Seller Central and login as the primary user of your Amazon Seller Account.
Gorilla AGENCY Getting Started 1

2. Scroll down towards the bottom of the page and click on Visit Manage Your Apps
amazon mws

3. Then click on Authorize new developer in the next window.
Gorilla AGENCY Getting Started 2

4. In the Developer name text box, enter Gorilla ROI. This name is merely for your own reference.

5. Our GorillaROI Developer ID must be authorized for each marketplace you wish to import data from.

a) For USA/CA sellers, enter Developer ID 054339617981, and authorize.
b) For UK/EU sellers, enter Developer ID 642105350512, and authorize.
c) For Japan sellers, enter Developer ID 626257519921 and authorize.

dev id mws

6. Your Seller ID and MWS Auth Token appears.
seller id and mws auth token

7. Save or copy the Seller ID and MWS Auth Token

Step 2: Set Up the Seller Accounts and Email Account Permissions

1. Log in to your Agency Dashboard and Set Permissions
To protect seller accounts and who gets access to data, you must first set your permissions.

agency dash

#1. Your Agency ID is a uniquely generated number that is used to activate the AGENCY addon.

#2. This is where you add the seller accounts that have authorized Gorilla ROI to import data.

#3. Enter the Google account emails that should have access to seller accounts.

2. Your Agency ID
Share this agency ID with anyone in your team who will need access to the addon. It is a centralized key to activate the addon. The addon will not allow users to see the seller ID or the authorization codes.

3. Add Seller Accounts
Add as many Amazon Seller Accounts that you need to import data from. The base Agency plan includes 3 unlimited accounts.

You can set permissions to allow certain accounts to have access to the seller information. E.g. Mike can have access to Amazon Account Seller A & B’s account, but not C & D.

add new seller

Add a new seller by clicking on the button and add the Seller ID and MWS auth token.

Gorilla AGENCY Getting Started 3

  1. Add Associated Emails and Set Permissions

Add the email of the Google accounts that are authorized to use the addon.

Emails not added to the list will be unable to import any information. This is to protect the seller’s information from getting into the wrong hands.

You can also control which emails have access to which seller account.

add authorized emails

Add as many authorized agency users as needed. No charge for additional users.

Gorilla AGENCY Getting Started 4

Set the permissions for which seller account an authorized user will have access to.

Step 3: Install Gorilla AGENCY Add-on on Google Sheets

1. Log in to your Google Drive & Docs
Open one of the templates we provide or one of your own spreadsheets.

2. Copying Templates To Your Account (optional)
To use any of our templates, it must first be saved to your account.

1. Open the Google Sheet spreadsheet template
2. File > Make a Copy
3. Save to your folder

3. Enabling Gorilla Sheets on Templates and Your Sheets
To use Gorilla Sheets you must enable the add-on on each Google Sheet.

To enable the addon, follow these steps:
A. Log into the backend of Gorilla ROI at https://app.gorillaroi.com/
B. In the dashboard, click the link that says “Click to install Gorilla Sheets add-on” in the top right corner box.Gorilla AGENCY Getting Started 5

C. Click “Free” to install the addon. Only paid accounts can get full functionality.

Gorilla AGENCY Getting Started 6

D. You will see a window by Gorilla Sheets requesting permission to install and run. Click continue and allow the installation.

To see the list of permissions we require and why view the help page to see the full requirements.

google sheets access

E. With the add-on now installed, Gorilla Sheets is now enabled. Next you must enter your Amazon credentials in order for the add-on to import your data.

Go to the next section to connect Amazon to Google Sheets and start importing your data.

Alternate Installation Method
Another method of installing the add-on is to open up any Google Sheet.
Then go to “Add-ons > Get Add-ons” and search for “Gorilla ROI” from which you can install the add-on immediately.

gorilla free plugin

Step 4: Connect to Amazon Seller Central

To start using Gorilla Agency Addon, you must enter the Agency ID from your account dashboard.

To enter your Seller ID and Auth Token, follow the steps:
A. In the menu choose Add-ons > Gorilla Sheets > Add Agency ID

gorilla sheets for agency

B. Enter your Agency ID

add agency id

Click on Menu > Addons > Gorilla Sheets Agency > Check Status of Data Import

download data status

GorillaROI is the only service that provides you with 2 years of historical data for you to see the data behind your growth. However, this takes time.

IMPORTANT: Once your account is connected, the first data download will take between 15min to 2 hours depending on the sales volume of the seller account.

The initial download process is a big bulk download using the reports that Amazon provides.

This provides the basic and broad overview of your sales figures.

You may start to use the Gorilla Functions at this point.

Once the first data download is finished, Gorilla will then start to import every individual order for the past 2 years.

This second step takes longer as it has to go through every order one by one, clean it up, store it and get it ready for you.

This 2nd re-downloading of data takes 24 to 48 hours depending on volume. If you sell millions, it will take longer to import than a seller who sells a hundred orders a month.

You can now use the provided Gorilla Sheets functions.

Step 5: Quick Test

To check if the add-on has been correctly installed, open a new & empty Google Sheet.

In any cell, type in =gorilla_asinlist( “the seller ID e.g. A8302KDUEK3” )
If the spreadsheet loads all your ASIN’s like below, the add-on has been properly installed and added.

check with asin list

If you receive an error:

  1. Check the Seller ID is entered correctly
  2. Check the google account is added to the authorized user list
  3. Check the Seller ID is added to the account from the dashboard

To check the progress of your data download, you can view the status by selecting Add-ons > Gorilla Sheets > See Data Status

This test account signed up on April 1. There was no previous history which is why it shows N/A for History Batch Order Update.

For the History detailed order update, it imported everything up to March 29, and then started downloading the orders fresh starting March 30 to ensure a seamless transition with the new account.

data status troubleshooting


We have detailed documentation available from within the add-on as well as a FAQ and HELP page.

The documentation is your friend as it has explanations and examples.

I entered the formula but it does not load
Verify the formula has been typed and not pasted. Google Sheets tend to paste text from docs and websites as “text” format instead of formulas. Many times, we have seen users copy and paste the formula which turns into “text” mode. A proper formula will have colors in the variables.

The formulas show an error and is not loading
In the Gorilla Sheets Functions Documents, we show how GorillaSheets is smart enough to use ranges and dimensional arrays.

Do something like =GORILLA_PRODUCT(A2:A10,”Title”) instead of =GORILLA_PRODUCT(A2,”Title”) and then dragging it down thousands of times.

To get bulk rankings, use =GORILLA_RANKING(A2:A100) instead of



Google Sheets will lock you out for 24hrs if you overload their servers with thousands of simultaneous requests.

Use ranges, and arrays in your formula to load data in one go without raising alarms at Google.

For the full list of supported functions and examples, see the Gorilla Sheets Functions Document.

My numbers are not correct
Please make sure your data imports have been completed by selecting Add-ons > Gorilla Sheets > Data Status.

Most of the time, users are comparing data immediately after signing up without giving the servers a chance to download all the required information.

The system requires time to go through every order over the past 2 years. Then it has to match it, clean it up, store it and get it ready for import.

Unfortunately, it is not an instant process after sign up.

As we are the only service that goes back in time to pull in historical data, there is extra processing time required.

My numbers still don’t reconcile 100%
Amazon has two types of clocks.
Their end of day sales data ends at 11:59PM each day.
However, their payment reports and order are processed differently. Some sellers have cutoff times all over the place. Amazon does not use a standard 24hr fiscal clock for every seller.

As we reconcile based on end of day (11:59PM) time, there will be slight differences.

GorillaROI also organizes orders and sales based on whether something is pending, shipped, not available to ship, etc. Therefore, the final numbers may differ due to the status of the order.

For more FAQ’s, please make sure to visit the help and faq page.

Gorilla Sheet Functions

For the full list of supported functions and examples, see the Gorilla Sheets Functions Document.

Click here to view.

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?