To start using Gorilla Sheets, you must provide your Amazon Seller ID and the MWS Auth Token generated at the beginning of this tutorial.
To enter your Seller ID and Auth Token, follow the steps:
1. In the menu choose Add-ons > Gorilla Sheets > Add Amazon keys
2. Enter your Seller ID and Auth Token you got from STEP 1 after authorizing our developer ID.
Select your default or main marketplace. When a marketplace is not defined in the formulas you enter, it will assume the default marketplace. If you sell on multiple marketplaces, you may enter additional marketplaces by going to “Add-ons > Gorilla Sheets > Add More Amazon Marketplaces”
Once your Amazon account has been connected, the system will start downloading your data.
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 your sales volume.
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.