00:00 This is SheetLord. This is a really interesting little app that I've created inside of a Google Sheet that's available completely for free right now over at bettersheets.co slash SheetLord. If you're a lifetime member, monthly member, or even not a member and watching this somewhere else other than BetterSheets,
00:17 you can get this absolutely free. And I'm going to having a number of websites, Twitter, Spotify, Twitch, Gumroad, Expedia, Google Maps, even Upwork, Fiverr, some job sites, some developer sites like Product Hunt, GitHub, all of these sites, you can create a URL with a keyword phrase.
00:41 You just have to combine the words with either plus signs or percent 20. And a lot of them, I'm going to searching for different phrases on different days, or I'm trying to search for competitors, I'm trying to search for phrases of how people are using it, what kind of websites in the knowledge category
01:00 , like Udemy, LinkedIn Learning, I'm looking at competitors, but not based on exactly who they are, but what are their topics, what are they talking about.
01:08 And I want to change this keyword from, like, Google Sheets to Spotify. Spreadsheet information or data visualization. Visualization. And immediately when I type in, in this B2 keyword, ah, place, every single link is edited.
01:29 This allows me to then search very quickly. And one other thing about Google Sheets, that allows me to do this, is if I select, let's say, these four links, I can right-click, view more cell actions, and I can open links.
01:48 And that's going to open every single link. So now I have a bunch of tabs that I can search for very quickly.
01:56 See, what is the conversation about? What is going on? Here's AI tools to create. Great, simple data visualizations. Okay, people talk about AI here.
02:04 Okay, differences between Power BI, Excel. I can quickly see what is the conversation about. And the cool thing is I can do this for all, now 50 plus, now there's over 60 sites here.
02:16 So if I wanted to see what are the courses, I can select just those. Now, this is really cool, right?
02:23 I can save keywords. Here I can do Google Sheets and see what are the Google Sheet courses out there. Right click, view more selections, open links.
02:32 I have all the sites now searching for Google Sheets. See the top ones. What are they talking about? What are they thinking about using productivity, right?
02:45 So that's pretty cool, right? I want to add one more thing to this sheet. The search lord to make it fairly, uh, more interesting to use, right?
02:54 This is one tab. We can create new tabs that are new features that are using the same information but in different ways.
03:02 So, let's duplicate this tab. And I'm going to say search some. Now the idea of the search is that they're all available.
03:13 But let's say I've only selected three or four, and I don't want to have to keep coming down and finding them.
03:20 So what I can do here is add a column to the left, and it is going to be checkboxes. Insert, checkbox.
03:29 And now, when I select, let's say, Twitter, Twitch, and Amazon, For whatever reason, or maybe all of, let's just do the marketplaces.
03:42 Let's go marketplaces, all of these. If I just want to see these, and I don't want to have to scroll down all the way, I'm going to select them all.
03:49 And I want all of these to appear in some kind of place for me. So I'm going to insert, actually, I'm going to do this over to the right.
04:01 I think, no, I think actually to the left is going to be nicer, and to the left. And all I want is a filter.
04:11 I'm going to take the range of D column where the B column is equal to true. So I'm taking all of the D column and just filtering it wherever B is true.
04:25 Which is a checkbox, and there are my links. So now I can select all of these easily without scrolling down.
04:31 I can select some of them, not even in, like, uh, a row. Like, if I selected all of these, but I don't want to search Gumroad, I'd have to command click, and that's a few clicks, right?
04:43 But having these saved where I can search some, and there's the list. I can just select these and search them quite easily.
04:55 So that's search some. This is totally duplicatable, where, as a user, I could say, oh, I want a marketplace search, I want a developer search, I want a course search, I want creative search. I can create those tabs as a user, whichever ones I select.
05:13 Cool? That's a nice little addition to this. I do want, however, a few other things about this, right? When I select none, I get an error.
05:24 So I'm going to say, if an A, select select sum However, let's say Google Images, right? And now I have sum.
05:42 Well, I want to make something else where I can select all of these, instead of actually selecting all of these, hitting the spacebar a couple times.
05:50 How do I do that? Select the B column, press spacebar a couple times, and that now resets. I want to create a tool for someone to just click easily.
06:00 So let's go to extension app script and add a custom menu plus the ability to uncheck all of search sum column B. It's going to be fairly simple, but I think this is going to be very fun and interesting for you if you're following along and trying to make products inside of Sheets yourself.
06:18 So call this search lord. We need an on open function. I'm going to go to bettersheets.co slash snippets. And I have one already saved here.
06:27 This function on open. I can delete some things, rename this from custom menu to search lord menu. Reset checkboxes.
06:42 And I'm going to call this. Let's uncheck all on the search some, but this second part, this reset checkboxes is what I want to actually write a function for reset chunk checkboxes.
07:02 So function reset checkboxes. We need to make sure we're on the right sheet. So we're going to get variable sheet equals spreadsheet app GetActiveSheet.git GetName, if sheet is equal to, let's make sure we get this exact name.
07:22 Then we're going to do something, which is spreadsheet app dot GetActiveSpreadsheet. GetSheetByName, search some, end quotes.
07:32 This will be variable search. Sum equals this. Now we're going to do, search some dot GetRange, B colon B, end quotes, dot uncheck.
07:51 I think that's all we need to do. I'm going to right click and format document to make it look a little nicer.
07:57 Let's delete some spaces, save this. Now, in order to open this menu, I need to actually close the sheet and refresh, or, and open it.
08:07 So, refresh will close it and open it again. Up next to extensions there's help and now there's a search lord menu.
08:14 So, if I select some, here, and I click uncheck all on search some, it will need to authorize the very first time I run it.
08:25 Great. Let's continue. And there, it unchecks everything and it won't ask me to authorize again. Uncheck all. There we go.
08:39 Really cool tool. If you are interested in getting this, it is absolutely free over at bettersheets.co slash search lord. You can find it, see what new and interesting updates there is.
08:50 It's if you get it now, I'm going to be adding more and more interesting things to this sheet, some more features.
08:55 I'll do that in some other videos, but right now, right here, go get search lord and get it as you see it here.
09:01 Uh, I might be adding also some more websites. There's a lot here, but there's so many more. Basically, it's a really cool little formula that we have where we get the search URL and then we either search substitute spaces with plus signs or there is also encode URL where I have some of those here.
09:24 Basically, we can, instead of substitute, we can use encode URL and we don't need this substitute part, and we'll get the exact same link.
09:36 There we go. Google Sheets in Google, ah, that's really cool. I think that's really fun and interesting that we can use both of those formulas and hopefully that's a really cool, interesting thing for you to see that all of these formulas are looking at one cell so we can edit this text completely with
09:55 just editing in the B2, ah, field. Really cool. Thanks so much for watching and let me know what you need, what you want out of Searchlord if you want more interesting features, ah, thanks so much for watching.