Demo Mondays #50 – Gorilla ROI – Google spreadsheets for Amazon sellers

Gorilla ROI is a Google Sheets Add-on that allows you to connect and import data directly from your Amazon Seller Central account into Google Sheets. Instead of exporting and manually processing the numbers, you can have your existing spreadsheets update by itself. Get direct and flexible access to your Amazon data without having to know code. Do things like bulk convert your ASIN’s to SKU’s or FNSKU, breakdown the fees and charges per sku, pull historical inventory level for projections, load the number of units sold by month, week, last year, last month and more. Streamline your data and work so you can focus on more important things in your business.

Gorilla ROI - 10% recurring discount for life10% OFF LIFETIME
Gorilla ROI - 10% recurring discount for life
There is no coupon code for Gorilla ROI, but if you follow affiliate links on this page you will automatically be offered a 10% recurring discount for life.
no coupon code needed

Gorilla ROI is presented by Jae Jun.

List of features covered in this video:


00:27 What is Gorilla ROI and how does it help Amazon sellers?
02:59 What is the target user of your software?
05:13 Marketplaces covered
05:49 Dashboard overview
08:39 Converting your current SKUs into ASINS.
15:13 Amazon sales performance
20:06 Tracking Hijackers
22:25 What are the requirements to use for your software? Does it depend on different browsers or platforms or can you use it in a regular software?
23:43 Multiple templates spreadsheets
25:01 Refreshing the data automatically feature
25:56 Pricing Overview
28:25 Upcoming features
31:04 Contacting the Support team
31:58 There is no coupon code for Gorilla ROI, but if you follow affiliate links on this page you will automatically be offered a 10% recurring discount for life.

Transcript – Walk-through of Gorilla ROI

[00:00] Augustas: Welcome to another session of Demo Mondays. Demo Mondays is a video series where I invite different Amazon sellers software developers, and I ask them to present their products just like this on the screen. And today my guest is Gorilla ROI.

[00:21] Augustas: And Gorilla ROI is presented by Jae Jun. Hello Jae.

[00:24] Jae: Hi Augustas. Thanks for having me.

[00:27] Augustas: Please, tell us very shortly: what is Gorilla ROI and how does it help Amazon sellers?

[00:37] Jae: Yeah, sure. I hope you don’t mind if I just start with a very simple story, it just explains how we started. So we are Amazon sellers as well, and we used to subscribe to 3-5 different software depending on what we were trying to do in the business. But the downside was it’s still only did about 80% of the functionality that we needed. So the remaining 20%, we’ll still have to manually log into seller central export data cleanup, excel files, organize it and then upload it onto our spreadsheets and share it with the team. And once we got to a stage where we just had to do it too often, it became much more expensive and we didn’t have up to date data on hand. And so we handed that off to my assistant. But you know, humans make mistakes and hourly work gets expensive.

[01:38] Jae: Plus when our team needed a specific up to date data point, it wasn’t immediately available. Somebody had to Redo it again. And so there was that delay. And so since we use Google sheets a lot to share numbers between our departments, that’s where the ID came about. So now it pretty much automatically imports our cellular data straight into Google sheets, just like how you can install like an extension for Google chrome. We’ve done the same thing by extending the functionality of Google sheets. So in it’s simplest form, and if I had to explain it in like one sentence, it’s Gorilla ROI allows you to load your seller data straight into Google sheets. And the problem it solves for Amazon sellers like me and a lot of them out there, is that it automates the manual spreadsheet process. So that you can get rid of that work that doesn’t really add value to your business. It eliminates the errors related to just copying, pasting. And you will have the flexibility because now you can pretty much pull the data and the information that you need as opposed to say, just using whatever Amazon gives you, you can customize things like that. So that’s the type of problems that it solves for Amazon sellers.

[02:59] Augustas: And what is the target user of your software? It should be a technical guru, right? The one who understands technical sheets ?

