Hey there stranger!
Sign up to get access.
About this Tutorial
00:07 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.
00:18 We have a bunch of pre-written, prompts and some information that the user is going to add. We have created all the prompts.
00:27 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.
00:34 And if you're a BetterSheets member, you can get this sheet, exact sheet with the Apps Script down below. I'm using an API, now that it will be deleted before you get this video.
00:45 So let's get started. The only thing you need to know is that the Apps Script is written such that all we have to do is put an equal sign, AI.
00:53 It's already custom. It's a custom function that shows up here natively with this Apps Script that's in this sheet in particular.
01:01 And we need prompt and tokens. That's the two things that I've chosen for this kind of idea where we're creating sort of a waterfall of we want to introduce one thing.
01:13 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.
01:21 But then we have these prompts and each one of these prompts I want to basically take this description, run this prompt through AI.
01:30 Now, if we're doing this through chat GPT, we might have this sort of a doc and we have to write all of this stuff all the time or copy paste a bunch of things, add them together and then put it in chat GPT.
01:41 Then take 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 going to take this prompt, take the number of tokens, run it in and get a response back.
01:55 We're also, by the way, using GPT 3.5 for this. It's to use GPT. GPT 4 is as simple as going in the ops script and editing where it says GPT 3.5 turbo to GPT 4.
02:09 That's it. That's all you have to do. But let's do this. Now I'm going to use Google Sheets sort of functions and formulas and cell references to do this really, really cool way of doing this.
02:21 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, sell this as a web app of writing tool, a writing tool.
02:31 And I think you can do that. All right, here's our prompt. We're going to write our prompt. We have our right there, but we need to do one thing.
02:38 We need to include this B2. So let me just. Describe what's going on in the sheet. We have a describe your new product.
02:44 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.
02:53 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.
03:02 This if I want to edit each of these prompts and have different tokens for each one. And if I want to sort of create a, I could create a dropdown menu here and say, you know, one, 100 tokens, 200, 300, 1000, 1500, 2000.
03:17 I can, I can make it really easy to change this or literally just type in the number. 250 and I can, I just want to do that because in this sort of setting up this web app, I just want to see what different token levels would do.
03:31 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:41 We want just like a quick. Tagline pitches product as if it were in front of sharks of shark tank. We want a persuasive sort of investor pointed pitch.
03:51 We want to write a Google ad title that's persuasive and punchy. And this is a silly version in D seven.
03:57 We are writing a Google ad title and we're going to write a funny version. And then the last thing we're doing here in D eight is write a website headline.
04:07 That's two customers. So this show will show, hopefully this we're going to describe this product, which is a virtual language mentor.
04:16 It's an AI tool set to launch in 2023, revolutionizing language. I sort of wrote a bunch of. Stuff providing dynamic adaptive language instructions tailored to individual proficiency levels, improved phononciation, and some features, some benefits, remote language instruction, cultural exploration,
04:35 some use cases in here. It's got a lot of stuff. The, the, the, the product is well described here. We haven't written just a few words.
04:43 Okay. But we, what we want to do is we want to create combine B2 and each of these D4, D5, D6 inside of the AI prompt.
04:53 So what we might start with just to test out is AI. We're going to write the prompt is D4. We use the M percent here to D4.
05:03 Take the cell references that we're doing. We're going to do D4 and B2 and combine them into just this prompt, this one prompt here.
05:11 We're going to do B2. We're going to add a comma and we're going to do E4. Now I'm not going to hit enter yet.
05:18 I need to do some changes because I know I'm going to want to copy and paste this down. Without having to do too much editing.
05:25 So this B2, if I copy and paste it right now, it'll change from B2 to B3 to B4 to B5.
05:31 So what I want to do is I'm going to add a dollar sign in front of the two. And now if I copy and paste this down, the D4 and the E4 will change.
05:40 Great. I want to change the prompt, but I don't want to change the description. So that's why I use that dollar sign.
05:46 I'm going to hit enter. We're going to do some more cool stuff to this, but let's just see what we get.
05:54 Revolutionary language learning transform. The language one got like two. Let's copy and paste this down. We're going to use this different pitch here.
06:03 And we're going to see, we can just do this all at the same time, especially because we have a few tokens.
06:09 If, if we had more tokens like 1000, 2000, 3000, 4000, we might need to not cash us, stop this from all happening all at the same time.
06:22 Now. Oh, oh, it's like two of them in here. Interesting. We have an arrow here, exceeded maximum time. All right.
06:35 I think we can get around this and with the next bit of what we're going to do. But in this case, let's just copy paste this again.
06:47 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.
06:57 Maybe give it more stuff, but yeah, we have some responses, right? Transform your language skills. So let's say bonjour to your new BFF.
07:08 Cool. Say goodbye to outdated language learning techniques. Let's do one thing. Let's see the whole thing. Launch it in 2023.
07:19 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.
07:34 Do do do do. Let's make this a little bit bigger. You know we have to make these little adjustments maximum time.
07:40 So this is interesting. I wonder if, 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.
07:55 And if this custom function is in here now, it's going to call the API every 10 minutes. That is just something that happens.
08:05 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 or smaller.
08:15 And it doesn't seem like it's really working that well. We'll see if this time's out again. But what I want to do is I don't want this.
08:24 There we go. Imagine a world where language learning is no longer a tedious task. Great. I might be a good first sentence.
08:32 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.
08:43 I added the word product and then a colon. Right there. That might be helpful, but you should see that I didn't do that in all the prompts and sort of test out your own prompts there.
08:54 And also test out different token, token, max tokens, maximum tokens there. Make sure you remember that the maximum tokens includes the prompt itself.
09:03 So if you have a long prompt, even if you only ask for a few. Words response, try to give it more tokens, maybe a thousand if you have a very large prompt.
09:11 Alright, one thing I want to do is I definitely want to write. If function if. Is blank. When you use this combination B2.
09:24 I'm going to add that. Combination I have those comma signs here. Because. If B2 was blank and I sort of created this sheet as a web app and said hey, and here API key and then enter a description of your product and it will then write all this stuff right.
09:46 . If I don't have this, I'm gonna get a bunch of errors and I'm gonna have a bunch of API calls the moment that you put in your API key.
09:55 I'm gonna have a bunch of API calls and I also don't want an error if there is no API key.
09:58 So I actually want two things here. I want if is blank. API key A1 as well. So I want those both to have something.
10:16 And I also need to do the same thing as I did before, which is the dollar sign in from the A and the one in this case, because I'm gonna move these all around, especially as B2B and two, I might, move them all around, I might actually put a dollar sign in front of this B as well, should have done
10:30 that before. And now, I can copy-paste this all the way down. Everything else changes the, if you notice here, D7, D6, D7, D6, and E6 and E7.
10:40 So, now we're using the power of Google Sheets really, really well. We have this formula-combin, ,of if is blank two times.
10:49 If I delete the API key, this will just turn to nothingably blank. Might even be helpful to write what to do, right?
11:00 Add your open AI API key. In API key, A1. And then this one, write a description about your product. In, write, exclamation point, B2.
11:23 Cool. So now, if I- I'm gonna copy this text. I'm just gonna copy it and then delete it. Now, I have instructions on what to do.
11:36 Now I know exactly like the user, if they're using this and they have, you know, a short 30 second and minute video to watch you, how you just write your description of your new product.
11:46 Great. Now they- I can come in and do that. Now count to a week later, a month later, they're like, ah, I wanna write it, I wanna launch a new product, I wanna go through this checklist, and I wanna like, have all this stuff text written really quickly.
12:00 What do I do? Okay, I'm gonna delete the first thing they're gonna do is delete this description of the old product.
12:06 And now- they have exactly the instructions, right, a description about your product in right, B2, right there, bam. So, this is great, especially if this description of the product is maybe on another page.
12:19 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.
12:25 Let's- do that right, a description about your product. And maybe it is not just one thing, right? It maybe it's like multiple things.
12:40 Let's use our sheet styles to style this. I don't like looking at this. Black and white and aerial. Right in the description about your product.
12:54 . Right the name. Name. Maybe we're gonna walk them. What does it do? What are its?. Main feature. What are its main benefits?
13:12 Who is it for? And if they fill this stuff out, maybe we have right here and before, we're like equals.
13:24 . Product name is. And B5. And it does. I don't know. We'll just add these together right. Have a little space.
13:41 Ampersand B6. Ampersand space. Ampersand B7. We can also not do that and do concatenate. Join with spaces. B5. To be nine.
14:11 Why is there an M? Oh, because there is an M there. Okay, so name virtual gym for fitness freaks. Probably name is v- Virtual gym.
14:28 Oh, maybe I should say. Virtual gym. What does it do? A gym. Gym an online gym to train every day.
14:43 With body exercises. And now we can write all these pieces and now see our product description is in B4. So instead of having B2 describe your product, this could say nothing.
15:02 This could have no header here. You could say describe your product. You can walk people through all the pieces of the description you need.
15:11 Then they come here. They only have to come here and they just get the results. Instead of if blank B2, we're gonna do B4 on describe your product.
15:23 So let's look at this. Is Blaine. I've got to describe your product before. And we need to get that in the prompt as well.
15:34 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 4 and the B and the 4 here as well.
15:49 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 B4 describe your product and that is changing.
16:01 There we go. So instead of having it here, this will redo them now. We have describe your. Product and we'll do this is the text.
16:13 Or output. Or results. Whatever you want to call this. We'll see it. There it is. Train anywhere anytime. Wow, what a great tag on.
16:22 Hello, sharks. I'm excited to introduce you to virtual gym. The ultimate solution for fitness. Enthusiast. Looking to train everyday with Monday exercise.
16:31 Great. And so now as much as we want to add here in this description, we can piece together. You know, maybe we're helping people describe what they've, what they're launching.
16:44 And we're creating this web app now results in a bunch of prompts that are now. Getting results right away. I only had to change the description and and the prompts are writing right away.
16:55 Isn't that cool? This is like parade of prompts, right? We can also feed prompts into each other. We can say things like, you know, instead of this prompt being just text that is written, maybe it includes the tab.
17:09 And we're like, use this tagline in a Google ad. Use this tagline to tell sharks what to do, right? We can sort of put inside of the prompts, the results of other prompts.
17:26 Wouldn't that be cool? Alright, I hope you enjoyed this video. So if you are a better sheets member, down below is the sheet for free included in your membership.
17:38 If you're not a better sheets member, become a better sheets member today and you can get both the app script that is included in the sheet and the sheet itself and use it for your own purposes.
17:49 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.
17:58 Good luck. Bye.
Quickstart Tutorial OpenAI API in Google Sheets
Upgrade Google Sheets OpenAI Prompt to GPT 4
Created a GPT function in Sheets
Spreadsheet Automation for Beginners
Ultimate Prompt Writer and Prompt Rater
ChatGPT Clone in Google Sheets Part 1
I Built a SEO Meta Description Writer
Mr. Beast Renamed My YouTube Titles
Create a Waterfall of AI Prompts and Responses
ChatGPT Clone in Google Sheets Part 2
Run 100 ChatGPTs at One Time
Building an AI Prompts Playground
YouTube Title Rewriter with GPT-3
Ultimate Headline Writer with GPT in SHEETS
Create a ChatGPT Cheat Sheet Spreadsheet