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
-
Content Source: WordPress
- Automatically fetches the content of a WordPress post by its Post ID.
-
Content Transformation via AI
-
Visual Generation (Optional)
- Uses OpenAI's DALL·E (via OpenRouter) to generate custom images based on the AI-generated Instagram and Facebook/LinkedIn captions.
-
Post Management with Google Sheets
-
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
-
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.
-
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.
-
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
-
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).
-
Google Sheets Setup:
- Clone the template Sheet and add WordPress post IDs to the "POST ID" column.
-
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.
-
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.