[03:07] Jae: Yeah, so that’s a good question. So we actually split it up. We have a very clear idea of who is going to benefit the most. And to split it up, we have our offering for two types of Amazon sellers. One type is the person who is just running a single seller account. So if you may just have one login. And then there are sellers where they have multiple accounts like agencies or bigger sellers with like five different accounts and stuff. So we’ve grouped them separately. But pretty much this 3 points that really hit home. And so for the first one, the best user fit is if you are a data-driven and analytical. So if knowing your numbers, or your client’s numbers is important and getting it fast is high on your list, then this is definitely for you.

[04:01] Jae: Secondly, if you do FBA only, so we don’t support FBM like a fulfilment by merchant and you need direct and flexible access to your data, then this tool is for you. Because honestly, there is no other tool on the market at the moment that gives you as much direct and flexible control as what we provide through Gorilla ROI. And third, we highly recommend sellers who are doing at least six figures because that means you have, it’s pretty much assumed that you’re going to have more than say, 7 SKUs And once you do six figures, the time that it takes to maintain spreadsheets takes way longer than if you’re a small seller. So if you’re brand new or you don’t have many SKUs, then this isn’t going to be the right tool for you, because you can probably do it manually and save cost that way. So just to wrap that up again, and first you’re going to have to be like a data-driven analytical person. Second, it’s for FBA only and third, for at least six figures in revenue, or at least seven SKUs and above where it starts to take time to start following and tracking your products.

[05:13] Augustas: All right. And what marketplaces for Amazon does your software cover?

[05:20] Jae: Yeah, so we cover all the marketplaces, except for India, we support all the current Amazon marketplaces. So that’s North America, Europe, Japan and Australia.

[05:33] Augustas: Great, so finally, we are ready to see how does your Gorilla ROI software looks like from inside, right? You will be showing us the software, the application and some Google sheets and how it works, right?

[05:49] Jae: Yeah. So we’ve had some templates that I’ll show you that comes with the application for those who may not have spreadsheets ready to go. And before I start, again our feature is really just one and that’s to input seller data into Google sheets. And since that’s what we specialize in and that’s what we so good at, that’s what I’ll show you and I’ll take you through the process of how it can be applied to your business, how we use it in our business as well. And that way you’ll be able to get a good idea of how it goes. So let me share my screen. So on the screen that you see, once you’ve logged in for anyone that logs in, this is where it goes in. But what I want to take your direction to is on the left side, there’s all these pretty much everybody gets access to these spreadsheets because we want people to just, we want to make it easy for people to use rather than having to learn everything.

[06:44] Jae: So if you’re busy, if you don’t have time to create templates and spreadsheets, then everything that we have here, you can just pretty much copy it straight to your Google account. And then you just add your credentials, activate the ad in. And it’s pretty much, we’ve tried to make it as easy to get going as possible, like play in play. So the first thing is I want to show you this training spreadsheet because it pretty much encapsulates the stuff that you can do with the add on and by being able to pull the data, I’ve got my demo account loaded and one of the SKUs that I’ve just created is AAAA1111 another one is BBBB2222. So just for the sake of this demo, I just manually type this in and now I’m going to get data and product information related to this SKU.

[07:37] Jae: So I’ve done a couple here, but I’m going to delete, say this image and I’m going to delete say this. It’s as simple as doing because we’ve pretty much added extra functionality to Google sheets. As long as you’ve used spreadsheets, Excel, it’s exactly the same thing except you’re now going to use our custom formula would start with equals gorilla. And then you see all these different functions that we support. The first example I’m just going to show you is right now, since this is our AAA1111 is our SKU. I’m just going to transform that into an ASIN. So I’m going to do gorilla underscore SKU ASIN, and then there’s all these different options that we have, but this is the one that I’m going to do because I want to automatically convert what my SKU is into ASIN. So I’m just going to select this cell and then I’m going to type in SKU2asin because that’s the way I want to transform it.

[08:39] Jae: And so let’s get rid of that message. And then it automatically converts your current SKUs into ASINS. So if you have like a long list of SKUs that you want to get the ASIN for, and right now you can also copy and paste or export, et cetera, you can already see how much time this is going to save, especially if you have like 1000 SKUs or 1000 ASINS and you need to quickly grab the SKU or the ASIN or vice versa. The second example is you can grab product attributes. So it’s something as easy, again as gorilla underscore product. And what I’m going to do is I’m just going to try and grab a new image. Like I have an example in the right side, this purple text here, but I’m going to grab the URL. So the first parameter is going to be the SKU and then I’m going to grab the images small.

