NEW TOOL Parse Spintax for Content Spinning

About this Tutorial

Introductng a new tool from Better Sheets. A free Google Sheets™️ Add-On to parse spin syntax content.

Revolutionize Your Google Sheets writing with Spin Tax Content Spinner! Say Goodbye to Tedious Editing. Get All the Variations You Need.

Spin randomly to get one variation
Spin text for all variations
Spin text for all variations including duplicates

Spintax is written with pipes separating content you want to randomly select. {Hi|Hello|Hey} would either be Hi, or Hello, or Hey.

Sheet Resources

Access Sheet

Copy Sheet

Preview Sheet

Featured Formulas

SUBSTITUTE()

Video Transcript

<div>00:00 Alright, in this video we're going to introduce you to a new tool from BetterSheets called Spin Tax Content Spinner, and I'm going to talk about a few problems that I have encountered in Google Sheets and why I created this in the first place and then also how you can use it. 00:15 So let me just show you real quick something that you might be doing in Google. How to Spin Content Advanced Coding in Google Sheets for Programmers Spintax Content Spinner for Google Sheets VIBE CODE GOOGLE SHEETS

So, let's say we were like writing a headline, and we know sort of the structure of the headline is some text, but like one word, we want to see the difference, the different headlines with different words, but we don't 00:39 want to edit the entire, headline. Easily Write 1,000 Headlines How to Spin Content

And there are some ways, and there are many ways to do this in Google Sheets, but none as sort of elegant or flexible as Spintax. 00:53 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. 01:00 Right, this is, the headline is this headline and then a word. And totally fine, right? You're gonna write this, this headline rocks. 01:10 We're gonna have these selection of other words. How to Spin Content Spintax Content Spinner for Google Sheets How to Write Email Subject Variations Fast! SIMPLE GOOGLE SHEETS AUTOMATION

We might come up with other words, and we just wanna write that word out and or phrase, right? 01:17 And we can, look, totally fine if you, Have the time and you really wanna like type this out each time, sure. 01:25 We're going to type it out every single time. That is totally away. It's just exhausting, right? It's tedious, it's boring, right? 01:37 We are sort of limited to the number of words. Here we can't have, let's say, a hundred or a thousand or even ten thousand options here, right? 01:48 And this is only a headline. How to Spin Content

There's many other applications for this kind of textual syntax and we'll talk about that later. 01:56 But what if we did it another way? What if we, we have this list, right? We, we don't need to retype these words. 02:03 We just need the words, this headline again and again. But what if we sort of take a some kind of filler, like we, we know it's we let's move this down. 02:24 We have this, this style, right? How to Spin Content

This, this headline and then a word or phrase and we know what the word or phrase is, it's in this B column. 02:33 And we can, so we can take this and we can say, oh, this is going to be equals let's say substitute. 02:41 Text to search is going to be dollar sign A, dollar sign one, because we don't want to change that as we, we're going to copy it down. 02:50 What are we going to search for? We're going to search for this phrasing word here. And we're going to put that in quotes. 02:58 And then what are we going to replace it with? We can replace it with, with, with whatever. Make Your Headers Useful How to Spin Content Replace Numbers with Asterisks

Whatever is in B column here, B2. 03:04 And we do want to switch out this B2 each time we copy and paste it. So we're going to hit enter, we're going to copy paste this all the way down and we have great. 03:13 We have our answer right now. We can sort of type in any amount of work. We can get AI to produce a. 03:22 Certain number of phrases here, right? We can ask crowd crowdsourcing. We can get other people or we can just sit down and write a hundred different versions of this headline. 03:31 Right? This headline rocks. This headline is awesome. How to Spin Content AI Formula in Google Sheets

This headline faces failure head on. But like this formula . Like are you going to remember? 03:42 Subs. Dude, great. This is a great application of this, right? I love substitute. I use this a lot. I use this in creating templates, creating formats. 03:50 It's awesome. But you're like, ah, there could be a better way to do this. You know, we could wrap this with array formula . 03:57 I think. Let's just like see if that does.. The trick. Gonna get some reference error and see. Yeah, exactly. We can do one formula , right? 04:08 We don't have to copy paste it. Replace 1,000 Formulas Instantly How to Spin Content What is a spreadsheet formula?

But there is still a better way. Now, if I want to. What if I want to switch out this? 04:17 What if you're, I'm like, Oh, there's an. Word to. Like, okay. Now we're getting a little more complicated. I need to now. 04:27 Wrap this substitute with another substitute. It can totally substitute. Totally possible, right?. We are going to take word. To. But like, are you. 04:42 You're going to remember how to do all of this. I teach this in other videos and it's totally fine, right? 04:49 . We're going to do C2 colon C8. Got a little error here. There we go. How to Spin Content CLUTTERED CODE

Then we need to put that. 04:59 And now we go this. Mm. I, your headline is awesome. Okay, we have to type this out this again and again and again, right? 05:10 But what if I'm like, I just want to see all the variations, right? You're like, ah, okay, I got this headline sucks. 05:16 My headline rocks. Your headline is awesome. But what if I could just get these. Lists and say, do all of the versions. 05:26 I want three times this number of lists. This is a list of seven and there's three options for the first word. 05:33 What if I want to create essentially 21 options now? Turn Headlines up to 11! - Update to Spintax Tool How to Spin Content

