Using and Editing Your Prompt

Testing My Prompt Yourself

The following is my exact prompt

**Context:** I am an etsy seller and I’d like to understand the actual cost of my products to make sure I am including all fees and make more profit.

**Task:** Create a price book that shows all of the costs for materials and labor and Etsy fees

**Output Format:** Create a Google sheet that will have the materials I use and their cost that I can pick from as I build the products, then a sheet that shows all my products and their cost and the expenses

**Requirements:** Please include any etsy fees, including the relisting fee every time something sells. Include labor

**Example:** I’d like to have a sheet for each product that pulls from a main materials sheet, and then I’d like to be able to automatically add products to the master product list. I won’t want to have to retype everything

**Process:** Please proceed directly with the task.

Transcript of this video:

…Welcome back. As you can see, I’m in Google Gemini, which is one of the popular AI chats, and I’ve pasted my prompt. Within seconds, Google Gemini answered the prompt. It said it can’t create a Google Sheet, but it created these individual tables for me and expects me to export them into Google Sheets and set them all up myself. Not at all what I’m interested in, so we’re not going to be using Google Gemini.
Next up is ChatGPT…And look how complicated it made it. It made a product tab, an example tab, an app script tab, a master products tab. It just is doing so much. Plus, it is not doing everything I asked it to do. It’s certainly not simple.
Um, but it looks very complicated. And in the end, I decided not to go with ChatGPT. I went with Claude because Claude worked…
Claude also gave me a little bit more than I wanted, but, essentially, it had everything I needed. The instructions tab, I don’t really need that. The settings tab, not so much. What I’m really concerned about is not having to retype the materials every time. And I can see that the materials drop down is not working.
So what that means to me is that I type the materials in on the material tab, and I have to retype them on the other tabs. So I told Claude it’s not working. And I just simply said it’s not working as expected, and I told it what was not working as expected. And it got back to work, and it fixed it
…
Now I’m going to open it in Google Sheets and give it a test run. And to be because I’m connected to Google, I’m just going to click the Google icon, and it’s going to open up the Google Sheet…
So the act action that I’m looking for is the drop down material list…
And it’s just so awesome that in five minutes, I have this full workbook with working drop downs so I can add materials to the material list, and I can add them to this product template. And, um, yeah, I don’t have to retype it. So in five minutes, I have a working workbook that is amazing. Now what I really want, though, is to have the products also brought forward to the master product list, and that is not happening. So I’m going to ask Claude to fix it.
And now with very plain language, I’m going to tell Claude what’s working and tell it, this is great. This really works great. Except for the products list is not pulling the products. So when I create a product from the template, I want it to pull into the master product list. And and Claude is gonna fix that for me
…
Now…
let’s look what we have. We have a materials tab. We have a product template. I’m going to right click and choose duplicate. Then I’m going to right click, and I’m going to rename that tab…welcome sign…
And now…
fill in a couple of the other fields, put in the the name there, the sale price here…
And, also…because it pulls from the materials tab, all I need to do is find the materials I used for the welcome sign, put in the quantity that I used
…
and also my labor. I can put how many minutes I spent, uh, using my laser cutter and how long it took me for the packaging. And then all of the Etsy fees are listed here. I can edit them and adjust them. And all of my cost and profit summary is listed right there.
So easy to see, so easy to adjust and make sure that my profitability…uh, that I’m getting compensated for my time and that I’m getting compensated for my costs. Now all I need to do here is type in the sheet name, and…
it’s listed. All of the things are being pulled from that product sheet. So I can have a master product list with how much it costs me for each product as well as the individual products…
Before we wrap up, I want you to notice something important…You didn’t learn a piece of software right now. You didn’t memorize formulas or suddenly become a spreadsheet person. What you learned is how to ask for what you need in a clear and practical way. AI didn’t replace your thinking. It removed friction.
You made the decisions. You defined the problem. The tool just did the heavy lifting. And that matters because the same skill you used here applies everywhere. This pricing workbook is just one example.
You can use this exact approach to build forms, organize information, test ideas, tackle other business tasks that you’ve been quietly avoiding…because they feel too technical or too time consuming. This isn’t about chasing trends. Honestly, I’m not all AI. I’m just saying it’s it’s…about using the tools available…so that you can…support your goals and your time, um, and make everything easier. You’re not late to this.
You’re right on time for this…