[09:35] Jae: Oh, let me do that again. Small image on the SKU URL and I can pretty much leave it at that. I can add extra functionality to say I want the image from like my UK marketplace or my U.S or my France or my Australian market place, it doesn’t matter. And to do that then it loads me the URL for the actual image that I’m using. Now if I want to get the image version of that, all I have to do again is just simple Excel that I just wrap it inside the image function and then it automatically converts that into the image. So I can grab all the thumbnails and load it onto my spreadsheets and I’ll show you how everything comes about in the next templates. And I’m just going to run through these quickly because by now you can probably already get an idea of how this works.

[10:25] Jae: Now what I’ve already done, this at the top. Let’s do this. Let’s say I want to grab all my ASINS in my current account, I can add, and define which marketplace I want to grab it from. Like if I have UK and I just want to grab from my UK account, I can type and say, underscore UK and then do that. Or if I just want to do this thing or close it, just enter that formula. And it would show that in my demo account I have three ASINS and it just automatically populates. You can do other things like product category, where this product is helmet product that I got set up is under sports and outdoors. You can even go further down and get the exact category of the product. On this one, this formula pretty much shows you how much inventory I have in stock.

[11:21] Jae: So this is the formula where I’m using this SKU. I’m looking up all the products in the marketplace and I just want the ones on the in stock. So by having these inventory data specifically, you can do things like really projecting and getting a better idea and get up to date value of how much inventory you have, how much is being transferred, how much is being shipped inbound, and that way you get a much up to date idea of your inventory forecasting and projections. And so that’s how it works. let me take you to the next template, which actually pretty much shows it to you in action. So again, this is a template that you can copy it directly over from your account, like this one is for finances, but this is one. So if you say click it, then you can make a copy directly over to your account and save it to your Google docs.

[12:21] Jae: But I’m just going to close that because this one’s been loaded and you can see that right now. Let me just clear that up. Right now I’m grabbing the ASINS automatically. And if you look at the information or the formula here, based on this SKU, I can now pretty much create any sort of custom template that I need. So I’ve got the images here. I’ve loaded the product name from Amazon. So I’ve got all the product names here. I’ve got the matching ASINS in this column, you can see the total amount of inventory on hand. And so this really gives you an up to date data. For sure you can see it on Amazon directly when you log in. But when you have hundreds of different SKUs, it becomes very difficult to actually get a real good understanding of your numbers because they’re just so much going on in that page.

[13:21] Jae: And we’ve actually combined it to have on this same templates the last seven days, last 14 days and last 30 days. And the purpose of this screen is to show people how you can customize and create your own inventory quantity to ship. So this is just a basic formula that I created where if I was selling this helmet product in the last 30 days, I’m selling this much and based on just basic spreadsheet formulas, I’ve calculated that I have about 6.1 days of inventory on hand. So I created this formula that you can get where it’s telling me if I want to get my level back up to 25 or 30 days, I just have to send in this much inventory and you can see how hands off it is. If you have say a long list of a 100-200 different SKUs and it immediately tells you what to send.

[14:18] Jae: I also created a dashboard version of this so that I’ve cleaned it up and you can see, how many you get a very good quick glance of what products, how many is left, how many is being sold and how many to ship. And so this is just some of the things that you can do if you have data on hands. We have people and agencies who have to manage multiple different accounts. So they’ve created different dashboards for each customer or each brand, so as to keep things separated and to really get an idea and really stay on top of their numbers, so as not to go out of stock because one of the things they don’t want to do of course, is stock out where you lose inventory, you lose sales, somebody else will overtake you in the rankings and then it takes them more time to actually get your product ranking again.

