How Jesse Cunningham Builds an SEO Agent with n8n

0:00This is the new n8n workflow that parses right into a Google Sheet. And instead of using expensive tools like Ahrefs and SEMrush, we can use this new workflow and stop paying to $300 a month, right? This is going to allow anyone to use data. We need data to win, right? So what we're going to do, I'm going to scroll in here. Do you see this? We're using an API, Data for SEO API. So this is the foundational situation, right? We do need to pull an API. If we're getting too complicated right now in the video, that's okay. It's very, very simple. So if you look at a lot of workflows,

0:32they're very complicated, but this one has four processes. Number one, we have the domain rank overview. Number two, coming down here, we're going to grab relevant pages. Number three, we're going to get ranked keywords performance, and then we're going to get competitor visibility overview. And what it looks like, it just pushes to a Google Sheet. We like using Google Sheets because we have a lot of different workflows that we use, right? So if we come over here into the Rank Expand Academy, you'll see here to the left, we use a lot of SEO workflows. We like using Google Sheets because

1:00we just do the same process over and over. So what it's going to do off the bat, let's just start at the start, right? So it's going to give us good information. So right here, do you see this? I'm going to scroll in. If I can scroll in right here, that's a bit too much. All right, we're going to scroll in right here. Organic ETV. So estimated organic monthly traffic to the domain is 1.5 million searches, and this is the safe home. So how I got this website was, type in home security system, and we're going to scroll past the AI overview, which is a beast unto itself, right?

1:29A lot of people are having a hard time ranking here in the AI overview. That's a tangent, but you can see they are ranking right here to the right. And on top of that, if I keep coming down past the sponsored results, do you see sponsored here? So people are paying for this. We come to the first organic result, and they are crushing it. So basically, let's pretend that we want to rank in this very, you know, lucrative niche. What are we going to do? Well, I need to learn about savehome.org. One option is to come over to Ahrefs and learn about them here, but this costs

1:56$200, $300 a month. Is it powerful? Is it good? Yes, I like it. I still use it, but there's a lot of people out there who don't have access to this. Well, now you do have access to something that's comparable, right? And this is the end-to-end workflow. Now, something you're going to have to get used to is it does not have a pretty user interface. In other words, you can pay extra dollars to get over here and look at all these pretty charts. You know, that's great. But if you just want raw data, this is what you're going to have to deal with. It's a Google sheet,

2:22but it's still raw data. I mean, you just need the data, right? So what I like is this is step two in the process is domain relevant page. So what this does, it parses out kind of the best pages of this website. Is this hard to do without APIs? Absolutely. It's almost impossible to get your competitors best pages. It's very hard to see accurately. Now you can do it. So we can sort different things. We can see, okay, here's the organic for this specific page. This one right here is the one that we just were doing, right? This is the one that shows up on Google right

2:51here. Do you see it? Security systems slash best. So what you want to do off the bat, okay, now that we have identified their best page is look at their slug structure at the top. I'm going to scroll in security dash systems best. So you should learn from that. You should learn from their own page. And these guys make a lot of money by people coming on here. Okay. ADT is the best. So they say, do you sale? Boom. If someone clicks one of these buttons right here, they're making money off of affiliate sales or something else, but you know, rest assured they are making money. So this allows

3:19us to get all their pages here, right? We have, I don't know, a hundred, yeah, a hundred of pools, the hundred best pages organically. In other words, these are the best pages on the website that pull Google traffic, not paid traffic, Google traffic. And what you can do coming to the right, you can see, okay, here's the organic position number one. So number of organic SERPs where the page ranks number one. In other words, when someone types into Google a specific query, like we did up here, home security system, this page shows up number one. And this page, the one that we were just

3:50looking at shows up for 486 different searches. That page right there is the money page of their website. And we quickly identified it because we'll just look, we can see which one has the most number one positions. We'll see this one right here, 178 has a lot too. So let's come in here. We're going to click this, then all of a sudden we're digging into their website we're learning.

4:10So here's no subscription, smart doorbell comparison and recommendations. Do you think they make a lot of money here? Absolutely. So without an API, without data, you are kind of just walking in the dark. You need tools like this right here, which are very, very easy to use. I'm going to show you how to use it so that you can identify where to actually compete.

4:31Now take it a little tangent for a second. This is a case study, which I'll link in the description from Stuck to $6 million. One of our clients, we were able to boost them, right? We were able to boost their organic SEO big time. And this is a big, big case study. I mean, it goes on and on. Like I'll scroll down quickly here. You'll see there's graphs.

4:47This is real data, like real data for their leads, their revenues, it goes on. But the point is, how do people, how do SEOs, how do marketers boost a website's traffic? And it's based on what I'm showing you here. You have to be able to and be comfortable with going into data like this and just sit in here for a second and kind of just learning and understanding and going to their website and being like, man, I like how they formatted here. I wonder if there's a reason why their H2s, their headings, their headers are like this. That is what it's all about, right?

