Gorilla ROI helps Amazon sellers and agencies easily load Amazon data inside Google Sheets

Getting Started – Install Instructions

Select your addon version instructions

Give Access to Gorilla ROI

1.Seller Central manage apps > authorize our Gorilla ROI developer ID

Getting Started with Gorilla Sheets 1

Then click on “Authorize new developer” in the next window.

Getting Started with Gorilla Sheets 2

2.Authorize our Gorilla ROI developer ID for your marketplace seller account

Our Gorilla ROI Developer ID must be authorized to pull data on your behalf.

Do it for each seller account you have.

2a. Our USA/CA/MX/BR Developer ID is 447136896315.

2b. Our EU Developer ID is 642105350512.

2c. For Japan sellers our Developer ID is 626257519921.

For JP main sellers: use this shortcut link

2d. Our AUS/SG Developer ID is 690386913621.

Getting Started with Gorilla Sheets 3
Getting Started with Gorilla Sheets 4

3a.Go into your Gorilla account at app.gorillaroi.com and get your user ID.

3b.For FREE users, create your free account at app.gorillaroi.com/registerFree.php to get your user ID

Getting Started with Gorilla Sheets 5

4.Use incognito browser > open a new spreadsheet or existing spreadsheet

5.Menu > Add-ons > Get Add-ons > search for “Gorilla”

Getting Started with Gorilla Sheets 6

6.Follow prompts and install the add-on

7.Menu > Add-ons > Gorilla > Use this Addon

8.Menu > Add-ons > Gorilla > Add user ID

Getting Started with Gorilla Sheets 7

9.Enter your User ID and save. If it doesn’t save, do it in incognito mode because Google is caching your G Drive.

**FREE users stop here and skip to next section**

10.Wait for the data import process. Will take a couple of hours or more based on your size.

11.Run a simple test. Type in =GORILLA_SKULIST() in an empty sheet.

FREE User Instructions

1.Follow the common install process in the first section

2.After getting a free account from app.gorillaroi.com/registerFree.php, enter your seller ID and token you received from Amazon under “Seller Accounts” and save.

Getting Started with Gorilla Sheets 8

3.Enter the 3 free SKUs from Google Sheet > Add-ons > Gorilla > Add 3 Free SKUs (NOT ASIN)

subscription id

4.Save. Now you can pull data for the 3 SKUs you entered. Do not enter ASINs into the 3 free list.

5.Wait hours. We are not Amazon and do not have your data. Must be imported. Free accounts update slower. 2-3 times a day only. We allocate resources to paying members for faster updates.

6.Run a simple test. Type in =GORILLA_SKULIST() in an empty sheet and it will show the 3 SKUs you entered.

SINGLE BUSINESS Plan (Paying user)

1.Follow the common install process in the first section

2.Go to your account at app.gorillaroi.com and click on “seller accounts” on the left menu

3.Click the “+” icon to add your seller account into your profile and enter your seller ID and token again and set your country.

Getting Started with Gorilla Sheets 8

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

download status

5.Go back to your spreadsheet > Refresh the page. Your spreadsheet will now pull in all data without limitations.

6.Run a simple test. Type in =GORILLA_SKULIST() in an empty sheet to list all your SKUs.

AGENCY Plan (Paying user)

1.Follow the common install process in the first section

2.Log in to app.gorillaroi.com > Add the Amazon seller accounts (get the Seller ID and Auth Token from each account that you add for Gorilla ROI to be able to import)

Getting Started with Gorilla Sheets 10
Getting Started with Gorilla Sheets 11

3.Add Agency Users > Enter all authorized Google Account emails that will access the data (accounts NOT on this list cannot view or pull data for security reasons)

Getting Started with Gorilla Sheets 12

4.Enter your AGENCY ID from your dashboard into the spreadsheet addon to activate the addon

Getting Started with Gorilla Sheets 13
Getting Started with Gorilla Sheets 14

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

download status

6.Run a simple test. Type in =GORILLA_SKULIST(“one_of_your_seller_ID”) in an empty sheet to list all your SKUs.

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.

Getting Started with Gorilla Sheets 15

I entered the USER ID, but nothing happens and it does not save.

Use incognito mode browser to install the addon to get around Google’s aggressive cache that could prevent your spreadsheet from saving your seller ID and token details.

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 Gorilla ROI 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.

 

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.

The numbers are not correct

Please make sure your data imports have been completed by checking the status at http://app.gorillaroi.com.

Most of the time, users are comparing data immediately after signing up.

 

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.

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.

Why choose us?

We specialize in delivering data from seller central straight to your spreadsheets.

The way you want it, when you want it, how you want it.

WE UNDERSTAND AMAZON SELLERS AND AGENCIES

30 DAY MONEY BACK GUARANTEE NO QUESTIONS ASKED

HIGHEST RATED AMAZON ADDON FOR GOOGLE SHEETS

100% SECURE VIA 256-BIT SSL. DATA OWNED BY YOU.

STELLAR SUPPORT IS STANDARD