How To Run 1000+ Prompts In 7 Minutes | ChatGPT + Google Sheets

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
AI tools like chat gbt are pretty magical in generating new content out of absolutely nothing but what if you want to create lots of content on mass at the same time and do something like creating a thousand personalized emails for customer Outreach to completely take your business to the next level well in today's video we're going to be doing just that by looking at how you can integrate GPT into Google Sheets and automate multiple tasks at the same time to create Mass functions and do things like sending thousands of emails or creating lots of active recall questions depending on what you want to do so let's get into it okay so first off we're going to load up Google Sheets and we're going to head over to the extensions component now there are two particular tools that I've used quite a lot in order to achieve some of these results the first one is called cargo and you can download that by Sergeant riccargo on the extension store in Google Sheets the next one is then GPT for sheets and docs this gives a little bit more customization and it's worth trying both out because they have slightly different functions now once you've added both of them what you're going to need to do is to integrate your own open AI API code into both of the extensions so that they can make the API calls to open AI so if you're completely new to open AI you'll need to head over to open hours website and sign up for an account and then go to the settings area and identify your API key and then copy and paste this and pull it into the respective boxes in both GPT for sheets and into cargo now once we've done that we can see that we get these nice side panels where you can actually add in some things like variables or add in your prompts and what we can do now is click on things like a specific cell and use commands like GPT or GPT list and get our prompt which you've entered into that sidebar to action whatever information is in that cell so we can do lots of really interesting things here firstly we'll actually build out our own prompts from the information in the cells so for example if from A1 down to A4 we've got specific components we want to feed into our prompt such as is the tone the Persona the format and the output following a structure like craft book context response actions frame and template then we can actually align that to the columns and the rows put in lots of different information and actually build out multiple prompts at the same time which is really really cool if we go back to the use case of generating lots and lots of emails what we want to do for this use case is to select different columns and map those to the different components of the email we want to create so what these plugins basically do is that they will communicate with GPT via the API and then they'll take what's in some of the cells and use them as variables so that you can write one prompt and then it pulls in the different cells to that prompt and generates hundreds or thousands of potential outputs which correspond with the different variables of those cells so to demonstrate this let's think about creating personalized Outreach cold emails or messages you might send on LinkedIn to somebody this is typically done by sales development representatives and the research component can take hours and hours and hours of your time because you want to make sure your personalized things and you're speaking directly to the individual to increase the chance of then opening your email or your LinkedIn message so in this instance what we want to think about is what are the variables that are going to change across our emails to the individuals and we're going to put those into our rows so we're going to have things like the first name the last name the company the job title things like interests things like company size and anything like this that we think is going to personalize that email and make it more specific to that individual so you can make this as specific as you wish to different Industries or whatever it is you want but the key thing is having the columns there okay now the next step here is then to input all the information you've got to correspond with those rows so let's say for example you've scraped a lot of data from LinkedIn or you've got existing email lists with all that information which is gdpr compliant from all of those people you want to send emails to what you can do here is you can actually copy that information such as their first name their last name their job title whatever it is into all of the cells corresponding to those rows and then we can do some really cool stuff with PPT next up we're going to actually write our prompt and again you can use either cargo or you can use GPT for Sheets here both work really really well for this functionality and our prompt is going to be basically our email so we're going to prompt GPT to be an email Outreach expert or copywriting expert and we're going to ask GPT to write an email to the variable first name corresponding with the column that talks about again variable a specific industry and then we're going to follow on and talk about certain things in the paragraph text that might interest that person so if you've got some data about their job role you might say something like I saw that you are insert job role variable at insert company I'd be really interested in talking to you about X Y and Z and you can kind of give examples of the emails you would like send into GPT again to prompt effectively and get really really good responses back now as a quick aside here I'd always recommend testing this prompt with just some example data in chat GPT itself and checking the email you get back before you start plugging it into sheets so you might just make up a random first name and last name and Industry and then plug that in and check what the email is like that you get back and I'd keep iterating that prompt until you're absolutely happy with what you're going to get back because we're going to be applying that prompt to about a hundred different people so we want to make sure it's on point now if we just use Cargo in this example what we then have to do is specify what each of our variables corresponds to in terms of the row and we also want to specify where our output is going to appear in our Google sheet and so that's going to be in our final column and that's where our emails are going to appear which then we can copy and paste once they're output so once you're happy with that once you've been through all of it once you've got all the cargo settings set up or GPT for Sheet setting setup you can go ahead and hit generate and let's see what we get back now remember the quality of the email directly corresponds to the quality of the prompt that you've put in which is why prompt engineering is so important now I hope you found this AI Deep dive useful as part of our technology Club I've put up a video here about more General use cases for AI which I hope you find useful and it's definitely worth checking out thanks so much for watching and for subscribing do hit that subscribe button if you haven't already done say and I'll catch you again in the next video [Music] foreign [Music]
Info
Channel: Dr Alex Young
Views: 2,656
Rating: undefined out of 5
Keywords: productivity, business, alexander young, studying, alex young, alexanderfyoung, Advanced GPT Guide: How To Run 1000+ Prompts In 7 Minutes, gpt-4, chatgpt, gpt for sheets, bulk create, how to use gpt in google sheets, how to bulk create ai content, open ai, open ai api, chatgpt advanced guide, chatgpt guide, how to use chatgpt, google sheets, google sheets tutorial, google sheets ai, productivity tips, gpt productivity
Id: zDm9Hiu7kac
Channel Id: undefined
Length: 6min 48sec (408 seconds)
Published: Sun Aug 13 2023
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.