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.
Members-only tutorial
Watch the video and get the practice sheet with membership.
About this Tutorial
Sheet Resources
Featured Formulas
Video Transcript
<div>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.<br>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.<br>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.<br>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.<br>0:39 So we can say digital marketing is our topic, and we want to write some email subjects that have some text.<br>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.<br>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.<br>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.<br>1:16 One simple trick for add a space, question, uh, quote, and then ampersand is sort of like concatenating or combining text, B1.<br>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.<br>1:40 So now I can change this to better Google Sheets, with one simple trick, one simple trick for better Google Sheets.<br>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.<br>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.<br>2:37 So more customers from digital marketing with this one simple trick, one simple trick for more customers from digital marketing, right?<br>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.<br>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.<br>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.<br>3:40 We can add b1 ampersand, maybe some emojis. Equals b1 ampersand.<br>4:05 Ooh, that's cool. And even if we have nothing here, we have all of the examples here.<br>4:36 We could put a little fun thing here as equals, if, now if b1, blank, enter something. We'll put a quote.<br>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.<br>5:08 Yeah, there we go. Okay, and now. That message disappears. So a little bit of extra here, if formula for you.<br>5:19 And now we have all of these awesome, awesome email subjects. Cool. Hope you enjoyed that one.</div>