Back to Templates

Auto-Generate Platform-Optimized Social Media Posts from WordPress with Claude & Postiz

Created by

Created by: Davide || n3witalia

Davide

Last update

Last update 2 days ago

Share


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.