[15:13] Jae: So that’s one of the things. The second most used template that we offer for people is this one because we offer so many presets, like when you go to Amazon seller central and you’re trying to filter your dates, mostly people just end at looking at this last 7 days, last 14 days and last 30 days simply because there’s no other way to quickly filter down different time periods. Whereas we’ve pretty much pre-calculated all the different time presets so that if you go into this page, you can see, and let me zoom in a little bit more. These are all pretty much presets where I know immediately how much I sold today already. If I want to update this data, all I have to do is click on ad-ons gorilla sheets, the actual add on that you’ve installed. And then I’m going to collect refresh data and everything starts pulling automatically.

[16:16] Jae: So depending on the size of your account, if you have million dollar sellers on our account, but it’s still loads within a few seconds. And especially if you have like 1000, 2000 SKUw’s, it may take a little bit longer. Right now this is a demo account, so everything is a little bit slower, but in the production version for your account, everything loads much quicker. But now you can see and then just let the add on, finish updating. And pretty much it’s put in every single calculation for today and yesterday, and all these different time set time periods where we have many people who don’t really care about last 30 days because they’re trying to get the inventory up to last 90 days because they’ve got to work out their lead times with China, the time it takes for them to ship, and pretty much have enough stock on hand.

[17:11] Jae: So they always look at the last 90 days. And until they started using Gorilla, they were having to constantly download their metrics every single day, updating with multiple times a day. But with this, I could easily change this from say the last 60 days because the formula, I’ve got everything loaded. I’m just going to change my time period here, I’m going to change it to last 3 months and then this will start loading again and it’s going to show automatically pull in the units sold over the last 3 months. And this way you can pretty much understand how your product and how your business has been performing as well as how you can expect it to perform based on easily being able to project. Like if I look at last year compared to say there’s another number for like the first one, let’s say I sold like close to 9,500 and then this year, so far I’ve done 4,900.

[18:11] Jae: So based on this idea, I can pretty much assume that this product will sell about a little bit more than last year, but about the same, and so you can do projections. You can get better accurate inventory projections when you order so that you don’t go out of stock. And you can also make it easier for like peak seasons and off peak seasons and knowing when. And again same thing, but this time we have it in dollar value. So you can have inventory count as a dollar amount. So you can actually see, like if I go to say this year, how much of each product I’ve sold this year, this quarter, this month, how much I sold at the same time last year and so on. So again, this is very good for accounting, just keeping track, et cetera. And so this is another dashboard where I’ve pretty much reorganized the sales stats into a table format to make it easier to see.

[19:12] Jae: And again, this is just some of the things that you can do. There’s so much more things that you can do. It’s all about your creativity. And if you’re already doing six figures and you have lots of different products, you probably have your own dashboard so you can just feed the data straight into it. So rather than doing updating or manually, now, you can pretty much update everything automatically. We also have ways to pull in reviews. So that way you can filter down and really look up reviews, get the direct links, et cetera. Right now, let me pull this down, like that’s get that updated so I can get a quick idea of what my top 10 rated products is, based on the rating, all of this information can be pulled automatically from Gorilla with those custom formulas.

[20:06] Jae: And so again, it’s the same type of format. So if you speak the spreadsheet language, if you think spreadsheets and everything else is like your first given language, then this is going to be perfect for you. And lastly, the final template that I want to show is again, I use this one in a way to track hijackers, so I have the title that I’ve entered into Amazon and that automatically pulls it here. And then if I want to say, let me close that, let’s say that my title is this one, and let me get rid of that.

[20:54] Jae: Like I’ve got this Fox Proframe MIPS bike, that I’ve used into Amazon. And so what I usually do is I just paste the value in, and so this is pretty much, I know that on any given date, like today when like let’s say today is like January 1th, 2020, on this date, I know that this is the title I updated. And for whatever reason, if a listing gets hijacked, then the first thing that hijack do is that they try to change your title or your image. And so if for any reason this title does not match with this title, then I know there’s somethings wrong with the listing. If my image all of a sudden gets changed, then again, I know that it’s been hijacked. So this has actually helped us on many occasions where we were able to detect hijackers within 10 minutes of it happening and we got straight onto kicking them off.

