Create weekly AI WordPress posts with images from SharePoint topics

Description

AI Article Publisher — Scheduled WordPress Post from Topic List

This workflow automatically generates and publishes a full-length, SEO-optimized WordPress article on a weekly schedule. Topics are sourced from a SharePoint list. The AI agent writes the article body with embedded inline images, generates a separate featured (hero) image, creates a WordPress draft, and sends a notification email when complete.

How it works
Schedule Trigger fires on a configurable schedule (default: every Monday at 10 AM)
Get Topics pulls unposted items from a SharePoint list where PostID is null
Fetch WP Categories retrieves all WordPress categories from your site
Format Categories + Match Categories AI selects the best-fit category IDs for the topic
Write Article (AI Agent + web search) writes a 1,500–2,500-word HTML article with 3–4 embedded inline images via the image tool
Strip Code Fences + Generate Title clean the output and produce an SEO-optimized title
Add Draft to WP creates the post as a draft in WordPress
Generate Feature Image + Upload Image → Attach Featured Media sets the hero image on the post
Update SharePoint PostID stamps the list item with the new WP Post ID to prevent re-processing
Build Notification Email + Send Notification delivers a formatted HTML email summary to your team

Setup
WordPress credential**: Create an Application Password in WP Admin → Users → Profile. Set the WordPress API credential in all WordPress nodes.
WordPress site URL**: Replace YOUR_WP_SITE_URL placeholder in HTTP Request nodes with your domain (e.g., https://yoursite.com).
SharePoint credential: Add a Microsoft SharePoint OAuth2 credential and select your SharePoint site and list in the **Get Topics and Update SharePoint PostID nodes.
OpenAI credential**: Add your OpenAI API key. GPT-4.1 (or GPT-4o) is recommended for the article agent; GPT-4.1-mini for category matching and title generation.
Google Gemini credential: Required for the **Generate Feature Image node. Add a Google PaLM/Gemini API key.
Image sub-workflow: The **Generate and Upload Image tool calls a separate image-generation sub-workflow. Deploy that workflow first and update the workflow ID in the tool node.
Notification email: Replace YOUR_NOTIFICATION_EMAIL in the **Send Notification node with your email address.

Customization
Change status: 'draft' to 'publish' in Add Draft to WP to auto-publish articles.
Adjust the article tone and CTA in the Write Article system prompt to match your brand voice.
Swap the SharePoint list for a Google Sheet or Airtable by replacing the Get Topics and Update Record nodes.

Visit automatedintelligentsolutions.com for more information and workflows.