This workflow automates the process of generating and scheduling social media posts using content from a WordPress blog…
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 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 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 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) 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. An n8n automation workflow template by Davide Boizza.
Davide Boizza
web
free
Others in the same category, ranked by how often they are opened.
