{"product_id":"n8n-workflow-detect-decaying-wordpress-seo-log-gpt-refresh-briefs","title":"n8n Workflow: Detect Decaying WordPress SEO \u0026 Log GPT Refresh Briefs","description":"\u003ch3\u003eDetect decaying WordPress SEO in Google Search Console—then automatically generate OpenAI refresh briefs\u003c\/h3\u003e\n\u003cp\u003eIf your WordPress pages are losing clicks month over month, this n8n workflow pinpoints exactly which URLs are slipping and creates evidence-based GPT refresh briefs you can track in Google Sheets—weekly or on-demand.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation runs every Monday (scheduled) or can be started manually. It then:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003eLoads configuration values and reads the existing \u003cstrong\u003e“Refresh Log”\u003c\/strong\u003e from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eQueries \u003cstrong\u003eGoogle Search Console\u003c\/strong\u003e for page-level performance comparing the last 28 days vs the prior 28 days.\u003c\/li\u003e\n  \u003cli\u003eFlags WordPress pages where \u003cstrong\u003eclicks decline\u003c\/strong\u003e beyond a configured threshold, while excluding URLs already in progress or within a cooldown.\u003c\/li\u003e\n  \u003cli\u003eLooks up each flagged URL in WordPress by \u003cstrong\u003eslug\u003c\/strong\u003e (posts and pages) to capture the WordPress ID, content type, and last-modified date when available.\u003c\/li\u003e\n  \u003cli\u003eFetches \u003cstrong\u003equery-level performance\u003c\/strong\u003e for both time windows and compiles the top lost-click queries plus queries that are new or growing.\u003c\/li\u003e\n  \u003cli\u003ePulls the article content from the \u003cstrong\u003eWordPress REST API\u003c\/strong\u003e (or downloads live HTML when needed), then extracts headings and plain text for context.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a structured refresh brief (priority, diagnosis, actions, new sections, and a suggested title) and appends it to Google Sheets with status set to \u003cstrong\u003epending\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eOn each run, checks rows marked as refreshed, stamps \u003cstrong\u003erefreshed_at\u003c\/strong\u003e if missing, and continues the refresh measurement flow based on the logged results.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators managing large WordPress content libraries who need ongoing \u003cstrong\u003eSEO decay detection\u003c\/strong\u003e and refresh planning.\u003c\/li\u003e\n  \u003cli\u003eSEO teams using \u003cstrong\u003eGoogle Search Console\u003c\/strong\u003e trends to prioritize content updates with evidence.\u003c\/li\u003e\n  \u003cli\u003en8n users who want a repeatable pipeline: detect → diagnose with page + query data → generate briefs → log outcomes in Google Sheets.\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 Google Search Console, Google Sheets, WordPress (REST API + live HTML fallback), OpenAI.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools used:\u003c\/strong\u003e if, set, code, sticky note, HTTP request, Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244496081075,"sku":"N8N-21183","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/r6HooLsc59nfir0pKKfX6_Z4w8eGAP.png?v=1792400571","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-detect-decaying-wordpress-seo-log-gpt-refresh-briefs","provider":"N8N Commerce","version":"1.0","type":"link"}