Library / Content Writing & Generation
Content Writing & Generation
Rewrite low-CTR SEO titles from Search Console data with OpenAI and WordPress
Runs weekly, pulls underperforming pages from Google Search Console, and uses an LLM to draft new titles and meta descriptions based on each page's top queries.
What it does
## Find low-CTR pages in Search Console and rewrite their titles with AI ### How it works Every week this workflow pulls page performance from Google Search Console and flags pages whose CTR is well below what their average position should earn (a position-based CTR benchmark). Pages are ranked by missed clicks (impressions × CTR gap). For each page it fetches the top search queries for that page and the live title, meta description and H1, then an LLM writes a new SEO title, an alternative title and a meta description aimed at those real queries. Every suggestion lands in Google Sheets as pending with a length check. Review the sheet, edit if you like, and set status to approved. If write-back is enabled, the hourly run updates the post's SEO title and meta description in WordPress (Yoast or Rank Math). Otherwise approved rows are marked manual so you can paste them yourself. ### Setup steps - Search Console: create a Google OAuth2 API credential with scope https://www.googleapis.com/auth/webmasters.readonly and select it in the three Search Console HTTP nodes. - Google Sheets: create a tab named SEO Log with this header row: page_url | wp_id | wp_type | impressions | clicks | ctr | position | expected_ctr | missed_clicks | top_queries | current_title | current_description | new_title | alt_title | new_description | rationale | length_check | status | updated_at - AI model: add OpenAI credentials, or swap the chat model for Claude, Gemini or another model. - WordPress: create an Application Password and a WordPress API credential for the lookup and write-back nodes. - Config: set gsc_property (e.g. sc-domain:example.com or https://example.com/), wp_base_url, sheet_id and language. - Run On-Demand Activation once with max_per_run = 3 and check the sheet. ### Optional: write back to Yoast / Rank Math Set seo_plugin to yoast or rank_math and add this snippet as a must-use plugin, so the SEO fields become writable through the REST API: php true, 'single' => true, 'type' => 'string', 'auth_callback' => fn() => current_user_can('edit_posts'), ]); } } }); Test on a staging site first and confirm the new title appears in the page source. ### Customization - min_impressions, max_position and ctr_ratio control which pages count as underperforming. - For Japanese, Chinese or Korean sites, lower max_title_length to about 32 and max_description_length to about
The steps
- Weekly Trigger at 6 AM
- On-Demand Activation
- Hourly Trigger
- Configure Workflow Settings
- Check Hourly Execution
- Read SEO Log From Sheets
- Post Performance Data from GSC
- Calculate Underperformance Score
- Retrieve WordPress Posts by Slug
- Retrieve WordPress Pages by Slug
- Match WordPress Page IDs
- Post Top Search Queries
- Get Live Page HTML
- Extract HTML Title and Meta
24 steps in total.
Similar automations
Content Writing & GenerationDetect decaying WordPress posts and log GPT-4 refresh briefs with Search Console and28 stepsReports, Analytics & DashboardsExport Google Search Console Data to Google Sheets14 stepsReports, Analytics & DashboardsSend weekly Search Console reports to Slack and Sheets with Claude Haiku15 stepsReports, Analytics & DashboardsOptimize SEO with Search Console, Analytics and OpenAI23 steps