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.
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 selecting Add-ons > Gorilla Sheets > Data Status.
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.
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 like 3am or 11pm.
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.
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.