Build a Startup Pitch Generator in Google Sheets
In this video, learn how to create a Startup Pitch Generator using Google Sheets and AI, allowing you to tailor your pitch for various startup accelerators like Y Combinator and Techstars.
So I saw this tweet and it said, all the startup accelerators you can apply for and I noticed that, of course, there's Y Combinator on here, there's, uh, 500 startups, there's some startup accelerators that I know of, Techstars here, OpenAI Converge, like, these are, You may know or you may not know and there's a lot on here that you may not know like A16, uh, Z speedrun, which is actually games. So what I was thinking is if you were looking at this list and you're like, you know what? I want to try to apply to most, if not all of these. And I wonder if even just like a simple A could tell me the answer. If I should apply to them or not, or even help me change my pitch, very personalized to the startup accelerator. Build a Startup Pitch Generator in 20 minutes
Maybe there is some insight to gain from looking at, and this is something that I would do myself. I would go to something like YC startup directory, look at what they have actually. Funded and see not necessarily does my idea fit in here But how can I edit my pitch so that it is more clear to this particular style? Let's say I'm not trying to generate ideas And actually that might be even a good idea to take these 233 companies and generate a hundred ideas of Companies that might be good and maybe I'll do that later. But I wanted to take a pitch that I'm writing and let AI edit it or morph it into something that is more YC or more pair X. And because These companies, or not these companies, but these accelerators, Build a Startup Pitch Generator in 20 minutes Build a Startup Pitch Generator in 20 minutes
will tell you why they invest, how they invest, they will tell you what they invest in, and we can take this information, put it into a nice engineered prompt, and say, hey, with my pitch in here, Let's get the pitch that I should pitch to this accelerator. So what we're going to do is sheet. new and we're going to create a brand new sheet . We're going to get AI in here by going to bettersheets. co slash snippets. We're going to just grab a, the, uh, Open AI, actually AI here, open AI prompt. Actually I want Omni. There we go. And then we'll convert this to Omni Mini now. So we are going to extensions, Apps Script , going to just take the Apps Script and paste it in here. We will probably get a prompt and edit this a little bit, but for now, let's just
do AI, put in the prompt, get the result. We will also grab an API key. By the time you watch this, I will have deleted this API key, but we'll just put this in text here. So that we don't have to put it on a page. Okay. So our AI will run, we're going to call this startup pitch editor . And again, we want to grab some information like this is X. We'll put it into our sheet and we'll say, okay, pair X invests in SAS. We'll do that powerful tools to help business. This is how they invest. We want also to have somewhere where we put our pitch. So our pitch, we want investment strategy, past investments, our pitch.
Let's figure out what we'll do. Let's say we're going to create a better Google sheet add on marketplace that is separate from. Google a third party manicured like I this is gonna be just a crazy idea, right? This is well manicured Rated and gamified to help people do better in Google sheets. Yeah, this is like a terrible pitch, right? It's probably gonna should be shorter. It should be much different, right? Let's see We want to wrap the text so we can see it A little bit better. Great past investments. Let's get a couple of past investments. We see that pair X, let's say, which one is going to be good. Here's bonfire. Okay. We're getting gusto as well.
And bonfire. Let's do just a couple of examples. So there, and what we want to do is we are going to do the exact same thing here, but instead of pair X, we're going to do Y combinator. So I'm going to look at the last two years. Let's say. Okay. For batches, not B2B. Let's look at marketplaces if that exists in here. Marketing, fintech consumer. I don't know if marketplaces is really here. So let's look at all industries and look for marketplace. Oh, here it is. Tag marketplace. 20 of them. So we have I don't think we can, oh, we can copy paste. There we go. Let's copy paste three of them and edit the text. So what I want to do is I want to make these super simple. Here, actually, it looks like they're super simple. For Y Combinator.
We still need to get the investment strategy of Y Combinator. So Y Combinator. Let's see if it's, let's see if it's in there about. So YC doesn't really have an exact philosophy of how to invest. We can probably put in a couple of things here about what happens at Y Combinator, why, but there's not really an answer to why, or how Y Combinator actually invests. So what I'm going to do is, I don't know if I'm going to put anything here. In our prompt, but let's just try this prompt right away equals AI and we're going to say turn this pitch turn our pitch into a better pitch that is more suited for this particular startup incubator or accelerator.
We're going to say our pitch. We're going to then add a ampersand. This is going to be, we're going to then do another ampersand, and do invest, accelerator, then ampersand, two ampersands, but in between, we're going to do B, then we're going to do investments, two ampersands, and in between them, C2. Actually, that's all we're going to do, and we don't even have to end it. Okay, so let's see what happens if anything gets back. We don't have any examples, though. Maybe it's going to give us some gibberish. It's okay. Oh my god, it gives us a lot of stuff. That's way too much stuff. So we just want, turn our pitch into a better pitch that's more
suited for this particular. Give a reply, respond, with only a simple pitch. Nothing more. Let's do that. We don't want it to name it. It's gonna name it. Let's look at this all and see what we get back. Sheet Master, dynamic third party sheet add on, meticulous curate. It's very long. So in this case, for Y Combinator, it does do it a little bit shorter. An independent gamified marketplace for Google Sheet add ons designed for seamless integration and enhanced productivity. We'll probably delete that. And third part, our platform offers meticulously highly rated tools to empower users to optimize their workflow within Google Sheets. It says the same thing, but I guess in a better way, not necessarily better, but more specific to Y Combinator, gamified marketplace
for Google Sheet add ons, right? Out of this, I can probably say, do this. So that's how we can create, take information here. Have someone fill it out, but let's make this easily sellable or shareable. We can create this fine, but we are the only ones that know how to use it. If we put in our pitch, we put in our investments, try to put in investment strategies, past investors. Maybe we, as a creator of this. Build out an investment strategy and past investment list that's of all of these 23 startup accelerators and then you only have to put in one place your pitch and you get back 23 specific the created or curated pitches sure we can work on this pitch a little bit more What we want to do now is is how do
we make this usable for others, right? Let's see. So one thing I realize is definitely take this portion of the text that we put here and put it into our prompt. We're also going to call this, we want to create a new function name, create new, create pitch. Let's call it. And instead of prompt, we're going to do pitch. We are going to create the prompt ourselves, variable prompt text equals . This, then we want to get, we don't want to have our API key here. We want API key here. So instead of this being here, I'm going to cut it out and allow someone else to use the API key. So we will say, Oh, and actually for right now, we're going to keep
this here, but we want to make this function available for others. So we're going to create a comment here called at custom function . And now we will get just, if we do equals create pitch, it's here. And it shows us the information we have to put in. There we go. Let's put in a pitch. Pitch is going to be in two, and our API key in text. And we like that. And that's all we need to enter it, but we want to get the other stuff. So let's add prompt text, variable accelerator. Maybe we do that when we start building our pitch here, variable pitch equals, or sorry, not pitch prompt equals. Prompt text plus pitch plus plus Accelerator and we get our accelerator from here accelerator and past Investments plus we're just gonna
create what we did here in side of our app script past investments can even look at it like this There we go. So now our prompt is exactly the same. We need to delete that accelerator there. So we're gonna Use the same thing we did before. So a two, but now we can fill it in. The accelerator is going to be B two comma C two for the past investments and the API key. Instead of here, we can put it here and let's make this a little nicer to see quicksand do a little bit bigger text. We will also center everything center, center, and there we go. Personalized pitch. So now. Someone can use this sheet.
Alright, make sure let's decrease the size of this font. Looks a little big. Oh, now it looks smaller. Okay, so now someone can use our sheet. Oh, we need a reference error . This reference is supposed to be a one. There we go. So we'll get, take our pitch, add an investment strategy of some accelerator. So accelerator or fund add on ACE, a third party marketplace. So it actually changes the name. Interesting. Oh, creates a name for it. Great. So we're going to save the name. In Apps Script as well, and this custom function here. So that makes it really easy for someone to be able to enter information. But let's say we don't want them to enter this pitch each and every time. We just want it one time. So how do we do that? What I like to do is this.
Pitches. Add a settings. And just put here. And put our pitch here. So we only have to put in one place here, or actually your pitch because someone else is going to create it. Now, the option is we can put in here a one, a two, the accelerator should be B2. Oh, wow. Really screwed that one up. Okay. So that's what it should be, but this is also convenient. We screwed it up, right? So we should be able to just put in the accelerator pass investments. Put in one place, our pitch, which is always going to be on this settings column. We can set this as, hey, don't mess with this. This is
going to get some reference errors. It's okay. We're going to actually change this from pitch. We're going to delete it from here. And we are going to do variable pitch equals spreadsheet app. We're going to get the range from here. Spreadsheet app is just a variable. every spreadsheet in your file. We want to get the active spreadsheet , which is this exact specific spreadsheet . We want to get sheet by name. We want settings. Let's enter a new line here just so you can see it a little bit better. Get range is going to be a two. Then we want to get the value from their get value. So we're getting the value from a two on the settings page in our spreadsheet. Existing spreadsheet file. And that is here settings a two. And instead of this reference error, we're just going to put in the
accelerator and the past investments and an API key and get back our pitch, our personalized pitch from a, let's say we want to do a couple more things here. Like we want to pitch, but we also want a startup name. So let's insert. Here, here, your startup name. It's gonna be Sheets with four Es. Sheets. com, let's say. And we're gonna go back to our thing, our Apps Script , and we're gonna call this variable name. Startup name, let's call it. And instead of A2, it's going to be A3, I think. Here, A3, and we have to edit this one, the pitch to A5. So turn our pitch. We need now one more thing. Prompt text is going to include startup name, and we can add that right here.
It's a couple of plus signs. Startup name, startup name. So we added our variable here to our pitch prompt, our prompt. Let's take out that space before the, there. Great. Save that. And I think our pitches are going to be better. Yeah. Startup name. Sheets. com. Transform. Revolution. Revolution. Let's make these a little bit. shorter. I want that way shorter. So we're going to engineer our prompt a little bit more. Turn our pitch, our startup pitch, into a better startup pitch that is more suited for this particular startup accelerator respondent with only a simple pitch, nothing more. Make sure the pitch is very short. The pitch should be a logline with very powerful and interesting terms to elicit feedback.
To get funded. Let's say that. Let's see what that does. Now, if it changes at all, yeah. Elevate your Google Sheets experience with our curated third party add on marketplace. Top rated gamified tools meticulously designed for productivity. And this is way too wordy. We should probably have more better examples here. I think more examples is going to do better here. Let's try to do something here. The log line or pitch should be a couple of. adjectives no more and the thing it does the best. This is pretty poor engineering, but it's just to give you an example of you can keep adding interesting stuff to your prompt. There, the ultimate seamless gamified add on mark. Wow, that worked. Dynamic, intuitive, gamified add ons for Google Sheets.
Right. So now it's getting less and less. It's taking the information it's giving. We're giving it and using it more right where you can definitely give it more examples. We can definitely give it more startups here. But now this is really cool that someone can take this startup pitch editor . Enter their name here, enter their pitch, and get back exactly a pitch personalized for this particular accelerator here. So we can keep adding more and more here. So I think I will actually rename this to personalized Actually, Startup Pitch Editor is more like It's more like a generator. Startup Pitch Generator. And I'll go and put this available out in the marketplace somewhere. Actually, before I go I wonder what a startup pitch generator, if that was the idea. Let's call it start up and the pitch is a startup pitch generator.
Let's see if it gives us back an interesting personalized pitch for these. Let's look, it's loading. I'm so excited to see what it comes up with. Transformative AI powered startup pitch generator for accelerated funding success. Fundraising success. Reju, revolutionize startup pitches with AI driven precision and creativity. They say a lot by saying nothing, but they, this is a pretty quick created AI generated pitch generator. Pretty cool. Start me up could also be like a coffee bean distributor for digital nomads. Some start me up for the good morning kind of stuff. See if that comes up with anything. Source premium coffee beans for empowering digital nomads with premium coffee. Anywhere. Oh, that's actually really nice. Okay. So you can see how this is useful, but we just created this startup pitch generator
in a few minutes with AI integrated in here as a custom function , so we can create this for someone else to use if you're looking for this and you're not yet a better sheets member become one today. And you can get this exact sheet and script down below at better sheets. Okay.