Automate SEO Content Audit Reports with n8n & DataForSEO

What this workflow does

This workflow crawls up to 1000 website pages to find SEO problems automatically.

It collects page status codes, meta tag info, and content quality details from DataForSEO’s API.

Then, it fetches real search data like clicks and impressions from Google Search Console for each page.

Combining these data helps to identify broken links, redirects, thin or outdated content, missing tags, and other SEO issues.

Finally, it creates a branded HTML report summing up all findings and recommendations.

Who should use this workflow

This is for SEO consultants and website auditors who spend many hours checking hundreds of pages manually.

It fits people needing faster, accurate SEO audits with clear, client-ready reports.

Users with websites up to 1000 pages and access to DataForSEO and Google Search Console can apply it well.

Tools and services used

• DataForSEO API: Crawls site pages to gather SEO data like status codes and meta tags.
• Google Search Console API: Provides search analytics with clicks and impressions for each URL.
• n8n automation platform: Runs the workflow, connects API calls, processes data, and generates the report.

Inputs, processing steps, and output

Inputs

• Target domain name (up to 1000 pages)
• DataForSEO account credentials (Basic Auth)
• Google Search Console OAuth2 credentials
• Brand details: company name, logo URL, and brand colors (optional)

Processing steps

• Send request to DataForSEO to start crawling the site.
• Wait and regularly check task status until crawl completes.
• Download raw crawl data including URLs and SEO metrics.
• Filter URLs with HTTP status 200 to focus on active pages.
• Query Google Search Console for clicks and impressions by URL.
• Pause requests to avoid API rate limits.
• Match Google data with crawl results to enrich page info.
• Extract pages with 404 errors or 301 redirects for problem focus.
• Get source links pointing to broken or redirected URLs.
• Analyze all data to detect SEO problems like thin content, missing metadata, or crawl depth issues.
• Create a structured summary and detailed lists of findings.
• Build a branded HTML audit report including summaries, tables, and recommendations.
• Convert the HTML to a downloadable file ready to share with clients.

Output

A fully branded, detailed SEO audit report in HTML format, ready for download and client presentation.

Beginner step-by-step: How to use this workflow in n8n

Import the workflow

1. Download the workflow file using the Download button on this page.
2. In the n8n editor, click “Import from File” and select the downloaded workflow JSON file.

Configure credentials

3. Add your DataForSEO Basic Auth credentials under n8n Settings → Credentials.
4. Set up your Google OAuth2 credentials for Search Console API and add them in n8n Credentials.
5. Assign these credentials to the corresponding HTTP Request nodes in the workflow.

Update workflow inputs

6. Open the Set Fields node.
7. Enter the target domain name in dfs_domain.
8. Adjust max crawl pages or enable JavaScript rendering if needed.
9. Add your company name, website, logo URL, and brand colors to personalize the report.

Test and activate

10. Run the workflow manually inside n8n to check for errors and make sure it runs correctly.
11. If the test run succeeds, set the workflow to active for production use.

Consider scheduling regular runs using a cron trigger (not included) for ongoing SEO audits.

For more control or scaling, consider self-host n8n.

Customization ideas

• Change max crawl pages in Set Fields to audit smaller or larger parts of a site.
• Turn on JavaScript crawling for sites relying on rendered content.
• Modify brand colors and logo URL for personalized reports.
• Adjust batch size in the looping node for Google API requests depending on quota limits.
• Switch Google Search Console property type (domain or URL) to match your setup.

Handling common issues

DataForSEO API authentication failure

Check that Basic Auth credentials are correct and assigned to all DataForSEO HTTP nodes.

Google Search Console API errors or 403 responses

Make sure OAuth2 credentials have Search Console API enabled and the authenticated user has access to the site property.

Workflow waiting too long for crawl completion

Verify crawl task status on DataForSEO dashboard; abort or retry if stuck.

Summary of workflow result

✓ Automated crawl of up to 1000 pages for SEO data collection.

✓ Integration with Google Search Console to get real clicks and impressions.

✓ Identification and categorization of SEO issues including errors and thin content.

✓ Generation of a fully branded, easy-to-read HTML SEO audit report.

✓ Saves many hours of manual work and reduces human mistakes.