In this video I'm going to introduce you to a new tool from Better Sheets called spintax Content Spinner.
Free add-on you can install in sheets today.
Get Spintax free: https://spintax.bettersheets.co/
How to Spin Content - YouTube
(00:00) All right. And in this video we're going to introduce you to a new tool from Better Sheets called spintax Content Spinner. And I'm gonna talk about a few problems that I've encountered in Google Sheets and why I created this in the first place, and then also how you can use it. Let me just show you real quick something that you might be doing in Google Sheets or writing, or you might want to do in Google Sheets.
(00:22) So let's say we were like writing a headline. And we know the structure of the headline is some text, but like one word, we wanna see the difference, the different headlines. With different words, but we don't want to edit the entire headline. And there are some ways, and there are many ways to do this in Google Sheets but none as elegant or flexible as Spintax.
(00:48) So I'll explain Spintax in a moment, but let me talk about how you might solve this right now and maybe even some more ideas, right? This is the headline. Is this headline and then a word and. Totally fine, right? You're gonna write this headline, rocks, we're gonna have these selection of other words.
(01:07) We might come up with other words and we just wanna write that word out and or phrase right. And we can look totally fine. If you have the time and you really wanna like type this out each time. Sure. We are going to type it out every single time. That is totally away. It's just exhausting. It's tedious, it's boring, right? We are limited to the number of words here.
(01:33) We can't have, let's say a hundred or a thousand or even 10,000 options here, right? And this is only a headline. There's many other applications for this kind of textual syntax and we'll don't talk about that later, but, What if we did it another way? What if we have this list, right? We don't need to retype these words, we just need the words, this headline again and again.
(01:57) But what if we take a some kind of filler, like we, we know it's a word and we say, okay, we want to, let's actually insert a row above here. Let's move this down. We have this style this headline, and then a word or phrase, and we know what the word or phrase is. It's in this B column. And we can, so we can take this and we can say, oh, this is going to be equals let's say substitute text to search is going to be.
(02:29) Dollar sign. A dollar sign one, because we don't want to change that as we're gonna copy it down. What are we gonna search for? We're gonna search for this phrasing word here, and we're gonna put that in quotes. And then what are we gonna replace it with? We can replace it with whatever is in B column here at b2.
(02:48) And we do want to switch out this B2 each time we copy and paste it. So we're gonna hit enter. We're gonna copy paste this all the way down and we have. Great. We have our answer right now. We can type in any amount of words. We can get AI to produce a certain number of phrases here, right? We can ask crowd crowdsourcing.
(03:09) We can get other people, or we can just sit down and write a hundred different versions of this headline, right? This headline, rocks, this headline is awesome. This headline faces failure your head on, but like this formula. Are you gonna remember substituting great? It's, this is a great application of this, right? I love substitute.
(03:27) I use this a lot. I use this in creating templates, crane formats. It's awesome, but you're like, ah, there could be a better way to do this. We could wrap this with array formula. I think. Let's just see if that does the trick. We're gonna get some reference error and let's see. Yeah, exactly.
(03:47) We can do one formula, right? We don't have to copy paste it. But there is still a better way. Now if I want to, what if I want to switch out this? What if you're, I'm like, oh, there's an word two. Okay, now we're getting a little more complicated. I need to now wrap this substitute with another substitute again.
(04:10) Totally. Substitute. Totally possible. We are going to take word two, but are you gonna remember how to do all of this? I teach this in other videos and it's totally fine. We're gonna do C two colon C eight. I think we got a little error here. There we go. I think we need to put that and now we go this.
(04:37) My, your headline is awesome. Okay? We have to type this out, this again and again, right? But what if I'm like, ah, I just wanna see all the variations, right? You're like, ah, okay, I got this headline sucks. My headline, rocks. Your headline is awesome. Ah, but what if I could just get these. Lists and say, do all of the versions.
(05:00) I want three times this number of lists. This is a list of seven and there's three options for the first word. What if I want to create essentially 21 options now? How do I do this? We're five minutes into the video and we're like, okay, now we have a problem. Now we're like, oh no. That's where spin tax for content for Google Sheets and for content spinning comes in.
(05:25) We're going to install a Google sheet, add-on. Let's go to get add-ons. We're gonna. We can search for Spintax. You can also go to spintax spintax dot better sheets.co. You can go there and see the you can get a little bit more information about it there, but you can also just go to work, go to the workplace, go Google Workplace Marketplace.
(05:44) Who, and look for spintax. It is the only thing that comes up. Spintax. It has zero users right now. We're gonna be the first user new individual install or ad admin install. E easy enough. You will go through this sort of allowing access to your spreadsheet. It is adding three custom functions we will use right now in this video.
(06:08) So we'll just close this, I think. There it is. So now in addition to from butter, but from butter sheets, we have sheet styles, which Styles your sheet and creates a better color. We have button sizes that creates really cool three by three cell buttons. We have tiny sheets, which makes one by one sheets.
(06:26) Now we have spintax, hunt and spinner. There is a little bit of info here if you want it on how to use it, but I'm gonna show you right now, there are three functions that we have added to our sheet. Okay? All we, but we need to do a little bit of work to make sure that our headline is properly. Formatted.
(06:46) Okay, so let's actually duplicate this. And I don't want this headline like this. I want to take all of these. I'm gonna delete all these. Okay. I'm gonna go, I need to do no equal sign. All I need to do is curly bracket this actually capital, this with a pipe character, my pipe character, your to have the three options at the beginning and then have the word headline.
(07:13) And now I just need all of these words in with pipe pipeline pipes as well, intersperse with them. So the denominator is this pipe, and this is all you need to do. So now we have our spintax in the correct spin syntax. We have curly brackets around the things that we want to spin. We wanna see we also have The pipe character in between each of the things we wanna spin.
(07:43) So the first function that we have available to us is equal spin. This will get a random version. So again, we have to make sure that we have our spin syntax correct. And if it's not correct, it won't work. But if it's correct, we will have a random one. So the random one, it's selected out of all this was, your headline is awesome.
(08:04) Great. So that's it. If you just want one version, awesome. Done. But if you're like, I wanna have every single possible version we're gonna create another headline. Let me actually add a line here. So this is spin function, and we get this headline needs an edit. But now if we want to get all of them, if we want to get every single version possible, but without duplicates, we're going to use Spin All.
(08:35) And here we type in equals Spin All. And again, if you install this Google Sheet, add-on Spin, all will be here. It'll be in Auto Complete. And all you have to do is spin all A two. Now load it for a couple moments and now here are all of the options. We have taken this one piece of text that we're like, oh, just change this.
(08:56) My, your headline, we want rocks is awesome, needs help, and we now have, should be 21 options. That's pretty damn cool right now. If there were any particular, like if there were duplicates, this spin all will de-duplicate it. If you want all the duplicates. I don't know if there's gonna be duplicates here.
(09:20) We're going to use spin everything, and we just do equals spin everything, select it. We go A two. I don't think we're gonna have any duplicates in this one. Let's see. And scroll down and see. We have no duplicates. How do you get duplicates? Why am I talking about duplicates? What if we, instead of.
(09:43) Like socks we want in. Here we go. Last. So what we did is we took out one and we actually created another spintax inside of rocks. So instead of saying we have the choice here we have more choices within. So we have this loading and you'll see there are now duplicates because we have this iraqian. Rocks will parse out first and here we go.
(10:14) So we have Will basically gives us more chances. To have this is, or less chances to have is rocking and rocks, cuz it'll parse out this first, it'll be like a 50 50 chance in this spin. Spin one and then 50 50 chance that it's is rocking or rocks is a selection amongst all of these other ones.
(10:32) So we actually end up with more duplicates. Here, even though they're the exact same headline. So that's why we do de-duplicate it in the spin all. But if you want to see what is the actual chances of each one, we're only spinning, randomly here in the spin spin, everything will show you all of the chan, the chance of every single one, the head, but they're not different.
(10:55) I hope this makes sense. So again, you can get spin tax content spinner over spintax.bettersheets.co or by searching on the Google Marketplace. Google Sheets add-on Marketplace just for Spintax. It's totally free right now. Better sheet members are getting notified of this. First. So if you're not yet a better Sheets member, become one now and you'll be getting these tools first.
(11:18) If you're looking to write more in Google sheets, check out this video that I made to create recreate chat GPT inside a Google sheet. Members get to see that and get updated GPT four access. Also, if you're looking for more productivity hacks. Check out this template that I redesigned from Ali Abdaal.
(11:37) I think you'll enjoy