AI Content Automation Pipeline — Auto-Write & Publish SEO Articl

Built a fully automated AI content pipeline for a UK-based cruise
travel blog (Cruise Mummy) that takes a topic from a Google Sheet
and automatically writes, formats, and publishes a complete SEO
article to WordPress — with zero manual effort.

The system works in this flow:
Google Sheet (topic + description + image URL + backlink) →
ChatGPT API (AI writes full SEO article) →
Auto-formatter (structures headings, paragraphs, meta) →
WordPress REST API (publishes live to the site) →
Google Sheet update (logs live URL, publish date, status)

Key technical work included:

#n8n workflow architecture — designed and built 6 separate
interconnected workflows with status-based triggering
#RSS ingestion pipeline — auto-discovers new cruise news topics
with deduplication logic using live Google Sheets lookups
#WordPress JWT Authentication integration — configured JWT
Authentication for WP REST API plugin for secure auto-publishing
#Google Sheets data layer — migrated from Airtable, built
full status tracking and deduplication system
#AI prompt engineering — custom prompts for cruise travel
content optimized for SEO and brand voice
#Error handling — built retry logic and status flags across
all workflow stages

The client was a non-technical travel blogger managing a
high-traffic WordPress site. The system replaced hours of
manual writing, formatting, and publishing with a single
row entry in a Google Sheet.

#ContentAutomation #SEO #WordPress #n8n #AIWriting #ChatGPT
#WorkflowAutomation #NoCode #GoogleSheets #TravelBlog
#ArticleAutomation #AIContent #RESTapi #JWT