Weekly Family History AI Stories: GPT-4 + Pinecone to WordPress

Generate a new AI family-history story every week—automatically publish it to WordPress with a featured image

This n8n workflow uses GPT-4o with Pinecone document retrieval to write a 500–1000 word family-history short story, then publishes the story as WordPress-ready HTML and creates a Google Gemini featured image for the post—running every Wednesday.

What this workflow does

• Weekly schedule: Runs on a set cadence every Wednesday.
• AI story generation with retrieval: Uses OpenAI (GPT-4o) with session memory plus a Pinecone-backed retrieval tool to generate an AI-written family-history short story (target length: 500–1000 words) as WordPress-ready HTML.
• Story title + slug handling: Extracts the <h1> title, derives a URL slug, and prepares the remaining HTML as the post body.
• Publishes to WordPress: Creates and publishes a WordPress post containing the generated HTML content.
• Featured image via Gemini: Generates a featured image using Google Gemini based on the WordPress post excerpt.
• Uploads and sets image: Uploads the generated image to the WordPress Media Library and assigns it as the post’s featured image.

Use cases

• For automation engineers setting up a WordPress content pipeline for recurring publishing.
• For SaaS operators or creators managing “family history” or genealogy-style knowledge bases in Pinecone.
• For n8n users who want AI storytelling that stays grounded in their own documents (via Pinecone retrieval).

Technical details

• Schedule Trigger: Weekly runs every Wednesday.
• OpenAI: GPT-4o chat model and embeddings for retrieval.
• Pinecone: Retrieval tool using your target index (e.g., ariail-ms), populated with family documents.
• WordPress API: Creates/publishes posts and uploads featured images to the Media Library.
• Google Gemini: Generates the featured image from the post excerpt.
• Workflow nodes (as used): code, wordpress, sticky note, http request, n8nn8n-nodes-langchainagent, schedule trigger.

Setup requirements

Add OpenAI, Pinecone, WordPress, and Google Gemini credentials, verify your Pinecone index is ready, and (if needed) update WordPress REST endpoints and schedule timing to match your environment.