Rewrite low-CTR SEO titles using Google Search Console, OpenAI, Google Sheets, and WordPress
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 24 nodes and runs on a schedule (every week at 06:00) (plus 2 other triggers). Along the way it connects Google Sheets and OpenAI Chat Model.
How it runs
Trigger: On a schedule (every week at 06:00) (plus 2 other triggers).
- Configure Workflow Settings (Edit Fields (Set)): sets 14 fields: gsc_property, wp_base_url, language…
- Check Hourly Execution (If): checks a condition and branches into true / false
- Get Approved Rows from Sheets (Google Sheets): read
- Read SEO Log From Sheets (Google Sheets): read
- Check Write-back Option (If): checks a condition and branches into true / false
- Post Performance Data from GSC (HTTP Request): calls an HTTP API (POST)
- Post SEO Metadata Update (HTTP Request): calls an HTTP API (POST)
- Flag Row for Manual Review (Google Sheets): update
- Calculate Underperformance Score (Code): runs custom JavaScript code
- Update Applied Status (Google Sheets): update
…plus 9 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - HTML
n8n-nodes-base.html - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured
From the author
Quick overview This workflow finds underperforming pages in Google Search Console, generates improved SEO titles and meta descriptions with OpenAI based on real query data, logs suggestions in Google Sheets for review, and can optionally write approved…