Use the N8n to make automatic content pruning systems (connect GSC and CMS)

"The web is cluttered like a storage room." The problem that SEO and the web owner must meet.

Have you ever felt like this? You try to create good content. Coming out regularly, after 2-3 years, turn back and watch again ... Your website becomes like "Storage room" that is full of hundreds of thousands of articles Some pieces used to be stars. But now, no one can see, no one can click, just take a living on the server and compete for "Crawl Budget" from Google every day.

To sit and chase the performance of all pages on the Google Search Console (GSC) by themselves. URL is a boring job, repeated and enormous time. When starting to do it, I feel discouraged everywhere. Finally, let the content that are not effective. (Underperforming Content) keep accumulating. Until it became a big problem that was invisible

- Prompt for illustrations: Compare graphics One website looks orderly. There are a few quality articles. With the other side that looks messy Full of old articles With a spider Along with the image of a headache with management -

Why does our website have "Garbage content" accumulated without knowing?

This problem is not caused by laziness. But it is caused by the nature of long -term content. The main cause is due to the "Content Decay" or "content deterioration" over time. Information in the old article may be outdated, does not meet the needs of the user anymore, or with competitors that make content better than replaced. Resulting in a good content that has been gradually has a continuous traffic Understanding Content Decay and solutions are the first step in maintaining the health of the website.

When combined with the Manual Process, consisting of exports from GSC, put in Spreadsheet, Filter settings, then gradually analyze one row. It is almost impossible to do it regularly and precisely. Especially with websites that have enormous content, this is a "blind spot" that causes inferior content to be left without anyone taking care.

-Prompt for illustrations: Infographic images, simple, showing the content of content decay, starting with Publish -> Peak Traffic -> GRADUALLINING TRAFFIC -> Bece UnderPerforming Content and a watteria to convey the time. -

Continue releasing the website ... only a serious disadvantage "Wasting space"

Having an ineffective content on the website is not just a small matter. But it has a direct negative effect on SEO and more intense than expected. If left You may have to encounter these things:

• Waste of crawl budget. Yes. Cause: Googlebot has a limited quota to collect data on our website. Letting it waste time with the "garbage" page that will never be ranked. Make new faces Or more important functions
• The Authority of the website is discounted (Diluted Authority): websites that only have many low quality content. Will make the overall image of the web in the eyes of Google look inferior, resulting in a good face Other pages, Ploy, rank.
• Bad user experience (User Experience): User may come to find old or outdated information anymore. Causing them to press out of the web immediately (Bounce Rate) and will not come back again
• Point out achievement: having a lot of pages that do not perform well, will make the averages such as CTR or Average Position look lower than reality. Makes us incorrectly analyzed the overall image of the website

Therefore, making content pruning or content cutting Regularly is not a "alternative" but the "duty" of the SEO who needs the best results in the long run.

- Prompt for illustrations: Googlebot cartoon images are tired while trying to crawl through the web with old pages. And have new pages That is bright, waiting for the queue far away but not to -

The solution is "automatic system" - let Robot work for us with N8n.

Would it be better if we were able to create a "AI assistant" that works for us 24 hours a day? The assistant who will wait to draw information from the Google Search Console, analyze according to the conditions that we have set, then the names of the name are ineffectively sent directly to us. at the Automation tool called n8n.io.

N8n (read as N-AT-N) is Workflow Automation Tool that is like "Lego for marketers" that allows us to connect various services to create complex automatic systems without having to write code. We can create a workflow that works in this step:

1. Set the working hours (schedule): order the system to work every month
2. Draw data (FETCH DATA): connected to the Google Search Console API to draw the Performance data of all URLs in the last 6-12 months.
3. Analyze & Filter: Filter to find a duty with Impressions or Clicks below the criteria that we specify (such as impressions <100 in 180 days).
4. Notify or order (Notify & ACT): Send a URL list that has passed the conditions to Slack for the inspection team. Or even order CMS to create a draft to wait for prune (Redirect or Delete).

This is a boring Manual job to become a perfect automatic system.

-Prompt for illustrations: Infographic shows a simple N8n workflow workflow starting with the SCHEDULE -> GSC -> Filter/Funnel -> Slack and CMS icon -

Case Study: From 8 hours a month, leaving 0 with N8n Content Pruning Workflow.

To clearly see the image I would like to give a real example of "website B", which is a website that has more than 800 articles accumulated. The team has spent 8 hours every month. "In making content pruning by hand, which is a process that is both tired and no one wants to do.

Problems received: Create a system that can identify the "Zombies" (very little Impressions) and "UnderperForming" page (good duty, but now the amount automatically falls) and send a report to the SEO team every day 1 of the month.

How to solve the problem with N8n: We have created automatic workflow on N8N with the following steps.

• Trigger: Set time to run every day 1 at 9.00 hrs.
• Get GSC Data: Use GSC Node to retrieve the 6 months of all URL by pulling the Impressions, Clicks, and CTR.
• Filter Zombies: Use IF Node only URL filter with Impressions less than 100 in the past 6 months.
• Filter Underperforming: Filter the remaining URL by finding a duty to have high clicks, but the latest 3 months. Clicks agreed more than 70%.
• Format & Notify: Collecting the list of URLs, both groups arrange the text and send to Channel #SEO-ALERT in the Slack with a button to press to open in GSC immediately.

