n8n Workflow: OpenAI SEO Posts with Verified WordPress Links

Automate Daily SEO Article Creation in WordPress—With Verified Internal Links

This n8n workflow builds an internal-link library from your published WordPress posts, uses OpenAI to draft an SEO article, validates every internal <a href> against your candidates, generates a featured image, publishes the post, and updates your Google Sheets queue—runs automatically every day at 9am.

What this workflow does

• Scheduled execution: Runs daily at 9am and pulls the next row marked “To do” from your Google Sheets topic queue. Stops if the queue is empty.
• Builds internal link candidates: Fetches your latest published posts via the WordPress REST API and ranks them against the topic to create a shortlist.
• Generates a structured SEO post with OpenAI: Drafts a complete SEO package (title, slug, meta description, HTML body, and an image prompt) inserting internal links only from the candidate list.
• Verifies and cleans internal links: Validates every <a href> in the generated HTML against the candidate list, removing hallucinated or duplicate links and recording warnings if link counts fall outside your configured min/max.
• Creates and uploads a featured image: Uses OpenAI Images, uploads to the WordPress media library, and attaches it to the post.
• Publishes and tracks progress: Creates the WordPress post with your chosen post_status (e.g., keep draft until reviewed) and updates the Google Sheets row as Published with the post URL and timestamp.

Use cases

• SaaS operators generating consistent SEO posts while maintaining reliable internal linking.
• Automation engineers managing a content queue in Google Sheets and publishing to WordPress with controlled review via draft status.
• Teams that want AI drafting, but require validated internal links to avoid broken or irrelevant references.

Technical details

• Integrations: Google Sheets, WordPress REST API (application password), OpenAI (chat + images).
• Workflow logic/nodes used: if, set, code, no op, limit, sticky note.

Setup: Configure credentials (Google Sheets, WordPress REST API, OpenAI API key). Set wp_base_url and choose post_status in the Configuration step.