How do I do this? We're five minutes in the video and we're like, okay, now. 05:43 We have a problem now. We're like, oh, no. Well, that's where SpinTacks for content for Google Sheets and for content spin name comes in. 05:52 We're going to install a Google Sheet add on. Let's go to get add ons. We're gonna, we can search for SpinTacks. 05:58 You can also go to SpinTacks, SpinTacks.BetterSheets.co. You can go there. And see the you can get a little bit more information about it there. 06:08 But you can also just go to work, go to the workplace, Google workplace marketplace. How to Spin Content Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet Spintax Content Spinner for Google Sheets What is a Spreadsheet? Anatomy of a Spreadsheet

And look for SpinTacks. It is the only thing that comes up, SpinTacks. 06:19 It has zero users right now. We're gonna be the first user. You know, individual install or admin install. Easy enough. 06:29 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:42 So we'll. Close this. I think there it is. How to Spin Content Spintax Content Spinner for Google Sheets What is a Spreadsheet? Anatomy of a Spreadsheet

So now in addition to from butter, but from better sheets, we have sheet styles , which styles your sheet and creates a better color. 06:55 We have button size that creates really cool three by three cell buttons. We have tiny sheets, which makes one by one sheets. 07:03 Now we have. Spintech's content spinner. There is a little bit of info here if you want it on how to use it, but I'm going to show you right now. 07:09 There are three functions that we have added to our sheet. Okay. How to Spin Content Spintax Content Spinner for Google Sheets YOU CAN DO BETTER

All we, but we need to do a little bit of work to make sure that our headline is properly formatted. 07:23 Okay. So let's actually duplicate this and I don't want this headline like this. I want to take all of these and delete all these. 07:33 I'm going to go. I need to do no equal sign. All I need to do is curly bracket this capital this with a pipe character. 07:43 My. Okay, pipe character. Your to have the three options at the beginning and then have the word headline and now I just need all of these words in with pipe pipe, pipes as well. 07:57 Interspersed with them. Duplicate Everything For Each Unique Value How to Spin Content Quickly CAPITALIZE Headers

So the delimitator is this pipe and this is all you need to do. So now we have our spin tax in the correct spin syntax . 08:11 We have curly brackets around the things that we want to spin. We want to see. We also have the pipe character in between each of the things we want to spin. 08:24 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. 08:37 And if it's not correct, it won't work. But if it's correct, we will have a random one. How to Spin Content

So the random one it selected out of all this. 08:44 Was your headline is awesome. Great. So that's it. If you just want one version, awesome. Done. But if you're like, I want to have every single possible version. 08:56 Well, we can create another headline. Let me actually add a line here. So this is spin. Spin function . And we get this headline needs an edit. 09:09 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. 09:18 And here we type in equals spin all. How to Spin Content Spintax Content Spinner for Google Sheets

And again, if you install this Google Sheet add on. Spin all will be here. 09:26 It'll be an auto complete. And all you have to do is spin all a to. Now load it for a couple moments. 09:34 And now here are all of the options. We have taken this one piece of text that we're like, Oh, just change this my your headline. 09:41 We want rocks is awesome needs help. And we now. You have should be twenty one options. That's pretty damn cool. 09:51 Right now if there were any particular like if there were duplicates. This spin all will de duplicate it. How to Spin Content Spintax Content Spinner for Google Sheets Automatically Replace Words in Google Sheets

If you want all the duplicates, I don't know if there's going to be duplicates here. 10:04 We're going to use. It was spin everything. And we just do equals spin everything. Select it. We go A2. I don't think we're going to have any duplicates in this one. 10:17 Let's see. Scroll down and see we have no duplicates. How do you get duplicates? Why am I talking about duplicates? 10:25 Well, what if we, instead of like socks, we want, in here we go, last. Duplicate Everything For Each Unique Value How to Spin Content Find Duplicates in Other Column

So what we did is we took out one and we actually created another spin tax inside of rocks. 10:43 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 is rocking rocks. 10:59 We'll parse out first and here we go. So we have, we'll basically give us more chances. How to Spin Content

To have this is or less chances to have is rocking a rocks because it'll parse out this first. 11:11 It'll be like a 50 50 chance in the spin spin one and then 50 50 chance that it's is rocking or rocks is a selection amongst all of these other ones. 11:21 So we actually end up with more duplicates here even though there's. How to Spin Content

The exact same headline so that's why we do de duplicated in the spin all but if you want to see what is the actual chances of each one we're only spinning you know randomly here in the spin spin everything will show you all of the 11:39 chance the chance of every single ones head but they're not different. Hope this makes sense. How to Spin Content

So again you can get spin tax content spinner over at spintax.bettersheets.co or by searching on the Google Marketplace Google Sheets add on marketplace just for spin tax it's totally free right now better  12:00 sheet members are getting notified of this first so if you're not yet a better sheets member become one now. I'm going to be getting these tools first. 12:09 Also I'll be putting out much more content about using this. I just think it's really cool. I want to see what you use how you use it. 12:16 If you have any needs and uses of it show me. Let me see. How to Spin Content Spintax Content Spinner for Google Sheets 5 Google Sheet Templates You’ll Get as a Better Sheets Member

I'll take a look at your sheet. 12:21 I also have sheet improvement videos that I put out. So if you show me your sheet. And you allow me I can make a sheet a little bit better. 12:30 Thanks for watching.</div> Sheet Review of 50 ChatGPT Prompts Sheet Review! Better Band Bureau Better Schedule 2 Forms 1 Sheet