Hundreds of Tutorials, templates, and tools at Bettersheets.co

Run Every Prompt in Every Cell All At Once

Welcome to the Prompt Parade. We are gonna write a bunch of prompts and we're gonna get responses of these prompts back, all in a google sheet. Great way to create a little web app inside of a Google Sheet.

Run Every Prompt in Every Cell All At Once


Welcome to the Prompt Parade. We are gonna write a bunch of prompts and we're gonna get responses of these prompts back, all in a google sheet. Great way to create a little web app inside of a Google Sheet.

Run Every Prompt in Every Cell All At Once on YouTube

Transcript:

(00:00) Welcome to the Prompt Parade. We are gonna write a bunch of prompts and we're gonna get responses of these prompts back. We're going to articulate lots of things based on one description, and we're basically building a web app here in which we have an API key that a user can use. We have a bunch of pre-written prompts and some information that the user is going to add.

(00:24) We have created all the prompts we have created, set up all the tokens. The only thing you need to know before we start is that we have written a custom function, and if you're a better Sheets member, you can get this sheet, exact sheet with the app script down below. I'm using an API key now that will be deleted before you get this video, so let's get started.

(00:45) The only thing you need to know is that the app script is written such that all we have to do. Is put in equal sign ai. It's already custom. It's a custom function that shows up here natively with this app script that's in this sheet in particular, and we need prompt and tokens. That's the two things that I've chosen for this kind of idea where we're creating a waterfall of we want to.

(01:09) Introduce one thing. In this case, we're describing a new product that we're launching in 2023. We're not launching this. This is just an example, but then we have these prompts and each one of these prompts, I want to basically take this description. Run this prompt through ai. Now, if we're doing this through chatty p t, we might have this sort of a doc and we have to like, write all of this stuff all the time or copy, paste a bunch of things, add them together, and then put it in chatty p t, then take

(01:39) the answer and then copy and paste it. None of that. All we have to do in this case is take. The AI function that we've already written, which is just gonna take this prompt, take the number of tokens, run it in, and get a response back. We're also, by the way, using G P T 3.5. For this, it's to use G P T four is as simple as going in the app script and editing where it says G P T 3.5, turbo to g GT four.

(02:06) That's it. That's all you have to do. But let's do this now. I'm gonna use Google Sheet's sort of functions and formulas and sell references to do this really cool way of doing this. And I'll show you how you can use this sheet. Write your own prompts, and then basically sell this, right? Write your own prompts.

(02:24) Sell this as a web app of writing tool, a writing tool. And I think you can do that. All right, here's our prompt. We're gonna write our prompt. We have our right there, but we need to do one thing. We need to in include this b2. So let me describe what's going on in the sheet. We have a describe your new product.

(02:39) This would be blank if we're doing this from the start. And I'll show you at the end, we'll have this, a blank sheet and we'll have these prompts that are written already. We have the number of tokens I have chosen to put the number of tokens here on the sheet just in case. As I'm testing this, if I want to edit each of these prompts and have different tokens for each one, and if I want to create a, I could create a dropdown menu here and say, one, 100 tokens, 200, 300, 1000, 1500, 2000, I can make it really

(03:13) easy to change this, or literally just type in the number two 50 and I can. I just wanna do that because in this sort of setting up this web app, I just wanna see what different token levels would do, and I wanted to keep all these small, but not totally, completely small. As you can see, we're describing our product here, and we have, in this particular case, we're like, pitch this product in three words.

(03:35) We want just like a quick tagline, pitch this product as if it were in front of. Sharks of Shark Tank. We want a persuasive sort of investor pointed pitch. We wanna write a Google ad title that's persuasive and punchy. And this is a silly version. In D seven, we are writing a Google ad title and we're gonna write a funny version.

(03:54) And then the last thing we're doing here in D eight is write a website headline. That's two customers. So this show will show hopefully this what we're gonna describe this product, which is a virtual language mentor. It's an AI tool set to launch in 2023, revolutionizing language. I wrote a.

(04:12) Bunch of stuff providing dynamic adaptive language instructions tailored to individual proficiency levels, improve pronunciation. It has some features, some benefits, remote language instruction, cultural exploration, some use cases in here. It's got a lot of stuff. The product is well described here.

