Content SEO Audit Report Generator | n8n Workflow Template

Content SEO Audit Report Generator n8n Template

This powerful n8n workflow creates comprehensive content audit reports for websites by combining DataForSEO's crawling capabilities with Google Search Console performance metrics. The result is a beautifully formatted HTML report customized with your brand colors that identifies technical SEO issues, content quality problems, and provides actionable recommendations for improvement.

How It Works

1. The workflow begins by setting configuration variables including the target domain, company branding details, and crawl parameters.
2. It initiates a website crawl through the DataForSEO API, with options to set the maximum number of pages (up to 1000) and JavaScript rendering settings.
3. The workflow periodically checks the crawl status until completion, then retrieves the full audit data.
4. For each valid URL discovered, the workflow queries the Google Search Console API to retrieve performance metrics (clicks and impressions).
5. The system identifies problematic URLs (404 errors, redirects) and retrieves information about internal links pointing to these pages.
6. A comprehensive analysis is performed to identify issues across multiple categories:
   • Technical SEO: 404 errors, redirect chains, canonicalization issues
   • Content quality: thin content, outdated information, readability problems
   • On-page SEO: title/description issues, missing metadata, H1 problems
   • Internal linking: orphan pages, excessive click depth, insufficient internal links
   • Performance: underperforming pages based on GSC metrics
7. The workflow generates a professionally designed HTML report with your company branding that includes:
   • Executive summary with health score and key recommendations
   • Detailed issue breakdowns by category
   • Actionable recommendations with priority levels
   • Complete page-by-page analysis

Benefits

• Eliminates the need for multiple SEO tools by combining technical crawling and performance data
• Saves hours of manual analysis with automated issue detection and categorization
• Provides client-ready reports with professional branding and actionable recommendations
• Identifies critical SEO issues that impact search visibility and user experience
• Helps prioritize content improvements based on actual performance data
• Creates a comprehensive inventory of all website content with associated issues
• Delivers specific, actionable recommendations for each identified problem

Requirements

• DataForSEO API credentials (Basic Auth)
• Google Search Console API access (OAuth2)
• Website with Google Search Console property configured
• n8n instance with access to both APIs

Setup Instructions

1. Import this workflow into your n8n instance.
2. Create a new "Basic Auth" credential for DataForSEO by following the n8n HTTP Request credential guide. You can get your DataForSEO API credentials from your DataForSEO dashboard.
3. Assign your DataForSEO credential to the "Create Task", "Check Task Status", "Get RAW Audit Data", and "Get Source URLs Data" nodes.
4. Create a "Google OAuth2 API" credential following the n8n Google OAuth guide and assign it to the "Query GSC API" node.
5. Update the "Set Fields" node with your specific information:
   • dfs_domain: The website domain you want to audit
   • dfs_max_crawl_pages: Maximum number of pages to crawl (default: 1000)
   • dfs_enable_javascript: Whether to enable JavaScript rendering (default: false)
   • company_name: Your company name for the report branding
   • company_website: Your company website URL
   • company_logo_url: URL to your company logo
   • brand_primary_color: Primary brand color in hex format (e.g., #252946)
   • brand_secondary_color: Secondary brand color in hex format (e.g., #0fd393)
   • gsc_property_type: Set to "domain" or "url" depending on your Google Search Console property type
6. Run the workflow by clicking "Start" and wait for it to complete (typically 15-20 minutes for 500 pages).
7. Download the generated HTML report from the "Download Report" node.