🚀 Add to Chrome – It’s Free - YouTube Summarizer
Category: N/A
No summary available.
00:00
Have you ever wondered how some businesses or individuals always know what are the top selling best products or Amazon before everybody else? In this video, I'm going to show you how to automate that exact same thing using AI.
I'm going to use Nadan, which is a no code platform to show you how to build
00:16
an automation that will send you on a daily basis the top selling Amazon products in different niches like home improvements, electronics, or whatever you are interested in without you writing a single line of code. I'm going to show you step by step how to build this.
So that way once you get it set
00:32
up, all you have to worry about is checking your email or Google sheet and all of the data will be updated there on a daily basis. This is going to be a no code solution regardless of your background.
Even if you have never done anything we this will make sense to you because I'm going to walk through step by step and show you how to build this
00:47
thing. So, make sure you stick around till the end because you will learn a lot about this particular industry where then you can sell this to businesses or if you already have a business, you can use this to make your business way more efficient and stay competitive in the market.
All right, without any further delay, let's jump right into the video.
01:03
All right, so let's get started. Uh, I'm in my blank NADN workflow.
If you guys are new to NAND, if you don't know, I'm going to put the link in description. You can go ahead and go to uh Naden through that link.
You can sign up for a free 14-day trial. and you know afterwards you'll come in and click on a
01:19
new workflow. This is where you'll end up.
Okay, so let's go ahead and get started with a demo and then I'm going to go ahead and walk through step by step and show you exactly how this is done. And again, regardless of your background, this will be very simple and I'll walk through step by step and show you uh the different things that you can
01:35
do. So regardless of your background, it should make sense.
All right, so I'm going to go ahead in order to do the demo. I'm going to head over to my community here.
I'm just I just want to download or grab the workflow here. So if I come to let me make sure I'm yeah this one under workflow automation scroll down edit end blueprint.
So edit
01:52
end blueprint is basically the JSON file that you can upload very easily into your uh canvas there and it will bring everything over. So I'm just going to click on download here and then head over to my nadn and then you're going to come on the top right hand corner on the three dots here you're going to click
02:08
and you're going to click import from file. So, this is going to open up.
Uh, go to your folder, the downloads, and just going to double click on that or just open it. And this is going to bring over all of the nodes that are there.
Okay. So, let's go ahead and do a demo.
02:24
As far as uh the trigger itself, you could do a schedule trigger uh which means that for production, when you're doing this for yourself or for your business, you can do a schedule trigger where you're um triggering it automatically every day or something like that. But for this demo, I'm just
02:39
going to do this manual which says when clicking a test workflow. So, let me go ahead and get rid of the schedule trigger here.
Okay. So, in order to um let's go ahead and check a particular um top seller for a uh particular area.
02:55
So, if I go to my school again on top here, I have like a nice little link Amazon bestsellers. If I double click on this or sorry, if I click on this, this is going to open up all of the Amazon bestsellers in different categories, right?
So, there's bestsellers in clothing, shoes, jewelry, bestsellers in
03:10
home, kitchen, electronics, automotive, and whatever it may be. So, whatever you're interested in, you can just go ahead and take a look at that.
But I'm going to uh let's see. Let's try bestsellers in home and kitchen.
Yeah, let's do that. So, I'm just going to click on see more.
And all I have to do is copy this URL
03:28
here. So, I'm just going to copy that URL and go back to my uh workflow here.
And I'm going to double click on this and change this URL right here. Don't worry about this.
I'm going to explain everything step by step. I just want to show you uh that you can just
03:45
essentially click a button and see what the result is. And then afterwards I can come back and take a look at it.
All right. So and then also I have a Google sheet.
So this node right here basically once this automation goes through it goes to two different route. It will output the data in the Google sheet and then also it can send us a slack.
So let's go ahead and take a look at the
04:00
Google sheet and we'll come back take a look at the slack as well. So, I'm going to This is the Google sheet that you'll have.
The way to grab this is you literally come here, click on Google sheet template link here if you're part of the school community. If not, then that's fine.
You can just create your own. It's pretty simple.
Like, it only has a few columns. Okay.
04:18
So, let's go ahead and now click now that we put that u uh bestsellers Amazon bestsellers on home and kitchen. Let's go ahead and click on this.
I'm just going to click on test workflow.
04:35
All right. So, this is going to now utilize our OpenAI node uh to be able to grab the information that's coming in because there's going to be a lot of data that's going to come in from that's going to be coming in from our scraper.
So, what this is going to do is just summarize and make it useful data
04:50
because when you scrape a website or you scrape a platform like Amazon uh through the URL, it sends a lot of data. So you want to be able to use a code node to grab a piece of that information so we can send it to our AI note that then will summarize and extract the data that
05:07
we need. Right?
So that's what's happening right now. So that's why it takes a little bit depending on which model you use to be able to grab that piece of information and then it will send it over to the rest of the nodes and then um update our Google sheet here with the top 10 rank ones.
05:23
All right, there you go. Perfect.
So now if we go there you go. So if I just expand this a little bit, you will see that these are all the top 10 ranks including the Amazon link here.
All right. So if we um zoom in right here, let me zoom in
05:40
a little bit so that way you can see this better. All right.
So, the top 10 ranked on the home uh bests sellers for this uh home and kitchen is this liquid ant baits uh this Amazon basic for microfiber
05:56
lightweight uh bed sheets, this Stanley Quincher H2O and queensiz bed, right? So, let's go ahead and take a look and make sure that that's what it shows.
If you can see right here, number one and killer, second one, the Amazon basic third one this quincher. So, it looks like it worked out.
It worked perfectly.
06:13
And obviously you can depending on whatever department you're in, you can just all you have to do is just go and change the URL inside uh this set node over here and it will scrape that. And then also um earlier for example I used this open ad to send myself a slack.
So
06:29
this is what that result looks like. So right here as you can see it gives me the top uh 10 best products.
Earlier I scraped for electronics. So, it just gave me a nice little list and we can work with this to format it whether we want to send it to our Slack or email or something else.
All right, so that was
06:45
kind of the demo. Now, let's go ahead and build this thing out step by step.
So, I'm going to remove this. Okay, so we're in our blank worksheet here.
Let me also get rid of this so that way we start fresh.
07:02
All right, perfect. So, we got blank worksheet there and we got our uh blank workflow here.
So the first thing we need to do is we need to uh let me actually go and show you so that way we know exactly what's going on. So the first step is to add a trigger and then the second one is to scrape Amazon
07:18
bestsellers to write data. So let's go ahead and work on this particular step.
So I'm going to head over here again. Like I said, if you're building this for uh for for yourself, for your business, or if you're trying to sell this, this would be you would add like a schedule
07:34
trigger, right? because you want to automate this complete process.
But for me, for this demo purposes, I have to use this manual trigger right here. So if I go to the right hand corner here, these are all the different triggers there.
So I'm just going to click on trigger manually. All right, perfect.
So the next step is uh we need to add a set
07:50
node that is going to grab our bright data URL for that uh top selling Amazon product. So let's go ahead and add a set node.
I'm just going to search for set node. Grab it right here.
All right. So, before we do this, let's go ahead and
08:06
create a Bright Data account. All right.
So, I'm going to head over to Bright Data here uh to the website. This gives you you can start a free trial here.
You don't have to put your credit card. It gives you really good free credit.
So, feel free to do that. I'm going to put the link in the description so that way you can click on this as well.
And by the way, I'm not being sponsored by
08:22
Bright Data or anything like that. This is just because I use I use Amplify.
I use different products as well. Sometimes I sign up for an affiliate lick just because uh you know sometimes I get kickbacks but other than that so when you guys see that I'm you know I'm not promoting these products is sometimes I just use it for my own
08:38
personal use. I just find it useful.
So therefore I uh you know uh provide this feedback or just use this system and then I show you. Okay.
Uh let's go ahead. All right.
So once you come over here you're going to click on start free trial. You can put your email here.
I'm just going to use Google. I created an
08:55
account but with a different email. I think I should be good here.
Okay, you have no more free test credits. Yeah, I'd already used this, but once you create this account, this will give you a free test credit.
Um, since I already used it earlier, then I don't have any free test credits, but you should
09:10
already have one. So, once you're here, what you're going to do, you're going to come over to this proxies and scraping.
Once you come over here, you're going to click on this web unlocker API and you're going to click on get started. So this is where you need to create a a
09:27
zone here. Again part those of you who are part of my school all you have to do I've given provided this link for you.
So you just got to click on this create bride data zones and it'll bring you exactly the same exact spot. So you don't have to worry about what this is doing.
The only thing you need
09:42
to do is just name a zone. And again this is uh you can come here and take a look at this little uh information here.
So zone name could be anything you know as long as it's like lower case. So name it something that you recognize, right?
For example, u my web locker or something like that, right? So for
09:58
example, let's just do my web locker or my web unlocker. Okay.
Okay. So once you name it, you can just click on create.
And um I can't do this one because I've already have another one. Let me So let me just bring that one up so you see exactly what it looks like.
There you go. So this is what it's going to look like.
You know, once you create this web
10:15
unlocker or the API, it's going to look something like this, right? And it's going to give you an API token.
Make sure you uh click on the API token or save that somewhere because then we'll we'll copy it. But essentially all you need is the name.
So you're just going to copy the name here. You're going to come back to your workflow.
You're going
10:31
to go to your uh set node here. Click on add field.
You're going to do the name as zone. And you're going to just paste the value.
Whoops. That's the link.
Um what did I name it? Yeah, you're just going to copy this
10:48
and paste it right here. That's all.
Okay, so that was one. And then also we need to do a URL.
I'm going to actually bring this to the top. There you go.
Yep. And then also we need to have a the Amazon URL here, right?
So the name is going to be URL and then the value. This
11:03
is where you will now um click on that whatever bestseller uh you are in. So for example, if you're in the home and kitchen, all you have to do is just come on the top here, copy this, go back and paste it.
Okay. So if you test step,
11:18
this should output the URL and zone. And so these are the two different things that you need here.
So and as far as the naming, you could just name uh Amazon. It's always good practice to name these Amazon URL and write data
11:37
zone. Okay.
Going to click on rename. All right.
Perfect. So that step is done.
Then our next step is going to be adding the HTTP request node to be able to send this information to our bright data and scrape that particular URL. So
11:52
I'm going to go ahead and look for HTTP request. I'm just going to click on this.
All right. So the method is going to be post because we need to send this request to um our bright data URL.
The URL is going to be if I go to my school
12:08
here, I have it right here. Bright data URL.
So, you're just going to copy this and paste it over there. And again, if you're again part not part of the uh school community, all you have to do is just go to api.brightdata.com/ request, right?
Because we need to send a request there. Uh authentication,
12:24
we're going to leave it as generic credential types. The O is going to be heather and then let me go ahead inside here.
So what you're going to do is cuz I've already created one but you're going to click on new credentials and uh you're going to put the name and the
12:40
value. So the name is going to be authorization and then the value is going to be bearer and then your API token.
How do you get that? Once you create that API or this kind of uh scraper my web unlocker this will give you the API token.
And as you can see right here on the right hand side it
12:56
says authorization bearer and then this is your API token. Obviously, I'm going to remove my API token.
So, don't worry about copying this. But make sure you save your API token somewhere safe.
So, authorization and then um uh same thing bearer and so authorization
13:14
and then you're going to do bearer bearer. It's uh good to actually switch to expressions so you see what you're typing.
Bear space and then you'll paste your API token. Okay?
And you're going to save it. So, name it something like O token or something like that.
Click on save. Once you do uh since I've already
13:30
done that, I've just had it as header or account, right? Like very simple, but feel free to rename it whatever you want.
So another thing is we're going to leave the query parameters and headers as blank. We're going to send body.
So as far as the body, we're going to send two things. We're going to send zone.
13:48
Okay. And then the zone that we're going to grab is from the left hand side here.
So if we come right here, this my web unlocker. So, I'm just going to grab this.
And then we're going to add another parameter. And this is going to be the URL.
And
14:05
this is the URL that we need to paste here. That's going to scrape that particular one.
Okay. All right.
So, that's good. And then one more thing we need to send is it format raw.
That's what it is. It's called format.
You're going to type format
14:22
and the value is going to be raw. Okay.
Perfect. So, that's all you need.
And if you did everything right, this should allow you to scrape uh and get some information from this particular URL. So, let's go ahead and click on test step.
And hopefully this will work.
14:39
Executing note. And there you go.
Perfect. So, now you get a bunch of data here.
So, if you click on JSON here, you'll see you get a ton of data right here. And it's a bunch of gibberish.
Obviously, it doesn't make any sense because it's essentially grabbing all of the page content. But in order to make
14:55
sense of this, you need to now add additional notes so that way we can uh grab the data that we need. Right?
So, but let's go ahead and move what did I name this? All right.
I'm just going to copy these to be honest cuz I'm too lazy right now. Copy.
Go back.
15:13
Paste. Boom.
Right. And then, of course, make sure you name this as well.
So, as you can see right here, I have this um named as what did I name it as? Amazon bestseller products and then Amazon URLs and bright data.
But feel free to change this to whatever you want. All right.
So
15:30
afterwards, the next thing is extracting the top 10 Amazon bestsellers. So what we need to do here is we need to add a code note because we need to grab this the information that's relevant because we saw it's sending us all of this nonsense.
So we need to add like a code
15:45
node. We're not again you can use chat GPT here or cloud to generate a code or if you're in the cloud account you can literally just uh click on ask AI and it tell it hey generate a JavaScript code for me to grab you know the a sample data from this side so that way I can
16:01
process it for next and play around with with this but I've generated the code already so if I go to the community here and scroll to the bottom is this one right here. So I'm just going to copy this and come here and paste it.
Again, this is very simple. Uh I just use chat GPT,
16:18
but feel free to uh you know, play around with this. So, what this is going to do is just gives grab a sample HTML here.
So, that way we can send it to the next one. So, if I click on test step now, this should just grab that information, at least a chunk of it.
There you go. So, it kind of uh
16:34
generated this thing called partial HTML, which is going to be a sample of what's coming in from here. Okay.
So, that's good. Now, the next step is we need to add our extractor note, right?
So, I'm just going to go ahead and search for extractor information extractor. And this is an openi node.
16:50
The text here is going to be this partial HTML that we're going to just drag and drop. So, I'm going to bring it over here.
There you go. Perfect.
So, now the schema type we're going to divi define a schema. And again, I'm using chat GPT here just so uh you know I make
17:06
sense of this data that's coming in. Right?
If you were to grab this entire data, then this will be too much for AI to process. So therefore, you have to add this code node to get a sample of that data.
So that way you can process the rest. So let's go ahead and so I'm just going to go over to my community.
Same thing. Structure data structure uh
17:22
output or input schema. I'm just going to copy this.
Come back here and paste it. You know, feel free to play around with AI to come up with whatever uh you think you're trying to grab, whatever piece of information.
I'm just grabbing the top 10 from uh this particular
17:39
jargon or mess that the mess of a day that's coming in from the left hand side. Okay.
You can also add a system prompt. So if you click on app options, this will uh if you're doing something particular, you could add a system prompt, but I'm just going to leave it as it is.
All right. So we're good to go there.
I'm just going to click on test step here. And now what this is going to
17:55
do is this is going to take this data from the left hand side and summarize it and grab the relevant information. All right, let's see a model sub node.
And oh yeah, well I forgot to add a API or a chat model here. So you're going to click on model because obviously you need to add a chat model here.
So I'm
18:10
just going to grab my open AI here, but feel free to, you know, grab whatever you want. I'm going to use uh GPT4.1 mini cuz I've seen that that has worked better before, but feel free to grab whatever you want here.
So I'm just going to go ahead and test this step. Hopefully this will work now.
So what
18:26
this is going to do again utilize this schema based on this schema. It's going to grab or extract the information from this output of this previous node that came in through.
This is going to take a couple of seconds because obviously there's a lot of data that's being processed. So that's why it's going to
18:42
take a couple of seconds depending on which model you're using, right? So, and play around with different models.
I mean, if you're using like 4.1, like you can use nano because that's the fastest one and then go to mini. But if you see that you're not getting the relevant data, use a bigger model from OpenAI or even Antropic or something like that,
18:58
right? But in the meantime, let's go ahead and I'm just going to copy this little note here so that way I don't have to do that work while this is getting processed.
There you go. Perfect.
All right. So, it finished.
Let's go ahead and see what the data looks like. There you go.
Perfect. If I
19:15
click on schema now, it extracted like uh the top 10 products. As you can see right here, the top 10 products.
So, output 8 9 1 2 3 4 all of that stuff. And we have title, stars, total ratings, offer, product URL, and image URL.
And
19:30
that's coming in based on this um schema that we defined here. If you want to add additional or if you want to grab additional parameters, make sure you change the schema here.
Okay. All right.
Cool. So that's good to go.
Now, let's go ahead and uh create our third step, which was the output. What you need to
19:45
do is add a split node here because you can see this is outputting all of this data. It's almost like list items.
What we need to do is split this data into individual rows essentially or individual item outputs. So that way we can then add this to our Google sheet.
20:00
So what I'm going to do is I'm going to click on this and just search for split. So you're just going to do split out.
And what you need to do is just grab the output from here. And that's all you need, right?
So just going to click test step. And this is going to output this
20:16
into a absorbable uh table almost. So as you can see it has all these tables the tables with the same uh column names and then all these different rows right so that's that's why this is very important because if you put this directly connect this to the Google sheet it's not going
20:31
to work properly. So just go ahead and add the split item and as you can see one item came out from this output and 10 items came out from this and that's exactly what we need.
So the next step is we need to add our Google sheet. So if I search for Google sheets here, Google Sheets and you're going to do
20:47
append or update a row in a sheet. Right?
So you're going to attach your Google sheet credentials. Very simple to do.
Follow my other videos if you don't know how to do that. Very very simple.
Resource is going to be sheet within document. Operation is going to be append or update row from list.
If you connected your Google sheet properly,
21:04
this will this should load all of the list there. I've named this one bestselling products.
So that's what I'm going to do. So, I'm just going to grab bestselling products, and this is going to load the sheet inside.
I only have one sheet, so I'm just going to select sheet one. This is going to load all of the columns
21:19
that are there for column to match on. I'm just going to use ranking because this that's the first column right there.
And now, all you have to do is just literally drag and drop. Make sure you're dragging your uh the from the split out here.
So, not from the information structure. So, you're just
21:36
going to literally drag and drop. Very simple.
stars, total ratings, offer. And the reason why this uh columns is matching already is because like I said, I used that little um an image.
Um I
21:54
used this exact template right here. So all you have to do is click on this template.
It'll bring you to the exact template right here. And what this is going to do, oh, this is zoomed in a lot.
So this is going to just automatically bring in these columns which uh match
22:11
your workflow here. Okay.
So as you can see right now there's no data there. So now if I test this step this should upload that data there.
So let me go ahead and click on test step. So now this should grab all of this data that's coming in and output into our Google sheet in a really nice formatted way.
22:27
Perfect. Looks like it worked.
And if I go back to my Google sheet you can see every Oops, didn't mean to do that. You can see that the top ranked products are out here with the stars for each one, total ratings, the offer.
Offer is basically price. So if you want to change the uh the name of that column,
22:44
feel free to change it to price. Most importantly, the product URL.
So if I click on this product, you can see it will direct me to that product, which the number one seller is obviously this liquid ant baits. And if I go to the Amazon best products, you can see the number one is this liquid ant baits.
So,
23:00
for example, the third one, let's say Stanley Quincher H2O H2O something. That's the third one.
Yep. Absolutely.
Right. So, it looks like it grabbed everything correctly.
If I click on this, it should bring me to that particular product right here, which is this Stanley water bottle thing, right?
23:15
So, for example, uh the stars is 4.7, the reviews is 15 to 5,000. So this is like a um you know the ratings and everything the stars will be brought over and like as you can see right here this is 55,93 total ratings which is exactly what
23:32
matches on our product right here 55,92 ratings. Okay, cool.
So that's kind of like the um the Google sheet here. So now you can schedule this and on a daily basis this will update all the top 10 ranked products.
Next up, what we could
23:48
do, this is optional. You don't have to do this, but you can also add a open AI node here that gives you a summary that it can send to your Slack channel.
This could send be sent to your email or it could be sent to other some other whatever communication form you have.
24:03
Right? So, I'm just going to message a model here and I'm going to go to my community here cuz I just have the right here.
So, I'm just going to copy this. This is, by the way, a very simple prompt.
Feel free to change that if you want. So, I'm just going to do just grab
24:18
a model uh nano. I'm just going to grab the nano here.
Prompt. I'm just going to paste this.
So, what this is going to do is just essentially grab the top 10 products here and summarize it and give you a Slack message or something like that. And you can add like your Slack,
24:35
you know, very simple. um and select a channel that you want to send or you can send it to a message or message it directly to a user or like I said you can add a email here right a Gmail here that this is going to send you an email on a daily basis uh with the top 10 best
24:51
products right so very simple but I kind of like this Google sheet because it's very very easy for me to read because it has all of the different data but like I said if you want to do a sample for your Slack or something like that this is what it will look like there too okay so that's what uh this scraper does it
25:07
essentially grabs depending on which product or which Amazon bestseller you're looking for, which industry you're looking for. All you have to do is now go ahead and change.
So, now if I go and let's say we want to utilize um bestseller in clothing, right? So, if I
25:23
go to here, all you have to do is just copy the URL. Now, we're going to go back to the workflow.
The only thing you need to change is the URL right here. Paste.
And you can just let me just delete this one cuz I don't need it.
25:39
So now let's get rid of this. And this time if I test workflow.
So this should grab the top send top selling best products for uh the
25:54
clothing right here. Right.
And let's go ahead and test that step. Test workflow.
So same thing. It's going to grab the URL send that information to the bright data.
It's going to summarize that. It should grab the information that's coming in from our uh information
26:10
extractor, split it out, send it a nice little table format, and then update our Google sheet here. So, this should be updated now with all of the information about uh where' it go?
Oh my god. Oh, this one.
Yeah. So, it
26:25
should be this Crocs, uh men's crew t-shirts, and then these other stuff as well. So, let's go ahead and see if this thing worked.
There you go. Perfect.
So, that worked. Let's go and take a look at our There you go.
Perfect. So, see first one.
This Crocs unisex auto classic clog guide
26:42
men's crew t-shirt multiack styled whatever cohort men's loose fit heavyweight short sleeve nippies nipple covers for women. So, um it looks like it worked, right?
Crocs, shirts, nippies, nipple uh nipple cover for women. All right.
So, looks like
26:58
everything worked. You can now use this for any other department depending on what your use case is.
Again, all you have to do is just change the URL inside uh our uh bright data right here. All right, so hopefully that made sense.
Hopefully you found this video helpful. Uh please make sure you like and subscribe because I've got some amazing
27:14
things that are coming up in the pipeline that you don't want to miss. Thanks for watching and I'll see you in the next one.