{"product_id":"fix-low-ctr-seo-titles-with-n8n-gsc-openai-sheets","title":"Fix Low-CTR SEO Titles with n8n, GSC, OpenAI \u0026 Sheets","description":"\u003ch3\u003eFix low-CTR SEO titles automatically—using n8n, Google Search Console, OpenAI, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eIf your pages are ranking but not earning clicks, this n8n workflow pinpoints the biggest CTR offenders in \u003cstrong\u003eGoogle Search Console\u003c\/strong\u003e and generates improved \u003cstrong\u003eSEO titles and meta descriptions\u003c\/strong\u003e with \u003cstrong\u003eOpenAI\u003c\/strong\u003e. Suggestions are logged to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for review, with an optional step to write approved updates back to WordPress (Yoast or Rank Math).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly (and hourly for approvals):\u003c\/strong\u003e The weekly run finds new opportunities; the hourly run processes rows marked as approved in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents repeat suggestions:\u003c\/strong\u003e It reads the existing \u003cem\u003e“SEO Log”\u003c\/em\u003e tab in Google Sheets and applies a cooldown window so the same URL isn’t repeatedly re-suggested after updates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIdentifies underperforming pages:\u003c\/strong\u003e Using the Google Search Console Search Analytics API, it scores pages by missed clicks versus a position-based CTR benchmark and selects the worst offenders.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMaps candidates to WordPress content:\u003c\/strong\u003e It matches URLs to WordPress posts\/pages by \u003cem\u003eslug\u003c\/em\u003e and maps each candidate to a WordPress \u003cem\u003eID\u003c\/em\u003e and content type for optional write-back.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates title + meta using real query data:\u003c\/strong\u003e For each candidate URL, it pulls top queries from GSC, fetches live HTML to extract the current title, meta description, and H1, then uses \u003cstrong\u003eOpenAI Chat\u003c\/strong\u003e to produce:\n    \u003cul\u003e\n      \u003cli\u003ea new SEO title\u003c\/li\u003e\n      \u003cli\u003ean alternative title\u003c\/li\u003e\n      \u003cli\u003ea meta description (including a length check)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets for review:\u003c\/strong\u003e Each suggestion is appended with status set to \u003cem\u003e“pending”\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies approved changes (optional):\u003c\/strong\u003e On hourly runs, it updates Yoast\/Rank Math meta fields via the WordPress REST API and marks rows \u003cem\u003e“applied”\u003c\/em\u003e, or \u003cem\u003e“manual”\u003c\/em\u003e when write-back is disabled or the page can’t be matched.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eImprove click-through rate for existing ranking pages without guessing.\u003c\/li\u003e\n  \u003cli\u003eMaintain an editorial workflow: draft in Sheets, approve, then auto-apply to WordPress.\u003c\/li\u003e\n  \u003cli\u003eSaaS SEO teams automating GSC-driven title optimization at scale.\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 (Search Analytics API), Google Sheets, WordPress REST API, OpenAI Chat\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e if, set, code, html, http request, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore artifacts:\u003c\/strong\u003e “SEO Log” tab with cooldown enforcement; statuses “pending”, “approved” (input), “applied” or “manual”\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223928098995,"sku":"N8N-20930","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FIpgQvjIa6cI4IrLL6RTM_0DbkaPPZ.png?v=1791968809","url":"https:\/\/buyflowscripts.com\/products\/fix-low-ctr-seo-titles-with-n8n-gsc-openai-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}