n8n SEO Audit Workflow: Apify + OpenAI + Google Sheets

Weekly SEO/GEO/AEO audit + ticketing, automated with Apify, OpenAI, and Google Sheets

This n8n workflow automatically crawls your website every Monday, compares SEO/GEO/AEO results against last week in Google Sheets, and uses OpenAI to generate prioritized fix tickets—then saves them to Sheets and sends them to Telegram.

What this workflow does

• Runs on a schedule: executes every Monday at 7:00am.
• Audits with Apify: sends the configured website URL and page limit to the Apify “SEO, GEO and AEO Audit” actor, which renders pages, scores classic SEO, generative engine readiness, and answerability, and returns failed checks per URL.
• Compares to last week: reads the previous week’s “Scoreboard” rows from Google Sheets as a baseline.
• Flags what needs attention: per URL, flags pages that regress beyond the configured point threshold, fall below the minimum score, or have critical issues. It writes all pages back to the Scoreboard tab for history.
• Generates prioritized engineering tickets: limits flagged pages to the maximum ticket count and uses OpenAI to create a structured ticket per page using only the failed checks.
• Outputs + alerts: appends tickets to the Tickets tab in Google Sheets and sends the same ticket details to your configured Telegram chat.

Use cases

• Maintain ongoing SEO readiness and prevent regressions week over week.
• Generate actionable development tasks from Apify SEO/GEO/AEO audit results without manual triage.
• Give SaaS teams a consistent weekly reporting + fix-ticket feed in Google Sheets and Telegram.

Technical details

• Integrations: Apify, OpenAI, Google Sheets, Telegram
• n8n nodes used: set, code, limit, filter, telegram, aggregate
• Apify actor: “SEO, GEO and AEO Audit” (configured via the Apify node)

Note: To get started, create a free Apify account and connect it in the Apify node; then add an OpenAI API credential to enable ticket generation.