{"product_id":"n8n-seo-audit-workflow-apify-openai-google-sheets","title":"n8n SEO Audit Workflow: Apify + OpenAI + Google Sheets","description":"\u003ch3\u003eWeekly SEO\/GEO\/AEO audit + ticketing, automated with Apify, OpenAI, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes every Monday at \u003cstrong\u003e7:00am\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAudits with Apify:\u003c\/strong\u003e sends the configured website URL and page limit to the \u003cstrong\u003eApify “SEO, GEO and AEO Audit” actor\u003c\/strong\u003e, which renders pages, scores \u003cstrong\u003eclassic SEO\u003c\/strong\u003e, \u003cstrong\u003egenerative engine readiness\u003c\/strong\u003e, and \u003cstrong\u003eanswerability\u003c\/strong\u003e, and returns failed checks per URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares to last week:\u003c\/strong\u003e reads the previous week’s “Scoreboard” rows from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e as a baseline.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlags what needs attention:\u003c\/strong\u003e 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 \u003cstrong\u003eScoreboard\u003c\/strong\u003e tab for history.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates prioritized engineering tickets:\u003c\/strong\u003e limits flagged pages to the maximum ticket count and uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to create a structured ticket per page using \u003cem\u003eonly\u003c\/em\u003e the failed checks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutputs + alerts:\u003c\/strong\u003e appends tickets to the \u003cstrong\u003eTickets\u003c\/strong\u003e tab in Google Sheets and sends the same ticket details to your configured \u003cstrong\u003eTelegram\u003c\/strong\u003e chat.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain ongoing \u003cstrong\u003eSEO readiness\u003c\/strong\u003e and prevent regressions week over week.\u003c\/li\u003e\n  \u003cli\u003eGenerate actionable development tasks from \u003cstrong\u003eApify SEO\/GEO\/AEO audit\u003c\/strong\u003e results without manual triage.\u003c\/li\u003e\n  \u003cli\u003eGive SaaS teams a consistent weekly reporting + fix-ticket feed in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify, OpenAI, Google Sheets, Telegram\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003cem\u003eset, code, limit, filter, telegram, aggregate\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify actor:\u003c\/strong\u003e “SEO, GEO and AEO Audit” (configured via the Apify node)\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eNote:\u003c\/strong\u003e To get started, create a free Apify account and connect it in the Apify node; then add an \u003cstrong\u003eOpenAI API credential\u003c\/strong\u003e to enable ticket generation.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164194885811,"sku":"N8N-20497","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sxYUAB92LzyPOcoENMbns_ow6ApynX.png?v=1791277916","url":"https:\/\/buyflowscripts.com\/products\/n8n-seo-audit-workflow-apify-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}