(04:30) We haven't written just a few words. Okay? But we, what we want to do is we want to create combine B2 and each of these D four, D five, D six inside of the AI prompt. So what we might start with just to test out is ai. We're gonna write, the prompt is D four. We're gonna use the ampersand here to take the cell references that we're doing.

(04:53) We're gonna do D four and B2 and combine them into just this prompt, this one prompt here. We're gonna do b2, we're gonna add a. Comma, and we're gonna do E four. Now, I'm not gonna hit enter yet. I need to do some changes because I know I'm gonna want to copy and paste this down without having to do too much editing.

(05:13) So this b2, if I copy and paste it right now, it'll change from B2 to B3 to B four to B five. So what I'm gonna do is I'm gonna add a dollar sign in front of the, though two. And now if I copy and paste this down, the D four and the E four will change. Great. I want to change the prompt, but I don't want to change the description of the product, so that's why I use that dollar sign.

(05:34) I'm gonna hit enter. We're gonna do some more cool stuff to this, but let's just see what we get. Revolutionary language learning, transform re language. Got two. Let's copy and paste this down. We're gonna use this different pitch here. And we're gonna see, we can just do this all at the same time, especially cuz we have few tokens.

(05:56) If we had more tokens, like 1000, 2000, 3000, 4,000, we might need to not cash us stop this from all happening all at the same time now. Oh, it's two of them in here. Interesting. We have an arrow here. Exceeded maximum time. All right. I think we can get around this in it with the next bit of what we're gonna do.

(06:20) But in this case, let's just copy paste this again now that the other ones are done. This might actually take less time, but we might also decrease the number of tokens here or increase it. Maybe we give it more stuff, but yeah, we have some responses, right? Transform your language skills. So add, say barn to your new B bff.

(06:44) Cool. Say goodbye to outdated language learning techniques. Oh, let's do one thing. Let's see the whole thing. Launch it in 2023. Try the virtual language mentor today. Language learning, stressing you out. I think we need more room here. We got another error, but we can fix that in a hot second. Let's make this a little bit bigger.

(07:08) We have to make these little adjustments, maximum time. So this is interesting. I wonder if maybe we need more tokens. As soon as I edited the tokens, this loads again, and it's gonna make another API call. Just let you know. And if this custom function is in here now, it's going to call the API every 10 minutes.

(07:34) That is just something that happens. We should try to fix that. So one thing I did is I tried to edit this prompt a little bit more to make it a little bit faster or like shorter, smaller. And it doesn't seem like it's really working that well. We'll see if this time's out again, but what I wanna do is I don't want this.

(07:55) There we go. Imagine a world where language learning is no longer at tedious desk. Great. That might be a good first sentence. We finally got through that, so you can see a couple of edits that I did here as well. I put product here knowing that inside this prompt here, I'll combine this description. I added the word product and then a colon here, right there.

(08:17) That might be helpful, but you should see that I didn't do that. In all the prompts, you can test out your own prompts there. And also test out different token to max tokens, maximum tokens there. And make sure you remember that the maximum tokens includes the prompt itself. So if you have a long prompt, even if you only ask for a few words response, try to give it more tokens.

(08:37) Maybe a thousand if you have a very large prompt. All right. One thing I wanna do is I definitely want to write if function, if is blank, I'm, you use this combination b2. I'm gonna add that combination. I have those com signs here. Because if the B2 was blank and I created this sheet as a web app and said, Hey, enter your API key and then enter a description of your product and it will then write all this stuff, right? If I don't have this, I'm gonna get a bunch of errors.

(09:15) And I'm gonna have a bunch of API calls. The moment that you put in your API key I'm gonna have a bunch of API calls and I also don't want an error if there is no API key. So I actually want two things here. I want if is blank API key, A one as well. So I want those both to have something. And I also need to do the same thing as I did before, which is the dollar sign in front of the A and the one in this case, because I'm gonna move these all around, especially as B two B and two, I might move them all around.

(09:46) I might actually put a dollar sign in front of this B as well. Should have done that before. And now I can copy paste this all the way down. Everything else changes the, if you notice here, D seven, D six, D seven, D six, and E six and E seven. So now we're using the power of Google sheets really well.

