Microsoft SharePoint and OpenAI integration

Create weekly AI WordPress posts with images from SharePoint topics

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.