5:17You're going to learn how do they internally link, read more, wise home security camera review, and all of a sudden you're realizing every portion here is for a purpose. The people who are able to move the needle for websites and do things like this, huge growth, are those who can take data, right? And the N8N workflow has even better stuff, I think, but you're able to take data and use it for your advantage, right? So the third tab, and you'll see at the bottom here, we have one, two, three, four tabs, which coincide with the one, two, three, four portions of this

5:47N8N workflow. The next one is ranked keywords performance, which is going to extract a list of domains, top ranking keywords in the performance data. So let's come over here. Let's take a look. So now all of a sudden, and this used to be, you know, only Ahrefs and SEMrush could do this well, now we can do it very, very easily. So we have all these keywords and we have search volumes associated with them. So this one right here, Alarm Security Systems has this much potential search volume and we can see it is transactional or informational or commercial. You can see

6:19informational is down here, okay? It has less traffic. They're really going after transactional stuff right here. Basically, this website is purpose to make money, which makes a lot of sense. If you have an affiliate or an e-com website, informational content is no longer the best thing to write, which is, you know, a whole different video we could talk about because if we come up here, we scroll back up, the AI overview will eat your lunch largely on informational content. Now, will there be people who are going to research a bit more and go down the rabbit hole and click through to sponsored ads and, you know, this, that and another? Of course,

6:54but you have to be very careful. And I know this is a tangent to just do stuff like this, informational, because if it's all informational content, then you're not going to make it. You're just feeding the AI system, which is eventually just going to regurgitate what you already built. Now to keep it rolling, which I think is potentially the most powerful part of this tool is competitor visibility overview. And I'm going to get into that in a second. It identifies competitor domains. I love it. This used to be very hard to do without tools like this, but now we have it. And this costs a fraction, you know, a true fraction of a fraction of what

7:28Ahrefs and these other tools cost. You do pay per run. So instead of paying like a flat monthly fee for Ahrefs or Sendrush, which are still great tools, you pay per use because you're just pulling API data. But before I go on, I want to invite you, listen, this is the Rank Expand Academy. If we come over here to classroom, you're going to see a lot of opportunity for you to make your first $1,000 using AI online. There's different paths, right? There's different things you can do.

7:54This one right here is popular, 90 days to freedom using AI. You can build a mini agency quickly. Someone recently got in a commitment of around $100,000 for their mini agency they built in here for this year. It's very, very good. Scale and Microsites is also very popular. But if we come over here to AI tools and workflows, this is where all the N8N workflows live. And I think we have created in the hopper about 30 of them. So we're just getting started here. So if you haven't already joined the Rank Expand Academy, I'm in there daily. I look forward to seeing you. Now

8:24moving back here to the final portion of this N8N workflow is the competitor visibility overview. This is what it looks like. So we typed in savehome.org as the website that we wanted to check on, right? And now we get all the other websites that may be associated with them based upon what they are actually writing. Now this is a certain niche that the big dogs do write about, which makes it so, so competitive because listen, this specific niche about home security has recurring monies.

8:52In other words, if you sell this product as an affiliate, you may get recurring revenue, which is huge, huge, huge, huge, right? You can make tons of money. That's why you're going to see places like New York Times writing about it or places like US News or Consumer Reports, but you're going to see big dogs. But the point is with this final portion of the tool, you can, you can get all your competitors domains. And all of a sudden you have like magnification on who you are competing against. Therefore you can just run the process over again.

9:20So what I would do is I would find some domains that I didn't really know were my competitors and I would push them here instead of running just this one, savehome.org, I'd run 10 of them and I'd start digging to understand what do they do well? What are they ranking for? I'd find low DR or low authority websites and figure out what their best pages are, right? Just as we did here, you just rinse and repeat. You have everything you need here to dominate. So what I would do, I'll come over here to whatever one I parse, whatever website I parse

9:48and I'll find what is their best URLs, right? Organic position number one, this one here, we already identified, we did this one too. This one has 109. So I'll highlight this row and I'll say to myself, oh, I know this one right here. This URL makes them a lot of money and is the most affordable security systems in 2026, all under $400. That probably right there is super important. They do this for a reason. Remember, if you are identifying the top dog in a niche, the top website with the most organic traffic, you should consider emulating how they write.

10:21There's a reason they do this. There's a reason they have Rob here as the managing editor and home security expert by lines up here with his credentials, his Twitter, his Facebook, etc. There's a reason. So what you can do, come in full circle with this tool here, you're able to just get magnification and clarity on your competitors and maybe even your own website to learn so you can boost your traffic.