Epic ChatGPT Prompt Library in Google Sheets

0:00 you have hundreds of prompts that you want to put into ChatGPT, but actually what we're doing today is we have a lot of little things where we've written one epic prompt. So we have done a lot of editing and crafting of-- this is like 2,000 words, but at the end of this, we have a little thing which just says, "Here's the topic." So like we're-- in this particular case, we are writing blogs, and we're writing about these particular topics. Now, what I wanna show you in this video is how to get these into ChatGPT really, really quickly, um, where we're combining text of, of epic prompt with the little bit of information that we want to write right now. How do we combine these? How do we get these into ChatGPT without having to copy-paste a couple of times? Run 100 ChatGPTs at One Time Run 100 ChatGPTs at One Time Ultimate Prompt Writer and Prompt Rater CLUTTERED CODE

0:48 So don't continue copy and pasting. I'm gonna show you really cool thing here with a little bit of trick of a ChatGPT intent URL. And so here's all of our topics. We have a cell A1 in the tab Prompt, and we wanna get it here. So we don't wanna just do prompt exclamation point A1. That is going to be crazy, right? We wanna get that prompt and this topic into one place in ChatGPT. So we actually can do chatgpt.com/?q= And now we're gonna finish this with all of the text that we wanna Build a Better ChatGPT Prompt Builder Run 100 ChatGPTs at One Time ChatGPT Clone in Google Sheets Part 1 Apps Script you need to know while using ChatGPT

1:35 put in which will be ampersand Prompt question, uh, exclamation point, A1 and A2. So we're referencing this exact text here Now what I wanna do around prompt A one and A two here is wrap this with encode url What encode URL does What encodeURI does is it essentially takes all the text and all the spaces and makes them so that we can put them in a URL So I'm gonna hit enter, and right now this has turned into just text. But I can wrap this with hyperlink . I'm gonna wrap it just with hyperlink , but I'm gonna show you one more trick later. Now, if I click this, I'm gonna go to ChatGPT. Build a Better ChatGPT Prompt Builder Run 100 ChatGPTs at One Time Build a Better ChatGPT Prompt Builder Automatic Screenshot in Google Sheets

2:23 It's gonna open ChatGPT. It's going to open the entire prompt all the way down, all 2,000 words, and then at the end it says, "How to train a puppy to stop biting your hands and fingers." We can hit enter, and it'll write it for us. We come back and be like, "Okay, let's copy paste down," right? But as we see this prompt A4, what? That's wrong. It needs to be A1. So we need to go back and edit our cell a little bit more. So we have to put in front of the A1, A and the 1, dollar signs for prompt. That means as we copy paste down, the A1 changes, and the only thing that changes in this URL is going to be this last part, which is going to reference the cell here. Ultimate Prompt Writer and Prompt Rater Run 100 ChatGPTs at One Time ChatGPT Clone in Google Sheets Part 2 CLUTTERED CODE

3:13 So this is why Google Sheets is so cool, right? We can put relative references , and we can do the same thing to hundreds and hundreds of cells with just a couple of clicks. Watch. I'm gonna just click, double-click this dot in the bottom right, and now it is filled in for all hundred of these, right? I've just added all of these topics, wrote this URL, uh, once, copy and pasted it all the way down. Without even copy and pasting it, I just double-click here. And now I can prompt ChatGPT from my Google sheet in ChatGPT, hit a couple buttons, and get the response I want that's very particular ChatGPT Clone in Google Sheets Part 1 When did you learn the secrets of Google Sheets? | Sheet Talking Episode 8 Esa ChatGPT Clone in Google Sheets Part 2 SearchLord

3:59 to this prompt plus the topic. Really cool. I think this is, like, so awesome to be able to save prompts like this, and create prompts like this, and just use Chat- GPT in this way without an API, without coding, without anything, with just this line of hyperlink and encodeURL. But I wanna show you one extra thing. Add a comma here at the end of hyperlink , and write, "Go to ChatGPT." And now I don't even have that URL here. I just have some text Yep, go to ChatGPT. So this makes it really user-friendly if you're writing this stuff for someone else or coming back to this later and being like, "What does this do? Oh, well, it goes to ChatGPT." I'm gonna send this and the prompt to ChatGPT. Really cool to create ChatGPT libraries, be able to edit your Build a Better ChatGPT Prompt Builder Run 100 ChatGPTs at One Time Build a Better ChatGPT Prompt Builder CLUTTERED CODE

4:45 prompt over and over again without having to copy-paste a bunch of stuff. So now we can edit this prompt right here in our Google sheet. Right? This is a very epic prompt, and we probably will iterate this over and over and over again. But the moment that we iterate it, the moment that we edit it, change something, it's gonna be automatically changed here, so we can just go back right away and see what the changes-- what changes d- did we do that actually changed the output. Really, really cool and really, really awesome to be able to keep our ChatGPT prompts as, in a library, edit this epic prompt, use it over and over and over again. You're watching Better Sheets here on YouTube. You have two options here for your next video. Before you go, comment down below if you have any question whatsoever, and I'll Build a Better ChatGPT Prompt Builder Run Every Prompt in Every Cell All At Once Ultimate Prompt Writer and Prompt Rater Bigger Brain

5:30 make future videos from those questions. But for right here, right now, one of these videos could be your next Google Sheet Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. Roasting Google Sheets Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. Download Google Sheets