[21:49] Jae: Simply because it was just so easy to recognize because we are using spreadsheets all the time and I immediately noticed that our image changed and our title changed compared to what my original was. So these are just some of the ways that you can actually use it. So being able to have that flexibility and direct access to your data and pulling what you need, you can come up with all your creative ideas or you can just easily automate and simplify whatever you’re doing at the moment and just eliminate all the manual work out of it. So that’s what Gorilla ROI does. And I hope that I have showed it clearly.

[22:25] Augustas: All right. Quiet advanced sheets that you are showing to us. So my question actually is what are the requirements to use your software? Does it depend on different browsers or platforms or can you use it in a regular software?

[22:45] Jae: Yes, so since this is just based on Google sheets. One, you definitely have to have a Google account and two, you have to use Google sheets. You can use it on any browser. So if you use it on Safari, Chrome, Firefox, Internet explorer, it works since it’s just loading within Google sheets. So if you go into menu, add ons, then that’s pretty much all you need. And then the rest is just really just Excel or Spreadsheet formulas and lots of people have just been able to jumpstart it right away even if they were fairly new to spreadsheets. We’ve got the templates that are easy to set up and we have some really great videos and tutorials. So there hasn’t really been that many issues with people actually getting it going.

[23:30] Augustas: So you have mentioned templates, so when someone signs up for your software, for your service, are they receiving a big collection of templates to work with?

[23:43] Jae: Yeah. So right now we have multiple templates. There’s a basic version where it’s just a very simple version to get you started and so everybody gets access to that no matter what plan you sign up for, everybody gets access to that. Also on our website, we also have a lot of these templates available for free so you don’t have to sign up for anything. Some of those because if you don’t have an account, you just have to update some things manually, but it’s easy to just get started right away, for people who really do want more templates and more spreadsheets, we have an upgraded and improved version of that, but that’s if you want to upgrade to the pro spreadsheet version, but like I said, there’s a free version all those ones that you’ve seen on screen today, they are all free and you can start using them right away.

[24:34] Augustas: Yeah. So that’s great. And I wanted to ask about how often this data is updated, and in one of the spreadsheets you showed how you go to the menu of the sheets and you activate, and you reload the data so that it pulls the newest information. Is it always when we have to update the sheets, we have to go these steps or some information updates automatically?

[25:01] Jae: Yeah. So there’s a feature that I didn’t show in the demo because it’s automated where you can actually enable refreshing the data automatically. So you can set it to refresh every 4 hours, 5 hours. And that way if you don’t want to click around, then that doesn’t like that. But if you go into the menu and then you refresh, you’ll always pull the latest data. And the way we do it is we are constantly calculating and making sure that all the latest dates presets like the last 7 days, the amount today lost, how much you’ve sold over like in this whole year, that’s constantly updated. So anytime you refresh, you’re always going to get the latest and it’s just a matter of preference whether you want to click it yourself or you can set it to do it automatically.

[25:47] Augustas: All right. So let’s talk about the pricing. Can you tell us, what plans do you offer for Amazon Sellers?

[25:56] Jae: Yeah. So as I said initially, there’s two types of accounts that you can get. One is for regular sellers and the second type is for agencies and people with a lot of different accounts. So the easiest one is for the single seller. And this is the pricing. Anybody can get started for free, it’s unlimited for any 3 SKUs that you have. So if all you have is 3 or less SKUs, then you can pretty much use our service completely for free. So we have several hundred people doing that already and you can just from any Google sheets, go to add ons, get add-ons. And so this will load up like all the add on supported by Google sheets, then just typing Gorilla and you can pretty much find it and then install for free.

[26:46] Jae: So this first one is for people with just one seller account. And then this one is for people who have 3 or more accounts. So that’s a difference. So for the pricing, if you just have 1 or 2 accounts, if we do it based on the number of orders, so if you have less than 3000 orders a month, then you’re going to be on the starter plan from 3-10K, you’re going to be on the pro seller account. And if you do a lot of sales and unlimited orders, then this is this pricing. So it’s just one flat, pretty well I wouldn’t say flat. It’s only flat for the unlimited. There’s an overage charge. If you say like on the start, and then all of a sudden you did a million sales, then you’re going to get charged for those extra orders at 1 cents per order because of all the extra processing and the server run times that we have to go through on the agency plan.

