create a ton of search phrases from one simple automation trick.
Explore ↓
Hey there stranger!
Generate Google Search Phrases
About this Tutorial
Sheet Resources
Video Transcript
0:00 In this quick tutorial I'm going to show you how to generate a ton of Google search phrases from one keyword or key phrase, and it's going to be a very simple automation.
0:09 We're not doing Apps Script, we're not doing anything other than a bit of formula. So we're going to use equal sign, and we're going to reference this cell B1.
0:18 Then we're going to use an ampersand, and we're going to say, tips, in quotes. We need tips. A space in front of the word tips.
0:26 And there we go. We got our first one. Now, what I'm about to do is just going to do the same thing over and over again.
0:32 It's very much like Searchlord. The Searchlord is a totally free sheet where you can type in one phrase and get a ton of websites that are the search website, the search URL for that keyword or key phrase, and it adds it all.
0:46 It's totally free. Go check it out. Bettersheets.co slash Sheetlord. But right here in this tip, I'm going to keep adding some more things.
0:55 Like, I'm going to do equals B. Actually, I'm going to do equals best space, then ampersand, and then in quotes, tips.
1:06 We're going to add B1 and then another ampersand right there. So we get. That, and we need to copy the format.
1:16 There we go. So we can see it a little bit better. Equals in quotes, top 10 space quote ampersand Google sheets.
1:36 Tools for space quote ampersand Google sheets. And you can see that we can just keep adding more and more and more of these.
1:45 And we're going to get a lot of really cool things. So I added a ton here, best Google sheet tips, how to Google sheets, complete guide to Google sheets, but we can change this to whatever you're doing.
1:57 Digital marketing perhaps, or SEO. Oh, guide, how to SEO guide, how to local SEO in New Zealand, why local SEO in New Zealand is important.
2:12 And we have a ton of these. This is really cool to generate a ton of texts and generate a ton of really cool Google search phrases from one keyword.
2:22 If you want to change that keyword over and over and over again. You want to get the output of all these.
2:26 This is how you do it. Hope you, hopefully you enjoyed this tutorial.
0:09 We're not doing Apps Script, we're not doing anything other than a bit of formula. So we're going to use equal sign, and we're going to reference this cell B1.
0:18 Then we're going to use an ampersand, and we're going to say, tips, in quotes. We need tips. A space in front of the word tips.
0:26 And there we go. We got our first one. Now, what I'm about to do is just going to do the same thing over and over again.
0:32 It's very much like Searchlord. The Searchlord is a totally free sheet where you can type in one phrase and get a ton of websites that are the search website, the search URL for that keyword or key phrase, and it adds it all.
0:46 It's totally free. Go check it out. Bettersheets.co slash Sheetlord. But right here in this tip, I'm going to keep adding some more things.
0:55 Like, I'm going to do equals B. Actually, I'm going to do equals best space, then ampersand, and then in quotes, tips.
1:06 We're going to add B1 and then another ampersand right there. So we get. That, and we need to copy the format.
1:16 There we go. So we can see it a little bit better. Equals in quotes, top 10 space quote ampersand Google sheets.
1:36 Tools for space quote ampersand Google sheets. And you can see that we can just keep adding more and more and more of these.
1:45 And we're going to get a lot of really cool things. So I added a ton here, best Google sheet tips, how to Google sheets, complete guide to Google sheets, but we can change this to whatever you're doing.
1:57 Digital marketing perhaps, or SEO. Oh, guide, how to SEO guide, how to local SEO in New Zealand, why local SEO in New Zealand is important.
2:12 And we have a ton of these. This is really cool to generate a ton of texts and generate a ton of really cool Google search phrases from one keyword.
2:22 If you want to change that keyword over and over and over again. You want to get the output of all these.
2:26 This is how you do it. Hope you, hopefully you enjoyed this tutorial.
Topics