Turn Headlines up to 11! [Update to Spintax Tool]
Discover how to enhance your headlines using the updated Spintax tool in Google Sheets, allowing you to generate multiple variations effortlessly. This video showcases the powerful features of Spintax, including the new spin generate function that utilizes OpenAI's API.
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 . Uh, 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, uh, A lot of people use Spintax to do cold email or email sort of variations, uh, 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, so I wrote this, uh, extension, or extension, Google Sheet add on that is called Spintax and I've just updated it with a way to generate Spintax. 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.
now in addition to what it did before. Um, so I want to explain a little bit about Spintax. Spintax looks like this. We have a phrase like, hello. Instead of one word, we use curly brackets and pipes. So curly brackets to say, hey, we're just going to select one thing from here, and then we use pipes. Um, that's just above the return key on Macs. I don't know where it is on, uh, PCs, but now we have a selection of world, earth, and there. And so the three phrases you can see from this are hello there, hello earth, and hello world. 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. And what we're using is this Spin all function . This spin all function is from Spintax, so go up to extensions, add ons, get
add ons, and you're going to have to install this, it's totally free, uh, 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 here, uh, it's by BetterSheets, it's me, I'm Andrew, I'm the Google Sheets wizard behind BetterSheets, uh, and I made this Spintax content spinner, and again, Just to reiterate, we, this already was able to do this. It actually has three functions . You can spin, and what this does is just gets a random version of this, one of them. You also have spin all, which gets every possible unique result. And then, Sometimes you're going to have duplicates. So if you do spin everything, this includes possible duplicates. 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. We can spin generate, and I'm going to get to that eventually of how to do that. But. You're gonna need an API key, OpenAI, uh, right now, I'll be adding more, uh, models as I can, but right now, it works with OpenAI. So again, this is Spintax, you can write something like this, hello, and you can get all of these versions, hello there, hello earth, hello world. But here's another version, we have 357 here, and words, headlines, blogs here were better ways to write. This will result in about 9, uh, things, because it's gonna give us every version of 3 words, 5 words, 7 words, Three headlines, five headlines,
seven blogs, headlines and blog. So it'll give us nine versions, three times three, here. So if we have, now with 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 gonna be three times three times three, so this should actually be twenty seven, uh, 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 B 14 super easy to use this Function I again. I'm just using if just because it's fun to have these On and off switches essentially to show you. Uh, 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, uh, options here. 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, this kind of blog post could work for a lot of different roles. You know, there's a lot of different roles that use Google sheets. Uh, so many people, account managers, accountants, business consultants, CEOs, copywriters, e commerce managers, financial analysts. I've written here a hundred and I think 26 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. So to create this spintax, you see here in D two, 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. For now, I'm using the join function here with a pipe in between them for a two to a 27 to get all of those 126 rolls, and then for the outcomes. Uh, I'm also getting a jo using join and putting it inside two curly brackets. So, what I end up with is, uh, 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, 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. So yeah, that's a lot of variations and it's something where you can use this to create basically programmatic content in some ways. Sometimes you can, that's how I'm showing you here, these headlines, to write headlines, right? But what if you have like a phrase and you're like, how would I ever create the spintext for this? 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? Uh, some ideas might be, uh, 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. And so what we can do is use the jet spin generate. So again, I'm using the if function here just to have a little bit of magic too. So I can click this, this checkbox button and it'll magically appear. But inside we're using just spin generate. So here we could just do spin. Generate, and C2, uh, I did, before I did this, I went up to extensions, Spintax, and I set up my API over here, so you do have to add your API, OpenAI, API there, and here it is. Writing is painful, writing is a struggle, writing is difficult. So those are three different sentences, but all similarly, similar sentiment.
This is so easy, this is a breeze, this is a piece of cake. So now we have three options in each one. Thank you. Uh, and we could write this a little bit differently, but it gave, it gave us a really good example right away. 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. We have nine variations here. Writing is painful, this is so easy. Writing is painful, this is a piece of cake. 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. 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 all here. So actually anyone who's watching this video on, uh, better sheets that go, I'll give you the link down below of this, uh, sheet. If you're not watching this on better sheets, if you're watching this somewhere on like YouTube, go become a member of better sheets stock code today to get this sheet in specifically, but you can get the spin tax absolutely free and just add your own API key. So let's see, let's see what, what does it take to increase revenue these days? Here's all the variations of that. And again, it just gives you some ideas of what you can do. That's only two options there. 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. And let's see those versions.
Again, I'm just using transpose and spin all. In what ways can utilizing Google Sheets generate income in the current market? 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? See, these are all the sentiment is like the same, right? And that's what spin tags is really good for is like just giving us different words to use or generating completely different headlines. Possibly, if you want, like very distinct, different keywords, this is really cool. If you want to generate a lot of SEO headlines, a lot of SEO ideas, um, generate, you know, simple text. With this, but yeah, use the spin generate
now in Spintax, totally free, but of course you have to pay for the AI, uh, tokens, um, and the API is OpenAI right now. But yeah, uh, I'm really excited to see what you use this for. If you're a BetterSheets member, email me back, uh, what you're using this for, what you can 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, bye.