n8n templatesn8n templates

Automated Content SEO Audit Report

This workflow automatically generates comprehensive content SEO audit reports by integrating web scraping and search data analysis. It efficiently identifies SEO issues on the website, including page status, content quality, and link structure, and provides specific optimization suggestions and priorities. Users can customize the report style according to brand needs and export it in HTML format for easy sharing and archiving, helping to improve the SEO health of the website and save labor costs.

Workflow Diagram
Automated Content SEO Audit Report Workflow diagram

Workflow Name

Automated Content SEO Audit Report

Key Features and Highlights

This workflow integrates DataForSEO’s web crawling and analysis APIs with Google Search Console (GSC) data to automatically generate a comprehensive content SEO audit report for a specified website. The report covers multiple dimensions including page crawl status, content quality, metadata SEO, internal linking structure, and performance metrics. It provides detailed issue identification along with prioritized recommendations. The final report can be customized with user-defined brand colors and logos, and supports export in HTML format for easy sharing and archiving.

Core Problems Addressed

  • Automates large-scale (up to 1000 pages) detection of content and technical SEO issues, eliminating manual labor and reducing the risk of oversight.
  • Combines Google Search Console data to accurately identify underperforming content pages.
  • Offers specific optimization suggestions with priority levels to help websites quickly and effectively improve SEO health.
  • Resolves common SEO pain points such as 404 errors, redirect issues, missing/duplicate metadata, outdated content, poor readability, and missing internal links.

Use Cases

  • SEO professionals or digital marketing teams conducting regular website content and technical health checks.
  • Website operators needing quick insights into SEO status and improvement plans.
  • Digital agencies providing customized SEO audit reports for clients.
  • Content strategists analyzing content performance to adjust optimization directions.

Main Workflow Steps

  1. Initialization Settings: Users input target website domain, brand information, Google Search Console property type, etc., in the “Set Fields” node.
  2. Create Crawl Task: Invoke DataForSEO API to start website page crawling and SEO data collection.
  3. Check Task Status: Poll the crawl task status in a loop until completion.
  4. Retrieve Raw Audit Data: Fetch detailed page data from crawl results.
  5. Extract Valid URLs: Filter pages with HTTP status code 200.
  6. Batch Call GSC API: Query last 90 days’ clicks and impressions data for each page.
  7. Data Merging: Combine GSC metrics with crawled SEO data to build a complete page dataset.
  8. Extract 404 and 301 Status Pages: Identify these pages and retrieve their source links.
  9. Build Report Structure: Analyze and summarize SEO issue categories and counts based on all data.
  10. Generate HTML Report: Create a fully branded audit report with charts and detailed issue lists.
  11. Export Report File: Produce a downloadable HTML format report.

Systems and Services Involved

  • DataForSEO API: Enables website page crawling, SEO metric analysis, and link data collection.
  • Google Search Console API: Provides page-level clicks, impressions, and search performance data.
  • n8n Automation Platform: Orchestrates workflow nodes, controls process logic, and handles data processing.
  • HTTP Basic Auth: Used for authenticating DataForSEO API access.
  • Google OAuth2: Secures access to Google Search Console data.

Target Users and Value

  • SEO Consultants and Analysts: Enhance audit efficiency and deliver high-quality reports rapidly.
  • Digital Marketing Teams: Gain comprehensive control over website SEO health and formulate data-driven optimization plans.
  • Website Operators and Content Managers: Understand content performance and identify/fix SEO issues.
  • Agencies and Service Providers: Offer clients customized, branded SEO audit services.
  • Technical Professionals and Automation Enthusiasts: Learn API integration and automated report generation best practices.

By automatically crawling website content and integrating search data, this workflow intelligently identifies multidimensional SEO issues, significantly saving manual effort while producing visually appealing and practical brand-customized reports. It empowers continuous website optimization and improved search engine rankings.