How to Get Started with Gorilla Sheets Agency

We regularly update documentation and the FAQ list

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 User Permissions page in Seller Central and login as the primary user of your Amazon Seller Account. 

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

amazon mws

3. Then click on Authorize new developerin the next window.

4. In the Developer name text box, enter Gorilla Sheets. 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. 

6. Your Seller ID and MWS Auth Token appears.

6. Save or copy the Seller ID and MWS Auth Token to enter into Google Sheets.

crucial info

Step 2: Setup the Seller Accounts & Email Account Permissions

1. Log in to your Agency Dashboard& 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.

3. 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

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.

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

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 Check

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

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

=GORILLA_RANKING(A2)

=GORILLA_RANKING(A3)

=GORILLA_RANKING(A4)

=GORILLA_RANKING(A…)

etc 

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.

About

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