Auto-generate platform-optimized social media posts from WordPress with Claude & Postiz

This workflow automates the process of generating and scheduling social media posts using content from a WordPress blog. It leverages advanced AI (OpenAI & Anthropic Claude), Google Sheets, and the Postiz platform to create and publish platform-specific posts across LinkedIn, Facebook, Instagram, and Twitter (X).

This system streamlines cross-platform social media publishing, ensuring consistent branding and AI-optimized content.

Key Features

1. Content Source: WordPress

   • Automatically fetches the content of a WordPress post by its Post ID.

2. Content Transformation via AI

   • Uses Anthropic Claude and OpenAI to generate unique, optimized captions for each platform:

     • LinkedIn: professional and insight-driven
     • Instagram: creative with emojis and storytelling
     • Facebook: community-oriented and friendly
     • Twitter (X): concise, hashtag-optimized

3. Visual Generation (Optional)

   • Uses OpenAI's DALL·E (via OpenRouter) to generate custom images based on the AI-generated Instagram and Facebook/LinkedIn captions.

4. Post Management with Google Sheets

   • Uses a Google Sheet as the control panel:

     • Simply input the WordPress Post ID
     • Marks each post as “done” by updating corresponding columns (TWITTER, FACEBOOK, INSTAGRAM, LINKEDIN)

5. Publishing via Postiz

   • Uses the Postiz API to schedule or immediately publish posts to your connected social accounts.
   • Handles image uploads and scheduling time for each platform.

Benefits

• 💡 Intelligent automation: Saves time by removing manual copywriting and platform formatting.
• 🎯 Platform optimization: Ensures posts are tailored to each platform’s audience and algorithm.
• 🛠️ No-code friendly: Simple setup via Google Sheets + Postiz + WordPress.
• 🔁 Repeatable & Scalable: Ideal for agencies or content creators managing multiple posts per week.
• 🧪 +20 Social Media Platforms: Easy to start with social integrations.

How It Works

1. Input & Data Fetching:

   • The workflow starts with a manual trigger (e.g., "Test workflow") or scheduled execution.
   • It retrieves a WordPress post ID from a Google Sheets document, then fetches the full post content (title and body) via the WordPress API.

2. AI-Powered Content Generation:

   • The "Social Media Manager" node (powered by Claude Opus 4.1) analyzes the post and generates platform-optimized captions for:
     • Twitter/X: Concise, hashtag-rich text (≤150 chars).
     • Facebook/LinkedIn: Professional yet engaging copy with CTAs.
     • Instagram: Visual-focused captions with emojis and hashtags.
   • AI-generated images are created for Instagram (square) and Facebook/LinkedIn (landscape) using OpenAI’s image model.

3. Publishing Automation:

   • Captions and images are uploaded to Postiz, a social media scheduler.
   • Postiz publishes the content to connected platforms (Twitter, Facebook, LinkedIn, Instagram) at the specified time.
   • Google Sheets is updated with status markers (e.g., "x" in columns like TWITTER, FACEBOOK) to track published posts.

Set Up Steps

1. Prerequisites:

   • Postiz Account: Sign up for Postiz (free trial available).
   • API Keys: Configure Postiz API credentials in the "Postiz" and "Upload Image" nodes.
   • Social Channels: Link your social accounts in Postiz’s dashboard and note their integrationId values (replace "XXX" in Postiz nodes).

2. Google Sheets Setup:

   • Clone the template Sheet and add WordPress post IDs to the "POST ID" column.

3. Configure Nodes:

   • WordPress: Add credentials for your WordPress site in the "Get Post" node.
   • AI Models: Ensure API keys for Claude (Anthropic) and OpenAI (for images) are valid.
   • Postiz Nodes: Replace placeholder integrationId values with your actual Postiz channel IDs.

4. Test & Deploy:

   • Trigger the workflow manually to verify captions, images, and Postiz scheduling.
   • Activate the workflow for automation (e.g., run daily to publish new WordPress posts).

Note: This workflow requires self-hosted n8n due to community nodes (Postiz, LangChain).

Need help customizing?

Contact me for consulting and support or add me on Linkedin.