Transcription
All right, the things that you can do with Claude is getting actually insane. Everyone is freaking out now because Claude just announced that they can actually sync to your Google account. So that means it not only is going to have full access to everything that you have in your Google Drive, but it can also connect to things like Google Sheets. And today in this video, we're going to go through step by step how you can make these three top selling digital downloads that are selling every single day on Etsy.
For example, this one sold 58 times in the last 24 hours and has over 200 add to cards. This one has sold 15 times in the last 24 hours and is sitting in over 100 cards. Digital downloads like these in Google Sheets are performing extremely well because they're solving a very specific problem that they otherwise would have to spend days or weeks creating on their own to solve in Google Sheets. And with Claude, we're going to build it in a matter of minutes. And I'm giving you all of the prompts down below that you can use for your own Claude account.
In this video, I'm going to show you one, how we actually validated and found these winning products. And then number two, I'm going to show you how to set this up. And number three, I'm going to show you how you can launch each one of these in your Etsy account successfully so that you can guarantee results like the first one we saw that is selling 58 times in the last 24 hours. So, without further ado, let's get into it.
The very first step when you're looking for products to sell on Etsy or even on Shopify is validating the market. The biggest money and time waster in e-commerce is not validating the product before you invest time into selling it. The worst thing that you can do is launch a dead listing. So, we're going to go ahead and show you exactly my quick research method of how you can validate quickly elevate and produce that product to go to market as fast as possible.
So, I'm going to come into Profit Tree right now, and I'm just going to type in the keyword digital, right? Digital keeps it very broad. So, that means that any listing that is a top listing with the word digital in the title is going to be shown to us. Now, I'm going to add a filter here because I want to only see higher priced digital downloads. All I care about is selling higher ticketed digital downloads. So, that means the minimum price has to be at least $20 because I don't want to sell a digital download that's only selling for a dollar, right? Every single time I get a sale, right? As we saw in that first example, 58 sold in the last 24 hours and it had a very much higher price point than the average digital download. So, I want to go for higher ticket and I want to look at only listings that have a max age of say 12 months, right? Because I want to find listings that are selling hot right now and higher price point. And then I'm just going to add a listing type option here. So, I only want to see digital products since we don't we're not selling a physical product. With these filters in place, we're going to be able to see only those top products. And let's just scroll through here. So, this indicator means that it's sold at least one time in the last 24 hours, right? And it's had over 100 people sitting in their carts, right? This is really, really valuable data. So, this is already giving us some really, really good insights, right?
And now we are gonna be building a product for Google Sheets. So, we're going to try to find ones that are built in Google Sheets. So, this one is sitting in 60 carts right now and it's only 10 months old with an estimated revenue of already $9,000 per month. So, let's actually go ahead and click on this listing. After the discount, it has $35. That's an amazing price point. And you can see eight people bought in the last 24 hours. So that's already over $100 a day just on this listing. So I'm gonna actually go ahead and begin tracking this listing so I can add it to a collection. So I'm going to put Google Sheets digital download. Right? And this is going to help me prioritize which listings I actually focus on first, second, and third. Right? We want to focus our efforts on the ones that are going to make us the most money. So that is the first listing. Let's see if I can find any other Google Sheets, right? Digital downloads. I'm going to add in digital and I'm going to put in sheets just to see what other listings come up since we are going to use Google Sheets. So, here's another one. Ultimate Finance Dashboard. It has sold at least one time in the last 24 hours. Perfect. $140, $15 is also a pretty healthy price range. So, I'm going to go ahead and track this listing as well. And I'm going to go ahead and add that to my folder there inside of Profit Tree. Let's see what other ones we can find. Okay, this one is a green budget and goal tracker. Three people bought in the last 24 hours. That is a really, really good sign. So, we are going to go ahead and add this one to our folder as well. And basically our goal is that we're going to end up making all of them, but we do want to know which one is actually doing the most money. So we can prioritize what we focus on first, second, third.
So now if I go back into Profit Tree and go into the listing tracker, I can come into that new folder that I just made, Google Sheets Digital, and we can actually sort it by the total monthly revenue. So, I'm going to do total monthly revenue because I want to see which one is making the most money at least this month. Okay. So, this is the winner here and it is that wedding planner. So, when you're planning out your product launches, I would focus on the ones that are doing the most money. Eventually, you're going to want to make all versions, right? And even split test each version multiple times with different brand buys, but to start, we just want to make sure our priority is in the right place.
So now, if we wanted to actually go ahead and recreate this in Cloud, we just want to be clear. Well, actually, Claude is going to tell us what we need to do to compete. What are all of the key attributes that we need to do to compete on? So, it's obviously in Google Sheets. There's 25 tabs, multiple color schemes, there's even a video tutorial with it, and instant access. Okay, we just want to scroll through here and see what are all the clear data points that we need to have in order to compete, right? And basically Claude is going to do a lot of that work for us. So let's get into that because we have a special guest that is going to show you how to recreate the three top products that we pointed out in the beginning of this video. So let's get into it.
All right, guys. I'm super excited because we have Will Brnegger here today. He is a Claude specialist. He has been mastering vibe coding since the second it's launched. We post him with the challenge of actually making those three top designs that are making hundreds of dollars every single day. We are going to start with the book tracker. So, Will is going to take us through a step-by-step tutorial on how to achieve each one of these. Below in the description, we're going to be giving you the prompts and every single thing that you need to do, all the steps to recreate exactly what we're doing on screen. And then you can even use that as a framework for future digital products that you find that are bestselling on Etsy.
So, step one is obviously just downloading Claude and getting it onto your desktop. You're just going to go to claude.com/download. Whether you're using Windows or if you're using Mac, you're just going to hit download for Windows. And this will automatically download to your desktop. And then you'll open up that file. Click start setup and run through all of the initializing Claude setups for your computer. And then once you have Claude open on your computer, you'll initially be brought to the chat page. You're going to want to navigate over to the code page. This is where Claude is actually going to be able to create those codes and create these things that we wanted to create. Has just a little bit more power. and could use a little bit more skills than the regular chat.
Before we jump in and get into Claude, I think it's important to understand how Claude actually operates. When we just say, "Hey, go and recreate this product," it doesn't work. And you get really sloppy results. And that's exactly what happened when we first tried this. So, what we had to do is we had to dial in the skills and create a prompt for this session that tells Claude exactly what we want it to do from going in and actually analyzing what the product is, what the goal of the product is. We have to pull screenshots of what the listing is to actually show Claude what we want and then tell Claude, "Hey, don't just make, you know, a spreadsheet. Make a spreadsheet that's pretty that people like that people can, you know, it's an interface that people can understand. Otherwise, you're just going to get a regular spreadsheet with just columns filled and it's just an absolute mess."
Always going to start off by just opening up Claude code uh in your desktop and just put it to a file path that you want everything to get saved to. I just have it on my user file path. This is just where everything is going to get saved to, right? This is where you'll find it in your folders and everything. That's the first step is where's everything going to go on your computer because this is all running locally, right?
So the reason this is already automatically saving to his computer is because it's just it's already in my file path. I selected the file path the you know maybe if I wanted to create like let's say I wanted everything to be organized in a certain folder. Let's say Etsy shop. I just create a folder called Etsy. Just hit new session. You're going to hit that folder here. Choose a different folder and then we're just going to go down I think it was on PC local setup under users and then you'll just pick I think we had it in here Etsy right and then now we're just going to operate in the Etsy folder.
Second thing is the prompt. We want to actually review what's in this prompt so that in the future you guys can have a better idea of what actually, you know, is in those initial prompts for you to go and be able to do these things, right? So I want to pull this prompt up here. This is the prompt that we are going to be giving you down below. Is that correct? Yep. This is the prompt that we're going to be giving and it gives us exactly why it makes a spreadsheet worth $15 to $50, right? Because that's what we have to define is the success. We have to define what is good, what is bad, and what is our output goal, right? Which is creating a $15 to $50 spreadsheet that, you know, spreadsheet that we can actually make money off of. So, we have to get it into that role, right? So, we're telling it that it's a premium digital product builder. You create sellable Excel spreadsheet products using Python's open pyxl pixel library. And then when given an Etsy listing link, you research the product category and for all tabs and features and build a complete premium product that could be sold for $15 to $50. Then in here, we just define, you know, why this what makes it something that sells for $15 to $50. So you have like grid lines off on every tab, maximum two fonts, just things that really make it a different spreadsheet than just an average, you know, spreadsheet that takes a day for you to set up. This is something that's going to be interactive and actually be something that you can sell. Tab colors, row heights, spacers, titles, everything that just makes a clean interface, we've already put it in here so that when you drop a prompt, it's pretty simple. If there was a fitness tracker, we just gave it examples. Like if we gave it a fitness tracker, it needs to infer what's going to be in the tabs because we're not going to just buy the product and replicate it. We're going to actually just give it a link, have it go review the screenshots of the product listing, and then create it. So, we need to give it other examples other than the ones that we're about to go with, like the wedding planner, the book tracker, and the annual budget spreadsheet. So, we've given it a bunch of different examples. That way it can actually have an idea of what would be inferred if it has to create something. This is the time that you spend with Claude actually tweaking your plan before even implementing it. And this is going to save you a ton of time versus trying to go back and iterate the things that you create with Claude. And you're going to burn a bunch of tokens trying to iterate things after they're produced versus taking the time and creating a plan that Claude can actually execute on. And you've defined what good is. So you know that the output that you get is what you want. Cool. So we're going to send this prompt. Trust this workspace. Cool.
So now that the prompt's in here, it says ready to build. Give me an Etsy link or describe the spreadsheet product you want and I'll identify the category, lay out the build plan, and start creating. All right. So we're just going to drop the link in here and let Claude get to work. Awesome. So, literally within like 3 minutes, we have Claude giving us an entire plan of what to put in each tab and it's gone on to choose a color palette that is also selling well. And then it's just asking if it wants us to proceed with everything that we did. So, in here, if there's anything that you want to tweak, maybe we want to add to the reading challenge another metric in there, we can go and do this and add different things to each page. Maybe we want to add, you know, YouTube where you do a video of the instructions of this. You add it here. This is where you, you know, perfect your plan. That way you don't have to iterate things that have already been made. That's how you burn all of your Claude tokens.
So, another thing here, guys, is that obviously Will made this prompt for you. The longest part about this is actually crafting these prompts. So, again, we're going to have these for free in the description below. But another thing that you can do is if you want a specific brand vibe or color schema, you can also submit screenshots in this plan. So the project plan above that it's processing right now, you can include other brand vibes or screenshots of what colors you want and stuff like that just so it can make it more your uh genre or niche style. Like you can see it says earthy greens plus blush, which is honestly perfect because that's what we're trying to do. But even taking more screenshots of your competitor's product image and stuff like that is all that information is going to help as well.
So this happens from time to time where you just have to continue and tabs built ultimate book tracker. Let's take a look. Got it. Okay, cool. So it downloaded. Now let's just take a look. Find where our file is. Looking for the book tracker. We're just going to drag and drop it into Google Drive and that'll load us in with the book tracker. We are. Now, when you want to put this into your Etsy listing, when you're actually creating the Etsy listing for this, we're going to show you what to do next. Because you're not going to want to send people directly to this page. You're going to want an intermediary page, but let's see what we got here. So, how does this work? This is off of one prompt that probably took Will a couple hours to make. Just a couple. Just a couple. Only only one long night. [laughter] No. But awesome. So, it starts with an instructions page. That's what we wanted. So, we go to the setup tab to configure your reading goal and preferences. Start logging books in the book tracker. Watch your dashboard come alive with charts and statistics. Use the wish list to plan your next reads. Browse your books gallery. So, it looks like it has everything that we wanted. So, let's take a look at it. So, we have the setup first. So, we have a ranking system. We set our goal of books that we want to hit this year. Let's just change this to 50. Reading. Currently reading this book. Completed the book, did not finish to be read, paused for now. This all looks good. We have all of our genres. If we want to add any genres, we could just add it here. So, this looks pretty good. We also have on our left side all of these that have links. So, I can just jump over to our next tab of our book tracker. And let's just add a book here. Think in rich in going to call it a self-help book. Say we finished that book and it was a four-star book. It was a physical copy. I don't know the pages. Say we started December 5th, 2025. Cool. Have a reading calendar. So January, we can change it by the month. Awesome. Set which books we want to read for which months, which days. They have a calendar. Our wish list. Same thing. Has all the genres in there. Cool. So this is the part where vibe coding really becomes the vibe part because Claude's going to give you the bones. But the part that defines creativity and breaks, you know, you apart from just AI outputs and why it's called vibe coding is because now you get to put your touch on it. So we get overlays like this, image overlays and all of this just happens so much. It's something that sometimes we just can't prevent even using the perfect skills and everything. So I'm just going to come in here and delete it. We're just going to find a cool library. This looks pretty cool. Probably doesn't match the Etsy vibe. This seems like it might match it a little bit. So, I'll copy this, drop it in here, and just set the kind of vibe that they're looking for in their dashboard. And we might add a couple more just to give it a cool look. Cool. And now we have 10. What is this? 1, 2, 3, 4, 5, 6, 7 tab book tracking dashboard that gives you the ability to track all your books, rate them, create reading calendars, wish lists, and a total dashboard showing you the pages you've read, your total averages, how close you are to your reading goals, and how many books you've read, which is pretty close to what we saw on the listing. I think this is pretty kick butt. What How do we do, Hannah? I That's It's insane. I mean, that's insane. With one prompt, that's that's what we got.
So, now let's go to the second one, which is the wedding planner. This one I feel like is a little bit more advanced. So, let's see what we have to do to complete that one. 20 people bought this in the last 24 hours. That's a $200 a day product that we're about to make in the next three minutes.
All right, so let's take a look at this. So, first we just want to pull up the product, get a good idea of everything that's in it. Again, it's five coding. So, if you have a good idea of what is going to be in it, you can tell Claude if it misses anything or maybe things that we could add to it, right? So, we're just going to get a general idea of what's in here, read through the description, take a look of what we're kind of going for from this, right? So, we're just going to scroll through this, get a good good idea, good glimpse of it all, and then we're just going to take our prompt. Same thing as we did before. Same prompt that I used on the previous one. It's just a prompt that we can use for all of them to reproduce our spreadsheets. Awesome. It says ready to build. It's read our full prompt. So, we're just going to go ahead and paste the prompt or the URL of the listing. Hit send. Let's see if it gives us back any questions. Awesome. So, it's caught all of the tabs that are on the that are in the listing. It says key features, days left, countdown on every sidebar, cross tab, dashboards with six charts, budget variance with conditional formatting, guest to RSVP. So, it's got everything. It's really analyzed it pretty well. One thing that I don't see in here that I saw on the in the screenshots on the listing was a couple of the pie charts and line graphs that I didn't see in this description. So, I'm just going to customize this a little bit. And I'm just going to say, "Hey, we want more pie charts and line graphs." So, let me write a prompt for this. Awesome. So, I just typed this quick little quick short prompt here. Just said, "Incorporate more pie charts and line graphs with detailed headers explaining what they're tracking. Incorporate these on pages that have stats or numbers that are easier to analyze visually. Make sure these are properly spaced, no overlap, and match the same color we have set for this project." So, we're just going to hit send. Just a couple small changes to it and let this thing get to work. Boom. All right. Wedding planner in our folder. Let's go ahead and open it in the folder and see what we did. How to use your wedding planner. All right, this is insane. Let's see how we did. All right, so we've got the instructions page. Entering your data, dashboards, charts, customization, tips for best results, fill in the budget tab early, update the timeline tab weekly, use the guest list tab, the vendors. Cool. Let's see. Setup. Partner name, wedding details, wedding date, partner two, venue name, total budget, currency, estimated guests, wedding style. All right, so we can pick from a couple different styles. Custom theme. Love it. Cool. Save the date. Okay, cool. Theme. We've got our overall theme. I love it. Dashboard. Nice parts again where we just have to move things around. Oh, no. Look, we don't even have to move it around. Oh, wow. Wow. This is going to be for I guess wedding uh coordinators, wedding planners. Yeah. Cool. Somebody that maybe just wants to plan their own wedding. How do we make those numbers fit that cell there on column? Nice. Oh, okay. Then you want to go through and just take notes, right? Yeah. So, let's say like like this, right? The spacing on these. Maybe we want to make it even with the picture. Take a note of it. Write it down. These are all things that we're going to come back to Claude with. Right. Packing list. Looks good. Maybe we could add some more slots on there. Vendors. I love this. Vendor costs. Showing them, you know, the full breakdown of where they're spending money. Amazing. I'd say this is even this has more than what was even on the Etsy listing to begin with.
Let's go ahead to the big money one. So, this is the last one here that is doing 50 units in the last 24 hours. You know, once you complete a task, move on. Go to a new session because each session contains context, right? And you might be trying to create your wedding planner in one conversation and then you might be trying to create a financial planner in the other session. And what ends up happening is the two get mixed together and you just don't have the best outputs and your tokens and your context starts getting too big and bloated and it's not direct. We want everything to be direct. This is exactly what I want. This is the output for this session and then that's it. I'm never going to return to it. It's only used for one task. So that's exactly what we're going to do. We're just going to open up a new session. We're going to keep it in that same file path. Hit enter. So, it's going to ask us for a link. Again, we just want to do a deep dive of everything that's in here. It has downloaded locally. So, now we are going to put it into Google Drive and see what we got. Your complete financial planning toolkit getting started. So, again, we've got a clean instructions page. Looks good. I think the colorways are solid. It seems like those are what does really well on Etsy. Easy setup. Cool. So, we've got your personal information, your current symbol, your start month. So, when we're going to start this, your budget period if you want to do this monthly, bi-weekly, or weekly, and then we're going to get into it. Your income sources, expense categories. Oh my gosh. Your need, want, and savings, total expenses, monthly. Looks like you have the ability to go through for each month, January, February, March, April, and so on. We've got an all-in-one dashboard. Again, we talked about it. Visuals just love to overlap. So, we're just going to move a couple things around. So, if you put in like a different number at 1500, it will calculate the difference already for you automatically. So, it's already made for you. $300 difference. We haven't filled out all the other months, but Yep. January looks to be working. Nice. What do we have here? 50, 30, 20 needs 50%, wants 30%, savings 20%. That's awesome. Kind of helps you break it down. Nice. Expense distribution. Okay. So, because you get a set categories in here of like what you're spending on, I guess it actually shows you where your spending is going. That's pretty cool. I might actually start using this age numbers right away. Cool.
This has been so awesome. We're going to link Will's YouTube and Instagram below. He is going to be putting out videos regularly, so go support his channel because he did all of this on my channel for free, and he's going to be giving thousands of hours of additional free Claude information on his YouTube channel. So, make sure you subscribe not only to the Ecom Hannah channel, but also Will's channel as well.
Now, guys, we're going to show you how you actually get these digital products and create a competing Etsy listing inside of Etsy. Okay, so now we have the product. Now, when we get a sale for the product, we have to give sellers a way to actually go retrieve it. So, that is what we're going to show right now. Now, we have to actually set up a successful Etsy listing. So, when you're creating a new listing, you're going to tell Etsy that it's a digital file. And when you select this, you're going to have the option to add files. Now, when you purchase the digital download or when your customer purchases the digital download, this is what they are going to see. So, you can add all the files that you want your customers to get to be able to understand how to use their template. So, we're going to want to go ahead and create something like this, especially when it comes to the instructions. So, that's pretty straightforward when it comes to creating that. You can go ahead and create that directly inside of Claude as well because Claude is going to have all the context. You basically just need Claude to create you a PDF explaining how to interact with the tool and, you know, give it that similar guidelines. So that's going to be a really, really quick process.
What's really, really important in terms of the success of your listing is making a really, really attractive thumbnail. So we are going to go back into Profit Tree. If you remember from our tracking at the beginning of this training, we set up folders for Google Sheets digital downloads. And what we want to do is we want to analyze what is the cover image for some of these top digital downloads for the budget trackers or the wedding planners, right? And we need to see, okay, what are they doing in that main image and how can we stand out? So, if we zoom in here, you can see here are some of the top aesthetics when it comes to not only the full branding of it, but that actual thumbnail image, right? And that thumbnail image is what's going to get you to earn that click. Notice with all of these top thumbnail images, they're all using very comfort colory muted tones. So, you could explore actually split testing this with something with brighter tones. This thumbnail image is going to make or break whether or not you earn the click or not. So you can definitely explore when you do launch your listing. You're going to want to split test this a couple of different ways in order to try to earn that click. So if you're making one budget tracker, I wouldn't just make one listing. I would actually split test that listing three or four times with different images with different colors and different fonts to try to see which one is actually going to win.
Guys, I hope you enjoyed this video. And if you have not already subscribed to the channel, make sure that you subscribe because we have more Claude videos coming out next.