Results:

• Save working time: Reduce the time from 8 hours/month to 0 hours (the team takes only 15 minutes to see Report and decide)
• 100%accuracy: No dust or Human Error anymore.
• Find opportunities: in the first run The system can list the zombies page up to 124 pages and 47 UnderperForming pages, which are information that the team has never seen before. And lead to the Website Renovation that adds 30% of the Organic Traffic in 3 months later.

- Prompt for illustrations: Before & After comparing the calendar of the team on the left (BEFORE) has a full 1 day blog for "Content Audit" with a tired person's face (AFTER). The empty calendar has only notification bounced in the mobile phone. With a smiling face -

Create this system by yourself: Checklist for N8n Content Pruning Workflow

Read here If wanting to try to follow Not difficult at all! This is the checklist and the guidelines that you can apply to create your own workflow immediately:

Step 1: Preparation

• Install N8n (Self-Host or Cloud)
• Create Credenials for Google Search Console API in N8n by following the OAUTH2 steps.
• (Alternative) Prepare your Slack or CMS (such as WordPress, Webflow)

Step 2: Create workflow on N8n (Workflow Building).

1. Schedule trigger: Start with the Node "schedule" and set to run according to the desired frequency (such as '0 9 1 * *' for every 1 in the morning)
2. Google Search Console Node: Add Node "Google Search Console". Select Operation as 'Query` Specify Site URL and set the Dimension as `Page' and Date Range to 180 days.
3. IF Node (or Filter): Add Node "IF" to filter information according to your conditions, such as `{{$ JSON [" Impressions "]}} <100` This is where you can put more complex logic. And having knowledge about using Python for SEO will help you adjust this part a variety.
4. Slack Node (or Email/CMS Node): Node "Slack" to the "True" legs of the previous IF Node, then compiled the message by pulling the filter URL to display, such as {{$ Items (). Length}}.

Step 3: Test & Activate

• Click "Execute Workflow" to test the work. Check whether the information and the messages are correct or not.
• When everything is done, press "Activate" to enable the workflow to start acting as set.

Just this, you have your own intent pruning system! If interested, see more examples Take a look at the article about Examples of Marketing Automation with N8N to be extended.

- Prompt for illustrations: N8n's UI screen showing workflow as described in the article. There are clear connections between various node -

Common questions (FAQ) about Content Pruning with N8N

I have compiled a question that many people wondered about creating this system. With a clear answer

Q1: Do you have to write a code to use N8n?
A: For this fundamental workflow Almost do not have to write the code. N8n's UI is a drag-place. (Drag -and-Drop) and easily set up in each Node, but if you want to logic more complex, such as comparing data between two times, knowing Javascript or Python will help unlock enormous ability.

Q2: Is connected to the Google Search Console API?
A: Not complicated. N8n has a Creadenials management system for Google (OAUTH2) that is quite straightforward. Just follow the Step on the N8n website. You will have to enable the API on the Google Cloud Console and bring a lot of Client ID/Secret, which is only the first time.

Q3: What criteria should be used to make prune decisions?
A: No fixed rules. Depends on the type of your website But the good starting point is:

• Impressions are very low: such as less than 50-100 times in 6 months (for non-important pages)
• No clicks at all: Even if there is an impressions, if no one clicks at all in 1 year, it may be a bad sign.
• Abnormal CTR: For high impressions, but very low CTR may have to consider improving. (Update/Improve) instead of deleting
• Content does not create conversion: for a clear target But cannot create a conversion at all

Q4: In addition to the notification on Slack, what else can you do?
A: You can do almost everything you think! For example, send an email name, add task to Asana/Trello/Jira, create Google Sheet with all the information, or even shoot your api to the CMS to change those articles to "Draft" automatically to wait for the final check.

- Prompt for illustrations: Large question icon image Surrounded by N8n, GSC, Slack icons, and data graphs. To convey the solution -

Summary: Change work that no one wants to do. To be an advantage with Automation

Content pruning is not just "deleting" but "care for the garden" on your website. Cut out dead branches Will help the nutrients (Crawl Budget & Authority) to be sent to nourish strong branches and new fruit flowers Fully Make your garden grow in the long run.

Using tools like N8N to create an automatic system Is to change the boring job, repeatedly and take time to become a genius system that works for you without tiring It is the use of technology to create competitive advantage. Help your team have more time to focus on work that requires more creativity and strategies.

Do not let your website hell anymore! Try using the checklist and the concept in this article to use. I guarantee that it will change your SEO work forever.

If you see the power of Automation, but it feels too complicated. Or need experts to place a strong system and customize to your business, especially the Vision X Brain N8n Automation , ready to provide a workflow to help you with your business!

- Prompt for illustrations: Powerful graphics Showing people standing on the top of the hill Looking at your own website, now looks like a beautiful garden, has a sun shining down. Conveying success and bright future -

‍