Technical SEO Audits with GPT-4o-mini & Multi-format Reporting (Sheets/Email)

Go to Workflow
0 views
Built by Oriol Seguí Oriol Seguí
Created on June 05, 2026

Description


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?

Automatically detects the sitemap (robots.txt → sitemap.xml).
Filters only internal URLs (ignores assets, images, scripts, etc).
Fetches the full HTML content of each URL.
Uses ChatGPT (GPT-4o-mini) for professional diagnostics (meta tags, headings, hreflang, Open Graph, links, duplicate content, etc).
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

Import the .json into your n8n.
Add your credentials:

OpenAI (ChatGPT) API Key
Google account (only for Google Sheets output)
Run manually or via webhook (you can pass the URL as a parameter).
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?

🧩 n8n workflow file → SEO n8n.json
📘 Quick install guide (README)
💬 Direct support: [email protected]
📸 More info and photos: [email protected]

Nodes Used (6)

Code
n8n-nodes-base.code
Gmail
n8n-nodes-base.gmail
Google Sheets
n8n-nodes-base.googleSheets
HTML
n8n-nodes-base.html
HTTP Request
n8n-nodes-base.httpRequest
OpenAI
@n8n/n8n-nodes-langchain.openAi