Back to Templates

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

Created by

Created by: Oriol Seguí || oxsr11

Oriol Seguí

Last update

Last update 13 hours ago

Share


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?