CODARAB n8n SEO Auto Post for WordPress
The complete n8n automation workflow to rank on Google, ChatGPT, Gemini & Perplexity — without writing a single word manually.
⚡ What Is This Workflow?
CODARAB n8n SEO Auto Post is a production-ready n8n automation workflow that reads your article titles from a Google Sheet, sends them to OpenAI, and fully generates then publishes SEO-optimized WordPress posts — including featured images, categories, tags, schema markup, FAQ sections, and internal links — all on autopilot. One run. Hundreds of articles. Zero manual writing.
Full Automation Pipeline
Google SheetsTitles + Brand + Videos
Google DocsInternal Links
OpenAIArticle Package JSON
WordPressMedia + Category + Tags
Sitemap PingGoogle + Bing
Complete Feature List
Google Sheets Input
Pull article titles, featured image URLs, body image URLs, per-row publish dates, brand data, and YouTube/Vimeo/Dailymotion video lists from separate sheets in one run.
Google Docs Internal Links
Connect a Google Doc containing your internal link list. The workflow injects 2+ internal links naturally into each generated article automatically.
OpenAI Article Generation
Calls OpenAI GPT-4.1-mini to generate a full article package as strict JSON: title, slug, meta description, tags, category, HTML content, and image alt texts in one shot.
1700+ Word Articles
Every article meets the 1700-word minimum with short paragraphs, bullet lists, H2/H3 hierarchy, Key Takeaways box, clickable Table of Contents, and a 7+ Q&A FAQ section.
On-Page SEO Enforcement
Primary keyword placed in first 100 words, at least two H2 headings, meta description, and conclusion. No keyword stuffing. Semantic variations applied throughout.
AI Search Optimization
Adds an AI-Summary block after the intro, uses comparative/factual tone, avoids promotional claims, and embeds structured FAQs — making content highly citable by ChatGPT, Gemini, and Perplexity.
Schema Markup (JSON-LD)
Automatically injects both an Article schema and a FAQPage schema inside content_html as <script type=”application/ld+json”> blocks — fully compliant with Google’s rich results requirements.
CSS Design System v5.1
Injects a premium article design system (Sora + DM Sans fonts, custom styling for AI-summary, TOC, Key Takeaways, process diagram, comparison tables) into every post.
Featured Image Upload
Downloads featured images from your sheet URLs, uploads them to WordPress Media Library, sets the correct alt text in the article language, and assigns them as post thumbnails automatically.
Body Images + Alt Texts
Injects up to 4 body images into the article with AI-generated, keyword-optimized alt texts in the correct article language — supporting PNG, JPG, JPEG, and WebP.
Auto Category & Tags
Creates or finds existing WordPress categories and tags by slug (upsert logic). Tags are specific 2-3 word phrases. Category is auto-generated by AI or falls back to title keywords.
Video Embedding
Picks the most relevant video from your sheet and embeds it after the first H2 — supports YouTube, Vimeo, Dailymotion, and self-hosted MP4/WebM with responsive wrappers.
Post Scheduling
Set per-row publish dates in your sheet. The workflow converts Morocco time (UTC+1) to UTC and schedules posts as future in WordPress automatically — or publishes immediately.
Multilingual Support
Auto-detects the article language from the title. Writes everything — including UI labels (TOC, FAQ heading, Key Takeaways, Step word, AI Summary) — in the correct language. Supports EN, FR, DE, AR (RTL), ES, PT, IT, NL, TR.
Sitemap Auto-Ping
After every publish, automatically pings both Google and Bing with your sitemap URL to trigger faster crawling and indexing of fresh content.
One-Node Configuration
All settings live in a single Config node: WP site URL, publish status, OpenAI model, article count limit, emoji toggle, and global publish date — no deep editing required.
Batch Processing
Processes up to 999 articles per run using n8n’s Split In Batches logic. Each article is handled individually with full error isolation — one failure never stops the queue.
Robust Error Handling
Graceful fallbacks throughout: skips media upload if no image URL is provided, continues on WP API failures, falls back to title keywords for category names, and validates all required JSON keys before posting.
📐 What’s Inside Every Generated Article
- AI Summary block (Quick Summary / Résumé rapide / ملخص سريع…)
- Clickable Table of Contents with anchor links
- Key Takeaways box before TOC
- 7+ Q&A FAQ section with FAQPage JSON-LD
- Article JSON-LD schema (headline matches WP H1)
- At least ONE responsive comparison table
- At least ONE process diagram section (step-by-step)
- At least ONE data/specs/pricing table
- Primary keyword in first 100 words + two H2s + conclusion
- 4+ external authority links (Wikipedia, gov, academic, industry)
- 2+ internal links from your Google Doc list
- Relevant video embed (YouTube / Vimeo / self-hosted)
- Featured image with keyword alt text
- 4 body images with keyword alt text variations
- H2/H3 hierarchy — no duplicate H1 in content
- Short paragraphs + bullet lists throughout
- Professional tone, no emojis (configurable), no spammy language
- CSS design system injected once at top of content
Tech Stack & Integrations
OpenAI GPT-4.1-mini
WordPress REST API
Google Sheets API
Google Docs API
YouTube / Vimeo / Dailymotion
Google + Bing Sitemap Ping
JSON-LD Schema
WebP / PNG / JPG / JPEG
Multilingual RTL Support
✅ Compatibility
| Component | Requirement | Notes |
|---|---|---|
| n8n | Self-hosted or n8n Cloud | Works on any recent version |
| WordPress | Any WP site with REST API enabled | WooCommerce sites included |
| OpenAI | API key required | GPT-4.1-mini by default (configurable) |
| Google Sheets | OAuth2 credentials in n8n | 3 sheets: Brand, Titles, Videos |
| Google Docs | OAuth2 credentials in n8n | 1 doc: Internal Links list |
| WordPress Auth | Application Password | Standard WP credential node |