[27:42] Jae: This is where it’s different. It’s just one flat pricing. So with $199 per month, you get 3 unlimited accounts. So no matter how big your accounts are, we have some agencies which have clients doing several multimillion dollars. And so that takes a lot of processing power. But you can add any 3 unlimited. And for any extra accounts that you want to add, it’s additional flats, $25. And you can get all that from just Go to our website and click on the actual product. And then you can see the pricing information. But for the majority I would say 9 out of 10 people, this is the pricing that will match what you’re looking for.

[28:25] Augustas: All right, perfect. And could you tell us a little bit about your upcoming features, which are probably additional formulas to the sheets, right?

[28:36] Jae: Right. So instead of features, we add functions and formulas so that you can pick and choose and get a better accurate number that you want. And one of our latest is, let me quickly show my screen where people have been wanting to pull in their fees and charges that gets collected by Amazon as opposed to just being, having to look into reporting, getting their accounting statements and payments statements. That’s one of the biggest hassles trying to go through their transactions. So in this spreadsheets, you can enter the different periods. Like right now I’ve just loaded 2018Q2, Q3, Q4, Q1. And you can get detailed information of your account or per SKU of how much you were charged, what went out, how much shipping was paid, how much tax was collected, etc.

[29:40] Jae: And because you can get this on a per SKU basis, you can actually find the exact profits that you are really making on the product. So there’s no guessing. So if you love accounting as well, if you’re a data geek like I am, then this will help you. For example, like just looking at my refund phase down the middle here, there was an a month appeared where this administration fee was extremely high. And so when I started digging into it and asked Amazon, it turns out that a lot of refunds were provided except I wasn’t paid back in return. So that’s a case where I got a lot of reimbursements back simply because I noticed that a number was higher than normal. And so all of this can be directly put on a per SKU basis, on an account basis. You can get this last 7 days, last 30 days, et cetera. So that you are always on top of your numbers. So these are the type of functions and features that we provide. The next one is that we really have plans to get to is that we want to create a Microsoft Excel version. So for people who don’t use Google sheets, it’s pretty much the same thing where you can do it directly through Excel, and in that way we can extend the product further. You don’t have to keep it online, you can just keep it locally as well.

[31:04] Augustas: And one of the final questions, how people can get in touch with your support team and if they have presale questions or existing customers?

[31:14] Jae: Yeah. So you can go directly to our contact page. So we have multiple ways that people can contact us. We try to make it easy. So we have a dedicated ticketing system, that you can find directly on our website. You can use our contact form and then that gets transferred directly over to our system. And there’s my email that you can also find on the website or probably just by clicking somewhere on the page down below and you’ll be able to find my information too. So we are very quick to respond with support or just general questions and we’re more than happy to help people and to just make sure everything is up and running.

[31:58] Augustas: Perfect. Thank you very much. And for those who are watching, check out the description below this video and there might be some discount for the services of Gorilla ROI. And thanks a lot Jae, for this presentation of this unique product, which is, I don’t think it has any analogy in the industry.

[32:19] Jae: Thank you. Yeah, thanks Augustas.


 

DEMO MONDAYS is a Monday video series hosted by Augustas Kligys, where the creators and owners of Amazon seller softwares are invited to demonstrate their tools to the audience. Watching these presentations will help you decide, which software to choose for your Amazon business.

About the Author Augustas Kligys

Augustas Kligys is the host and creator of several popular virtual and in-person summits for Amazon sellers. The first one is European Private Label Summit, which covers a lot of important topics for those willing to grow their Amazon FBA business in European Marketplaces. The second - AMZ Seller Summit - an event, where experts shared their Amazon business optimization secrets and mindset, which helps to elevate your business to the next level. Augustas also hosts weekly DEMO MONDAYS video series, where Amazon seller tools are demoing their products. If you want to meet Augustas in-person, visit one of his live events for Amazon business owners: European Seller Conference, PPC Congress, and Seller Fest.

follow me on:

Leave a Comment: