Turn Headlines up to 11! - Update to Spintax Tool

Intermediate

About this Tutorial

Updated the Spintax tool to allow you to generate Spintax. Instead of having to come up with it all yourself, you can let AI generate the Spintax for you. Create variations on headlines, or phrases, or emails.

Sheet Resources

Access Sheet

Copy Sheet

Preview Sheet

Featured Formulas

CONCATENATE() IF() JOIN() TRANSPOSE()

Video Transcript

<div>0:00 This is Spintax. It allows you to turn headlines up to 11, essentially. Get a ton of variations from just a simple syntax , or spin syntax . 0:12 That's one use that I like using it for, is to create headlines.

You can also use it to come up- with different ideas, do Facebook ads kind of thing a lot of people use Spintax to do cold email or email sort of variations. 0:27 It's very much used in that world, but I wanted to create in Google Sheets a way to- simply write a few words and get a lot of iterations and Spintax is the way. 0:36 So I wrote this extension or Google Sheet add-on that is called Spintax and I've just updated it with a way to generate Spintax. 0:45 So what it did before, I'll show you and then I'll show you what it does now in addition to what it did before. 0:51 So I want to explain a little bit about Spintax.

Spintax looks like this. We have a phrase like hello world but instead of one word we use curly brackets and pipes. 1:00 So curly brackets to say hey we're just going to select one thing. From here and then we use pipes. That's just above the return key on Macs. 1:10 I don't know where it is on PCs. But now we have a selection of world, earth, and there.

So the three phrases you can see from this are hello there, hello world, hello earth, and hello world. 1:21 And all we have to do is write hello once and we have all of the variations of world, earth there with pipes between them and curly brackets around them. 1:30 And what we're using is this spin all function . This spin all function is from Spintax. So you go up to extensions, add-ons, get add-ons, and you're going to have to install this. 1:43 It's totally free for Google Sheet users, Spintax. Just search for that. It's the only one there.

Spintax content spinner and you're going to install that. 1:52 Here, it's by BetterSheets, it's me, I'm Andrew, I'm the Google Sheets wizard behind BetterSheets, and I made this Spintax content spinner. 1:59 And again, just to reiterate, this already was able to do this. It actually has three functions . You can spin. And what this does is it just gets a random version of this, one of them. 2:12 You also have spin all, which gets every possible unique result. And then sometimes you're gonna have duplicates.

So if you do spin everything, this includes possible duplicates. 2:24 Sometimes you will have duplicates. So spin all will be literally everything, spin everything will be everything without the duplicates. But now there's a new one. 2:33 We can spin generate. And I'm gonna get to that eventually of how to do that, but you're gonna need an API. 2:41 I right now I'll be adding more models as I can. But right now it works with open AI. So again, this is spin tax. 2:49 You can write something like this. Hello. And you can get all of these versions. Hello there. Hello Earth.

Hello world. 2:54 But here's another version. 3, 5, 7 here and words, headlines, blogs here were better ways to write. This will result in about nine things because it's going to give us every version of three words, five words, seven words, three headlines, five headlines, seven blogs. 3:13 So it will give us nine versions, three times three here.

So if we have now this headline where it's like a number , a different word for methods and a different word for either words, headlines or blogs, this is going to be three times three times three. 3:27 So this should actually be twenty-five. Twenty-seven twenty-seven variations. And so it'll load and it will use spin all again. I'm using if right here just to have a little checkbox , but essentially this is just equals spin all and B14. 3:44 Super easy to use this function .

Again, I'm just using if just because it's fun to have these on and off switches essentially to show you. 3:55 But yeah, here's 27 variations of one headline. Where all we have to write is this pipe version and right now I'm only using three, but we can actually use way way way more Options here. 4:08 We just have to have curly brackets around them and then pipes in between each item So for instance, I come up with a lot of blog posts where I'm like, this kind of blog post could work for a lot of different roles. 4:22 You know, there's a lot of different roles that use Google Sheets.

So many people. Account managers, accountants, business consultants, CEOs, copywriters, e-commerce managers, financial analysts. 4:31 I've written here. 126 roles and I have a few outcomes for each one.

So I want to have a different headline for every single outcome, for every role and every outcome. 4:43 So to create this spintax you see here in D2, I've had to actually use concatenate to concatenate what I think is Google Sheets, must have skills, business ideas, tips, tricks, all these options. 4:56 Four, now I'm using the join function here with a pipe in between them for A2 to A27 to get all of those 126 roles. 5:05 And then for the outcomes I'm also getting a jo- using join and putting it inside two curly brackets B2 to B10. 5:15 So, what I end up with is you'll see here.

5,600, more than 5,600 options because I have 125 times, I have 1, 2, 3, 4, 5 options for that like second phrase, best practices, must have skills, business ideas, and I have 5, so it's 125 times 5 times 9, so it's 125, let's see, 125 times 5 times 9, 5,625 5:50 , so yeah, that's a lot of variation. And it's something where you can use this to create basically programmatic content in some ways. 5:58 Sometimes you can, that's how I'm ah showing you here these headlines, to write headlines, right?

But what if you have like a phrase and you're like, how can would I ever create the spin text for this? 6:10 Like sometimes, you don't necessarily know like, here's an easy phrase, writing is painful, this is so easy, what would you change here? 6:20 Some ideas might be you could have completely different text, which is like drawing is painful, lawyering is painful, right? But maybe you want something around the same idea, like you want to get across the same idea but you want it in different ways. 6:36 And so what we can do is use the gen- spin generator.

So again, I'm using the if function here just to have a little bit of magic, so I can click this, this checkbox button and it'll magically appear. 6:47 But inside, we're using just spin generate, so here we could just do spin generate and c2. I did- Before I did this, I went up to extensions, spin text, and I set up my API over here, so you do have to add your API, OpenAI API there, and here it is. 7:06 Writing is painful, writing is a struggle, writing is difficult. So those are three different sentences, but all similarly.

This is so easy, this is a breeze, this is a piece of cake. 7:16 So now we have three options in each one, and we could write this a little bit differently, but it gave us a really good example right away. 7:24 And now I want to spin all, and so I'm going to just use spin all here. I'm going to transpose it across to the right, and here's all of the variations. 7:32 We have nine variations here. Writing is painful, this is so easy. Writing is painful, this is a piece of cake. 7:38 So that's really cool that we can have multiple versions of this right away.

Can a Google Sheet Wizard? Catch a break, let's see what AI thinks it should, can, is it possible for, could, spreadsheet wizard, get a break. 7:54 That's cool. So let's see all the versions of that again. I'm just using transpose here, and spin all, and we got it. 8:01 So actually, anyone who's watching this video on bettersheets.co, I'll give you the link down below of this sheet.

If you're not watching this on BetterSheets, if you're watching this somewhere else like YouTube, go become a member of bettersheets.co today to get this sheet individually. 8:23 So if you're watching this on YouTube, I'll give you the link down below of this sheet. What are options there? 8:33 We could probably do a lot better here. How can Google Sheets earn me money these days? Let's see what AI has to offer. 8:42 And let's see those versions. Again, I'm just using Transpose and SpinAll.

In what ways can utilizing Google Sheets generate income in the current market? 8:50 Wow, that is a mouthful. But yeah, it gives you a lot of options. Wow, a lot more. In what ways can Google Sheets generate income in the current market? 8:58 See, these are all, the sentiment is like the same, right? And that's what Spintax is really good for.

It's like just giving us different words to use or generating completely different headlines possibly if you want like very distinct different keywords. 9:13 This is really cool if you want to generate a lot of SEO headlines, a lot of SEO ideas, uhm generate you know simple text. 9:20 With this but yeah use the spin generate function now in spintax totally free, but of course you have to pay for the AI tokens and the API is Open AI right now, but yeah, I'm really excited to see what you use this for If you're a betasheets member email me back What you're using this for what you can 9:41 use this for and I'm happy to help you through it if you're looking for some Interesting uses happy to talk to you about it Looking forward to it. 9:49 Bye</div>