Create a Headline Generator

Most Popular Advanced

About this Tutorial

Learn to create lead magnet or sellable worksheets for your business. Included are more topic ideas so you can take this template and run with it.

Sheet Resources

Access Sheet

Copy Sheet

Preview Sheet

Featured Formulas

CONCATENATE() PROPER()

Video Transcript

<div> Hello, welcome. We're gonna create a headline generator. The data or the information that I got from this is for, this is from Landing Folio. Go check them out. They have this great headline formula 's, ebook. I'm using the free version if you want more formulas. They have 200 headlines. They're selling that ebook. And also the guy who created Landing Folio, Danny is also creating headline. By the time you watch this, it headline might be, Already operational, but if not, you can go over to headline.io and sign up for their headline generator.

So actually, funny enough, what I'm doing here is a very light version of what I think he's doing at headline and But I'm not really gonna do much of what he's doing there. This is just to show you how to use Google Sheets to make something like this. From this, you could probably, after you watch this video, you could probably make something like sentence generators or if your own headline generators, if you have your own formulas you can. Come up with topic ideas. This is actually a really interesting way.

If you have a couple of key terms or keyword keywords and you wanna generate say 10, 20, 30, or a hundred ideas and the formulas and you just enter it, you can do something like this, which I created, like that is like a web app, or you can even create like a worksheet for your own internal processes or internal business if you want. So here's the idea. We have these. Topics or named areas to fill in. And once we fill those in, we get headlines. Something like and they're based on formulas. So here you see an audience and an undesirable income or a product or solution.

And so a very typical headline might be designers. Are your websites not working? Or developers, are your websites not working? We can do developers. And here's some examples for you developers. Oh, your website. It's not working. Very simple. How to master some product in the shortest time possible. How to master code lead outreach in the shortest amount of time possible product for someone. So code lead outreach for developers. Or if we take in designers, we can go here. It'll say cold lead outreach for designers, right?

So once we enter this, These items, and this is only six we're generating here. We're gonna generate six headlines, but you can also generate many more. You'll see these formulas. You can I'll show you how to make more than this. And here is the one key thing we're gonna do in very interesting today, is we are going to name ranges and this is gonna help us understand or help us generate. Headlines or outcomes than we ever imagined because we'll be able to easily remember what this cell is. So this is D six and we might not remember. Okay. Settings, exclamation point D six.

We can actually name this range and then use that in formulas. How we do that, let's go here is named Ranges , so it's in data named ranges , and I've already created a few audience outcome and product. And for our purposes for this particular case, it's a single cell. And you wouldn't necessarily think like audience is that much different than settings. Exclamation point D six. If okay, audience is there, then I just have to type in settings, exclamation point D six.

But what ends up happening is once we know it's an easy to know word, the formulas are gonna know it consistently all again and will remember it much easier. So we can come back to this and be like, oh yeah, I can add 10 to 12. Headlines very easily by using this formula . The other two formulas I'm gonna be using is concatenate , so I'm gonna use name range . I'm gonna show you concatenate and proper to get a title case. So we want all of our headlines capitalized, but the main thing we're gonna do right now is name very. So how you set this up is actually this column B is nothing.

It's just some text. But this result is a concatenation of audience. Then the phrase are your, and then the named range of outcome and then a question mark. So let me build this one, get something like authority without the pain points. And if you look over here, we have audience outcome and product. We don't have the other one. So I'll show you how to name ranges . So we have what, D 12. So I have that selected and I can click add a range , and I'm gonna call this something done. Then I'm gonna go to D 14. This is authority at a range and look how authority. Very simple.

And then this is D 16 and we'll just do paint done. So you can name it as short or as long as you want. And then we come over here. And now we're gonna do equals conka. Now we're gonna add 'em together. So something, we literally just type something and now it changes colors. So we know it is grabbing the right thing. We put space, like space end quotation marks, and another authority. It changes colors. And then we go space without the, actually I'm gonna take out the without. End exclamation or end quotation mark and then paint and it changes color.

So now we have get a body like Arnold Schwarzenegger without going to the gym. And that was over here. Get a body, Arnold Schwarzenegger going to the gym. And we can also add title case to it. So it's would go proper. Cause it's a headline and we just wrap it in summation points. And now we have a copy and pastable item. So one thing I would. Is if you want to be able to copy and paste this within Google Sheets, so if I copy this cell and paste it within Google Sheets, it's going to copy the formula . What I could also do is insert to the right results.

Let me just call it results. And I'm gonna do array formula up here. Actually do array formula and just do D two to D. And now I just have the text. So one thing is, and I hate to do this, I don't do this very often, but you can hide the column here. And what's gonna happen is every single time you go and see this, you're gonna be like, what's here? You're gonna open it up. You're like, oh I remember. So I wouldn't recommend doing this.

I'd recommend if you do this way, if you add this little array formula and you want just text for someone else, maybe to copy it, instead of having a copy and paste values , like I just paste values . This, I'm sorry. This column can go on a separate sheet and you can call it work or Don't touch this or something. You can protect it and then make this one just the only formula on this entire sheet, if you wish. So that's a little bit of a better item that you can do. One thing to make the sheet a little bit better. Now, let's do the next one. How, so this is gonna be equals conka.

Actually, let's just put the proper there first. Proper concat so we don't have to come back. Concatenate . And now we want how to space end. And then we're gonna do something comma like. And then we're gonna do authority. Let's see what that looks like. How to get a body like Arnold towards and Negar Creek. Now how can you. Equals proper concatenate . Concatenate . Wonder, how can you space something then without, and there you go. There's another one. So now we have literally three items here and we.

Any number of different formats that we can do, we can add 10 more with the same items here and we only have to enter six items and we can get, dozens and dozens of headlines based on this. And this is just using named ranges . It's using cutting catnet and proper. One extra thing you can do to this, and I'll put it into another video. Is you can create dropdown menus here. We will, I'll do that in the second video, but I'll do headline generator with dropdown menus. That's what it'll be called If you are looking for the next video bite.</div>