(10:04) We have this formula combination of if is blank, two times. If I delete the API key, this'll just turn to nothing. It'll be blank. Might even be helpful to write what to do, right? Add your open. AI A P I key in a p i Key A one. And then this one. Write a description about your product N write exclamation point B two.

(10:39) Cool. So now if I delete, I'm gonna copy this text. I'm just gonna copy it and then delete it. Now I have instructions on what to do. Now I know exactly like the user, if they're using this and they have, a short 32nd, a minute video to sh watch you, how you just write your description of your new product.

(11:01) Great. Now they can come in and do that. Now, count to a week later, a month later, they're like, ah, I wanna write it. I want to launch a new product. I want to go through this checklist and I wanna have all this stuff text written really quickly. Oh, what do I do? Okay, I'm gonna delete. The first thing they're gonna do is delete this description of the old product, and now they have exactly the instructions.

(11:24) Write a description about your product in write B2 right there. Bam. So this is great, especially if this description of the product is maybe on another page. Maybe you're like, I want full focus on the description. Maybe there's even more instructions that I wanna do, which is really cool to do. Let's.

(11:41) Do that. Write a description about your product. And maybe it is not just one thing, right? It, maybe it's like multiple things. Let's use our sheet styles to style this. I don't like looking at this. Black and white and aerial. Write a description about your product. Write the name. Name, maybe we're gonna walk them.

(12:08) What does it do? What are its main features? What are its main benefits? Who is it for? And if they fill all this stuff out, maybe we have right here in before we're like equals Product name is we do and B five. And it does, I don't know. We'll just add these together, right? Have a little space.

(12:44) Ampersand, B six, ampersand space. Ampersand B seven. We can also not do that. And do concatenate join with spaces B five to two B nine. Why is there an m. Oh, because there is an m there. Okay, so name virtual Gym for Fitness Freaks. Pardon? Name is Vi Virtual Gym. Oh, maybe I should say Virtual Gym. What does it do? A gym.

(13:23) Gym and online gym to train every day. With body exercises, and now we can write all these pieces and now see our product description is in B four. So instead of having B two describe your product, this could say, Nothing. This could have no header here. You could say describe your product and you can walk people through all the pieces of the description you need.

(13:51) Then they come here, they aren't gonna have to come here, and they just get the results instead of if blank b2 we're gonna do before on describe your product. So let's look at, this is Blaine. Describe your product before. And we need to get that in the prompt as well. Instead of b2, it is this, we do have to do one couple more changes, if you remember the dollar sign in front of the B and the four and the B and the four here as well.

(14:28) Cool. So now we take all of those. We have all the same prompts. We write all with all the same tokens, and we're using the B four. Describe your product and then it's. Changing. There we go. So instead of having it here, this'll redo them. Now we have describe your product and we'll do this is the text or output or results, whatever you want to call this.

(14:57) We'll see it. There it is. Train anywhere, anytime. Wow. What a great tagline. Hello Sharks. I'm excited to introduce you to Virtual Chimp. The ultimate solution for fitness enthusiasts looking to train every day with body exercise. Great. And so now as much as we wanna add here in this description, we can piece together, maybe we're helping people describe what they've, what they're launching and we're creating this web app now results in a bunch of prompts that are now getting results right away.

(15:28) I only had to change the description. And and the prompts are writing right away. Isn't that cool? This like parade of prompts, right? We can also feed prompts into each other. We can say things like, instead of this prompt being just text that is written, maybe it includes the tagline and we're like, use this tagline in a Google ad.

(15:51) Use this tagline. To tell sharks what to do, right? We can put inside of the prompts, the results of other prompts. Wouldn't that be cool? All right. I hope you enjoyed this video. If you are a better Sheets member, down below is the sheet for free included in your membership. If you're not a better Sheets member, become a better Sheets member today and you can get.

(16:17) Both the app script that is included in the sheet and the sheet itself, and use it for your own purposes. Create your own prompt parade for your own use or even sell it. Go ahead, create a prompt parade, and sell it as a digital product online hey, watch more videos here. Watch how to make that viral plant, that money tree inside of Google sheets.

(16:38) Check out how to program in Google sheets. I do a very quick crash course here. And that leads into more kind of spreadsheet automation stuff, but check out this video too. If you want to learn how to write apps script.