Skip to main content

Technical SEO audits with GPT-4o-mini & multi-format reporting (Sheets/Email)

Workflow preview

Workflow preview
100%
Technical SEO audits with GPT-4o-mini & multi-format reporting (Sheets/Email) preview
Open on n8n.io
n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER Hostinger Early Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

Instantly map all internal URLs, perform AI powered (ChatGPT) analysis, and deliver results in HTML via webhook, Google Sheets, or email. All from your own n8n instance! Why this workflow? Forge...

Best for

  • Market Research automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.splitinbatches, n8n-nodes-base.splitout, n8n-nodes-base.set, @n8n/n8n-nodes-langchain.openai, n8n-nodes-base.code, n8n-nodes-base.httprequest, n8n-nodes-base.xml, n8n-nodes-base.googlesheets

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Oriol Seguí.

Original n8n.io source

1.1 Workflow description

Title
Technical SEO audits with GPT-4o-mini & multi-format reporting (Sheets/Email)
Workflow name
Technical SEO audits with GPT-4o-mini & multi-format reporting (Sheets/Email)

Instantly map all internal URLs, perform AI-powered (ChatGPT) analysis, and deliver results in HTML via webhook, Google Sheets, or email. All from your own n8n instance!

💡 Why this workflow?

  • Forget expensive tools: Run deep, visual audits replacing Screaming Frog or Ahrefs.
  • Real URL mapping: Reads the sitemap, filters only internal URLs, and analyzes each one individually.
  • AI-powered analysis: ChatGPT detects critical issues, recommendations, and best practices on every page.
  • Error handling: The workflow includes robust error handling and guides you on what to do in each case.
  • Client-ready results: Receive a professional HTML report, an email summary, or push it to Google Sheets for team collaboration.
  • Automate by webhook or manually: Use it in backend integrations or trigger with a button.

🧠 What does the workflow do?

  1. Automatically detects the sitemap (robots.txt → sitemap.xml).

  2. Filters only internal URLs (ignores assets, images, scripts, etc).

  3. Fetches the full HTML content of each URL.

  4. Uses ChatGPT (GPT-4o-mini) for professional diagnostics (meta tags, headings, hreflang, Open Graph, links, duplicate content, etc).

  5. Groups results (critical issues, recommendations, best practices) and presents them as:

    • 📄 Professional HTML report (ready to send/share)
    • 📊 Google Sheets (collaborative structure)
    • 🔗 Webhook or HTML email (for automation)

🛠️ Technologies / APIs Used

  • n8n (self-hosted or cloud instance required)
  • ChatGPT API (required, approx. cost: €0.01 per 20 URLs analyzed)
  • Google Drive/Sheets API (only for Google Sheets output)
  • Email SMTP/Gmail (for notifications)

⚡ Who should use it?

  • SEOs and agencies needing technical reports in minutes
  • Freelancers automating client SEO audits
  • Web developers and growth hackers
  • Website owners/businesses with multiple sites

🎯 Problems solved

  • Slow, manual SEO auditing
  • Dependence on expensive SaaS
  • Lack of full-site coverage → every URL is checked with actionable recommendations
  • Fast, visual delivery to clients (HTML “copy-paste” report and/or collaborative sheet)

📝 Quick Setup

  1. Import the .json into your n8n.

  2. Add your credentials:

    • OpenAI (ChatGPT) API Key
    • Google account (only for Google Sheets output)

  3. Run manually or via webhook (you can pass the URL as a parameter).

  4. View the results in the generated HTML, Google Sheets, or your email.

💡 Details & Tips

  • Enter only the domain (e.g., example.com) — no https:// and no trailing slash.
  • If any error occurs (unusual sitemap, robots blocked, etc.), the messages are explained clearly.
  • You can change the analysis language (default: Spanish).
  • 100% customizable and extendable for other outputs (Notion, Slack, etc).

📦 What’s included?

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Iterar Páginas

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 2 - Split Out2

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 3 - Edit Fields1

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 4 - OpenAI1

Type / Role
@n8n/n8n-nodes-langchain.openAi - openAi
Config choices
Version 1.8

Block 5 - Code

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 6 - LANGUAGE

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 7 - Maping Sitemap

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 8 - XML1

Type / Role
n8n-nodes-base.xml - xml
Config choices
Version 1

Block 9 - Split Out8

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 10 - To html

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 11 - Html to JSON

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 12 - Google Sheets1

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 13 - Split Out10

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 14 - HTML format viewer

Type / Role
n8n-nodes-base.html - html
Config choices
Version 1.2

Block 15 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 16 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 17 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 18 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 19 - Sticky Note4

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 20 - Sticky Note5

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 21 - Sticky Note6

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 22 - Eliminar Webs Duplicadas

Type / Role
n8n-nodes-base.removeDuplicates - removeDuplicates
Config choices
Version 2

Block 23 - Sticky Note7

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 24 - Respond to Webhook

Type / Role
n8n-nodes-base.respondToWebhook - respondToWebhook
Config choices
Version 1.3

Showing the first 24 of 45 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Technical SEO audits with GPT-4o-mini & multi-format reporting (Sheets/Email)
Complexity advanced
Nodes 45
Categories Market Research, AI Summarization
Author Oriol Seguí
Published 06 Oct 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/9296/9296.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Download workflow JSON Original n8n.io source Market Research workflows AI Summarization workflows

Frequently asked questions

What does Technical SEO audits with GPT-4o-mini & multi-format reporting (Sheets/Email) do?

Instantly map all internal URLs, perform AI powered (ChatGPT) analysis, and deliver results in HTML via webhook, Google Sheets, or email. All from your own n8n instance! Why this workflow? Forge...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, AI Summarization use case.