So recently I'm trying to create a sheet where I'm searching Amazon and I'm getting prices, and I don't really want to scrape Amazon for these kinds of things because I actually want to go and identify them and get an exact thing and say, here's the price for that thing. So. But I wanna search Amazon very quickly, so I don't wanna have to go to amazon.com and search underwater puzzle. I wanna a link right here that searches it so I can actually go to amazon.com, go up to the search up here, and type in some kind of search, and it's going to give me a URL. Now I can put in that URL here, but how do I programmatically do it for all of these? Well, I'll show you. I'm gonna just edit this URLA bit. So we need to first go to equals and then put it into um, quotes.

And now I'm not gonna put the actual query . And if we see, we see amazon.com/s. Question mark K equals. So this means that everything past the K over here, we need to put into what's called like sort of URL encoded language. But this is just the text over here. And what we can do is add an ampersand. And then encode URL. And that's a formula that's gonna take whatever text is here and encode it in a URL usable text. So we just put a two and now it's gonna suggest auto fill . And you can see these U RLS here. Let's go click on that and test it out. Underwater puzzle. Yes, these are all underwater puzzles. Perfect. I can go and select the one that I want.

Ooh, there's a round one here, so maybe I want to add round underwater puzzle and just get those. But see, the URL here has automatically updated, so I don't have to go up to here and add round and then look there. I can just click here. So anything I add to that, I can just click. There's all the round underwater puzzles. What's really cool is I can select that, but what if I search like the national championship puzzles and I'm like, these are not them. There's another site that I actually have to go search and that's Ravens Burger. Now, Ravens Burger also has a search, and I can search up here 2020 maybe 2026. Championships, hit enter, and I'm gonna copy this URL up here, but I'm not gonna copy anything

after the ampersand, just this query part. And now I can go here and add Ravens burger equals and put in quotes. And just put in quotes the URL. And again, we can see, we can read this URL and say, Ravensburger us English, US search, question mark query equals. And now we can see that the query is just the words with plus in between. So we end that quote, we add ampersand and the same things we did before as we do in code URL, select that text that we want to put there and it enter. And now I can select Ravensburger search and it's going to search this particular site for exactly what I want.

That search query . Perfect. So I found, ooh, 500 Canada Jigsaw puzzle. Wow. Really cool. And maybe I don't want 2025. I just want championship. Maybe I just want championship. But no matter what I change here, these URLs are automatically updated. So I get maybe look for tropical vibes from a ravensburger and it'll take a moment. But that moment is all on the computer side, so maybe your computer is faster. There's the tropical vibes from the USA Nationals 2026. Perfect. So now I can find that exact price and get a link to it. I can add more links if I wanna purchase link there. I can also. Clip these to make it look a little bit nicer. But I have these automatic links to search Amazon, search any

kind of shopping site I want. Hopefully that was fun for you. 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.