So I wanna search Twitter. All of these keywords and phrases I wanna search for and look for conversations. So let's go to Twitter and search and see what the URL is. So we can go to Twitter, we can go up to the bar and search, and we can see that there is a URL Oh. Well actually copy and paste this into the sheet. The URL is going to be. x.com/search. Question mark Q equals growth. And then this percent 20 is actually a space. It's just an encoded version of a space character. So what I want to do is take just that base here. I'm gonna copy it. We're gonna do it equals hyperlink and I'm gonna put in the URL here.

That's just the base, URL with this q equals. And I wanna put the search query after a. So I'll put a ampersand and then the search query . But one extra thing I wanna do is wrap encode URL around this. This is a formula that will take this spaces and turn them into person 20 or something that the URL can use. So that is the hyperlink there, and let's test it out. We can actually copy paste this down a few times. Let's just test it out. Click on one and see that works exactly perfectly right. I can go to this conversations, I can see the latest ones. I can look through this. I can keep tabs on what's going on and it has this percent 20. This is great, but maybe I don't want this whole entire URL.

Maybe I want a text. Search on Twitter, so I'll put that in quotes. And all of these are search on Twitter, but they are actually underneath that search phrase over there on the left. So here's burn rate and let's see exactly. It's searching for burn rate. Awesome. So now I can see conversations that use that phrase. I can look for conversations that have very specific phrases in them. New to growth hacking and see if there's any conversations about that. Maybe we use the word solopreneur here. Let's see if we can search for that. And just looking for the word solopreneur, not here, but here's my transparent take. So maybe it is conversations from solopreneurs as a solopreneur.

Maybe we want all of this phrase, we can come back here and say, yeah, we want that very specific phrase. As a solopreneur working from Bali. And we can see this search and see what other conversations are happening. We can maybe copy and paste this instead of volume from Thailand or be more specific like Bangkok. And search for those phrases, right? Instead of having to go to Twitter and type this out every time I now have this database. But if you're looking to search on way more sites than Twitter, check out search Lord. It is an absolutely free template . Check it out at Better Sheets dot coast slash search Lord. And you can search single phrases for over. 80 sites. You can also select the ones you wanna search for, or you can even search any number of keywords or phrases across many, many sites.

This is a really easy to use search tool in Google Sheets. Use it and be awesome. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.