Create a simple automation for adding text to a cell of text. Really easy example is to create a lot of email subject lines from one single cell of text.
Explore ↓
Hey there stranger!
Write Email Subject Variations Fast! A Simple Google Sheets Automation
About this Tutorial
Sheet Resources
Featured Formulas
Video Transcript
0:00 So in this video I'm going to show you a really easy automation trick that's going to 10x your output. Really, ah, this is going to help you write text in Google Sheets, but at an incredible rate.
0:12 So, it's very similar to what I've done with SheetLord. This is a site where you can enter one keyword, Google Sheets, or let's say digital marketing, and you see all of these URLs change.
0:24 So all of these URLs are looking at this one B2, and I want to show you how this can be used multiple ways.
0:31 So right here we're going to write email subjects, and we're going to write email subjects with one topic, but we're going to write a ton of email subjects all at the same time.
0:39 So we can say digital marketing is our topic, and we want to write some email subjects that have some text.
0:45 So, what we're going to do is something very simple, is equal. And then whatever cell we're referencing here, we're using B1.
0:56 We're going to use an ampersand, and we're going to add a quote, and then a space, and do with this one simple trick.
1:08 And now, end quote, and hit enter. here. Now I can do this again, equals. But I can put the text in the front.
1:16 One simple trick for add a space, question, uh, quote, and then ampersand is sort of like concatenating or combining text, B1.
1:30 And so now I have two different subjects, or two different texts, right, and these are equal. Email subject variations, but using exactly the same cell.
1:40 So now I can change this to better Google Sheets, with one simple trick, one simple trick for better Google Sheets.
1:49 We can add another equal sign here, b1 ampersand in quotes, space in seven digits. Seven days or less, equals b1 ampersand without spending a dime, equals b1 ampersand quote without any effort, or let's just.
2:24 Do this one effortlessly. There, and see, so we can write any sort of length in this b1 and it can be added.
2:37 So more customers from digital marketing with this one simple trick, one simple trick for more customers from digital marketing, right?
2:48 So we can see the variations here. So we're writing all of these variations based on this one exact cell, and I think there's a really cool automation or optimization and a really amazing use of Google Sheets if you've never done this before, if you've never done a formula before.
3:06 We're just adding equal sign. We're adding b1 ampersand using AI. And of course, we're not using AI. We're just using some simple b1 ampersand while you sleep.
3:28 That's pretty cool. More, better retention rate while you sleep using AI. Effortlessly, right? So now we're adding really cool things.
3:40 We can add b1 ampersand, maybe some emojis. Equals b1 ampersand.
4:05 Ooh, that's cool. And even if we have nothing here, we have all of the examples here.
4:36 We could put a little fun thing here as equals, if, now if b1, blank, enter something. We'll put a quote.
4:56 Enter something in b1. So if we don't have anything here, we'll say enter something in b1. We'll add a emoji up.
5:08 Yeah, there we go. Okay, and now. That message disappears. So a little bit of extra here, if formula for you.
5:19 And now we have all of these awesome, awesome email subjects. Cool. Hope you enjoyed that one.
0:12 So, it's very similar to what I've done with SheetLord. This is a site where you can enter one keyword, Google Sheets, or let's say digital marketing, and you see all of these URLs change.
0:24 So all of these URLs are looking at this one B2, and I want to show you how this can be used multiple ways.
0:31 So right here we're going to write email subjects, and we're going to write email subjects with one topic, but we're going to write a ton of email subjects all at the same time.
0:39 So we can say digital marketing is our topic, and we want to write some email subjects that have some text.
0:45 So, what we're going to do is something very simple, is equal. And then whatever cell we're referencing here, we're using B1.
0:56 We're going to use an ampersand, and we're going to add a quote, and then a space, and do with this one simple trick.
1:08 And now, end quote, and hit enter. here. Now I can do this again, equals. But I can put the text in the front.
1:16 One simple trick for add a space, question, uh, quote, and then ampersand is sort of like concatenating or combining text, B1.
1:30 And so now I have two different subjects, or two different texts, right, and these are equal. Email subject variations, but using exactly the same cell.
1:40 So now I can change this to better Google Sheets, with one simple trick, one simple trick for better Google Sheets.
1:49 We can add another equal sign here, b1 ampersand in quotes, space in seven digits. Seven days or less, equals b1 ampersand without spending a dime, equals b1 ampersand quote without any effort, or let's just.
2:24 Do this one effortlessly. There, and see, so we can write any sort of length in this b1 and it can be added.
2:37 So more customers from digital marketing with this one simple trick, one simple trick for more customers from digital marketing, right?
2:48 So we can see the variations here. So we're writing all of these variations based on this one exact cell, and I think there's a really cool automation or optimization and a really amazing use of Google Sheets if you've never done this before, if you've never done a formula before.
3:06 We're just adding equal sign. We're adding b1 ampersand using AI. And of course, we're not using AI. We're just using some simple b1 ampersand while you sleep.
3:28 That's pretty cool. More, better retention rate while you sleep using AI. Effortlessly, right? So now we're adding really cool things.
3:40 We can add b1 ampersand, maybe some emojis. Equals b1 ampersand.
4:05 Ooh, that's cool. And even if we have nothing here, we have all of the examples here.
4:36 We could put a little fun thing here as equals, if, now if b1, blank, enter something. We'll put a quote.
4:56 Enter something in b1. So if we don't have anything here, we'll say enter something in b1. We'll add a emoji up.
5:08 Yeah, there we go. Okay, and now. That message disappears. So a little bit of extra here, if formula for you.
5:19 And now we have all of these awesome, awesome email subjects. Cool. Hope you enjoyed that one.