Back to Catalog

Automate SEO blog creation + social media with GPT-4, Perplexity and WordPress

LukaszBLukaszB
5424 views
2/3/2026
Official Page

πŸš€ AI Blog & Social Media Publisher – Fully Automated Workflow

This workflow is ideal for individuals, marketers, agencies, and brands who want to effortlessly automate the entire blogging and social media processβ€”from idea generation to promotion. Its primary goal is to consistently deliver engaging, SEO-optimized blog posts directly to WordPress, accompanied by professionally crafted social media content ready for Instagram, Facebook, and X (Twitter).

No writers, editors, designers, or social media managers required. Save countless hours and resources while boosting your brand's online presence.

πŸ”§ Workflow Capabilities:

-Automated Blog Topic Generation: Instantly generates unique, high-value blog ideas tailored to your brand. -SEO Content Creation: Produces comprehensive, 2000–2500 word articles optimized for search engines. -Real-Time Research: Integrates Perplexity AI to ensure factually accurate, authoritative content. -Visual Content Generation: Creates custom, AI-generated featured images via GPT-4, with automatic fallback to Pexels. -WordPress Publishing: Automatically publishes articles directly to WordPress with complete formatting (HTML), meta descriptions, featured images, and proper categorization. -Social Media Automation: Generates and schedules engaging, platform-specific posts for Instagram, Facebook, and X, complete with relevant hashtags, calls-to-action, and links. -Detailed Logging & Reporting: Logs every step transparently into Google Sheets and optionally sends publication reports to Gmail.

βš™οΈ How It Works:

When activated, the workflow checks your content calendar in Google Sheets to avoid duplicate topics. It generates fresh, brand-aligned blog ideas, conducts live research, and creates complete, ready-to-publish articles. It then automatically designs and sources appropriate visuals, publishes content seamlessly to WordPress, and prepares engaging social media posts optimized for each platform.

πŸ› οΈ Easy Setup Steps:

-Connect your APIs: OpenAI, WordPress, Google Sheets, Gmail, and optionally Pexels. -Replace placeholders (WordPress URLs, Google Sheets ID/tab, workflow IDs). -Customize AI prompts with your brand’s tone, keywords, and CTAs for personalized content. -Configure scheduling to automate daily, weekly, or custom publishing intervals.

πŸ“Œ Additional Features:

-Modular workflow design for easy customization and scalability. -Comprehensive Markdown and PDF setup guides included. -Bonus: Reference placeholders and quick-edit Sticky Notes for effortless adjustments.

Launch today. Automate permanently. Amplify your reach effortlessly.

# Automate SEO Blog Creation & Social Media with GPT-4, Perplexity, and WordPress

This n8n workflow automates the entire process of generating SEO-optimized blog posts using AI, publishing them to WordPress, and then promoting them across social media platforms like Facebook and X (formerly Twitter). It leverages advanced AI models like GPT-4 and Perplexity (via an HTTP Request) to create high-quality, engaging content, and integrates with various services to streamline your content marketing efforts.

## What it does

This workflow simplifies content creation and distribution by performing the following steps:

1.  **Triggers Manually or on Schedule**: The workflow can be initiated manually or set to run on a defined schedule.
2.  **Generates Blog Post Ideas**: It uses an AI Agent (likely GPT-4) to brainstorm and generate a list of SEO-friendly blog post titles based on a given prompt or input.
3.  **Fetches Content with Perplexity**: For each generated title, it uses an HTTP Request node to query Perplexity AI, gathering relevant information and content for the blog post.
4.  **Generates Full Blog Content**: Another AI Agent (GPT-4) then takes the gathered information and the blog title to write a comprehensive, SEO-optimized blog post in Markdown format.
5.  **Formats Content for WordPress**: The Markdown content is converted into a suitable format for WordPress.
6.  **Publishes to WordPress**: The generated blog post is automatically published to your WordPress site.
7.  **Generates Social Media Posts**: It uses an AI Agent to create engaging social media updates for Facebook and X (formerly Twitter) based on the newly published blog post.
8.  **Posts to Facebook**: The generated Facebook post is published to your Facebook page via the Facebook Graph API.
9.  **Posts to X (formerly Twitter)**: The generated X (formerly Twitter) post is published to your Twitter account.
10. **Optional Notification**: An optional Gmail node is included, potentially for sending notifications about the successful publication or for human-in-the-loop approvals.
11. **Notion Integration**: An optional Notion node is included, which could be used for tracking content ideas, published posts, or managing the content pipeline.

## Prerequisites/Requirements

To use this workflow, you will need:

*   **n8n Instance**: A running n8n instance.
*   **OpenAI API Key**: For the AI Agent (GPT-4) and OpenAI Chat Model nodes.
*   **Perplexity API Access**: The HTTP Request node will need to be configured to interact with the Perplexity AI API.
*   **WordPress Account**: Credentials for your WordPress site to publish posts.
*   **Facebook Developer Account / Page Access Token**: To post to a Facebook page.
*   **X (formerly Twitter) Developer Account / API Keys**: To post to X (formerly Twitter).
*   **Gmail Account (Optional)**: If you intend to use the Gmail notification feature.
*   **Notion Integration (Optional)**: If you plan to use Notion for content tracking.
*   **Google Sheets (Optional)**: The initial Google Sheets node suggests that content ideas or other data might be pulled from a spreadsheet.

## Setup/Usage

1.  **Import the Workflow**: Download the JSON provided and import it into your n8n instance.
2.  **Configure Credentials**:
    *   Set up your **OpenAI** credentials for the "OpenAI Chat Model" and "OpenAI" nodes.
    *   Configure your **WordPress** credentials.
    *   Set up your **Facebook Graph API** credentials.
    *   Set up your **X (formerly Twitter)** credentials.
    *   (Optional) Configure your **Gmail** and **Notion** credentials if you plan to use these features.
3.  **Customize Perplexity HTTP Request**: Configure the "HTTP Request" node (likely named "Perplexity API Call") with your Perplexity API endpoint and any necessary authentication.
4.  **Adjust AI Prompts**: Review the "AI Agent" and "Basic LLM Chain" nodes to customize the prompts for blog title generation, content creation, and social media post generation to match your specific SEO and content style guidelines.
5.  **Configure WordPress Node**: Ensure the "WordPress" node is set to create new posts and map the generated content fields correctly.
6.  **Configure Social Media Nodes**: Map the generated social media content to the "Facebook Graph API" and "X" nodes.
7.  **(Optional) Configure Google Sheets**: If you want to pull initial blog ideas from Google Sheets, configure the "Google Sheets" node.
8.  **Activate and Test**: Set the workflow to active and run a test execution to ensure all steps are working as expected. You can use the "Manual Trigger" for initial testing.
9.  **Schedule (Optional)**: If you want automated execution, configure the "Schedule Trigger" node to run at your desired intervals.

Related Templates

Automated YouTube video uploads with 12h interval scheduling in JST

This workflow automates a batch upload of multiple videos to YouTube, spacing each upload 12 hours apart in Japan Standard Time (UTC+9) and automatically adding them to a playlist. βš™οΈ Workflow Logic Manual Trigger β€” Starts the workflow manually. List Video Files β€” Uses a shell command to find all .mp4 files under the specified directory (/opt/downloads/单词卑/A1-A2). Sort and Generate Items β€” Sorts videos by day number (dayXX) extracted from filenames and assigns a sequential order value. Calculate Publish Schedule (+12h Interval) β€” Computes the next rounded JST hour plus a configurable buffer (default 30 min). Staggers each video’s scheduled time by order Γ— 12 hours. Converts JST back to UTC for YouTube’s publishAt field. Split in Batches (1 per video) β€” Iterates over each video item. Read Video File β€” Loads the corresponding video from disk. Upload to YouTube (Scheduled) β€” Uploads the video privately with the computed publishAtUtc. Add to Playlist β€” Adds the newly uploaded video to the target playlist. πŸ•’ Highlights Timezone-safe: Pure UTC ↔ JST conversion avoids double-offset errors. Sequential scheduling: Ensures each upload is 12 hours apart to prevent clustering. Customizable: Change SPANHOURS, BUFFERMIN, or directory paths easily. Retry-ready: Each upload and playlist step has retry logic to handle transient errors. πŸ’‘ Typical Use Cases Multi-part educational video series (e.g., A1–A2 English learning). Regular content release cadence without manual scheduling. Automated YouTube publishing pipelines for pre-produced content. --- Author: Zane Category: Automation / YouTube / Scheduler Timezone: JST (UTC+09:00)

ZaneBy Zane
226

Detect holiday conflicts & suggest meeting reschedules with Google Calendar and Slack

Who’s it for Remote and distributed teams that schedule across time zones and want to avoid meetings landing on public holidaysβ€”PMs, CS/AM teams, and ops leads who own cross-regional calendars. What it does / How it works The workflow checks next week’s Google Calendar events, compares event dates against public holidays for selected country codes, and produces a single Slack digest with any conflicts plus suggested alternative dates. Core steps: Workflow Configuration (Set) β†’ Fetch Public Holidays (via a public holiday API such as Calendarific/Nager.Date) β†’ Get Next Week Calendar Events (Google Calendar) β†’ Detect Holiday Conflicts (compare dates) β†’ Generate Reschedule Suggestions (find nearest business day that isn’t a holiday/weekend) β†’ Format Slack Digest β†’ Post Slack Digest. How to set up Open Workflow Configuration (Set) and edit: countryCodes, calendarId, slackChannel, nextWeekStart, nextWeekEnd. Connect your own Google Calendar and Slack credentials in n8n (no hardcoded keys). (Optional) Adjust the Trigger to run daily or only on Mondays. Requirements n8n (Cloud or self-hosted) Google Calendar read access to the target calendar Slack app with permission to post to the chosen channel A public-holiday API (no secrets needed for Nager.Date; Calendarific requires an API key) How to customize the workflow Time window: Change nextWeekStart/End to scan a different period. Holiday sources: Add or swap APIs; merge multiple regions. Suggestion logic: Tweak the look-ahead window or rules (e.g., skip Fridays). Output: Post per-calendar messages, DM owners, or create tentative reschedule events automatically.

Takuya OjimaBy Takuya Ojima
70

Track daily moods with AI analysis & reports using GPT-4o, Data Tables & Gmail

Track your daily mood in one tap and receive automated AI summaries of your emotional trends every week and month. Perfect for self-reflection, wellness tracking, or personal analytics. This workflow logs moods sent through a webhook (/mood) into Data Tables, analyzes them weekly and monthly with OpenAI (GPT-4o), and emails you clear summaries and actionable recommendations via Gmail. βš™οΈ How It Works Webhook – Mood β†’ Collects new entries (πŸ™‚, 😐, or 😩) plus an optional note. Set Mood Data β†’ Adds date, hour, and note fields automatically. Insert Mood Row β†’ Stores each record in a Data Table. Weekly Schedule (Sunday 20:00) β†’ Aggregates the last 7 days and sends a summarized report. Monthly Schedule (Day 1 at 08:00) β†’ Aggregates the last 30 days for a deeper AI analysis. OpenAI Analysis β†’ Generates insights, patterns, and 3 actionable recommendations. Gmail β†’ Sends the full report (chart + AI text) to your inbox. πŸ“Š Example Auto-Email Weekly Mood Summary (last 7 days) πŸ™‚ 5 β–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆ 😐 2 β–ˆβ–ˆβ–ˆβ–ˆ 😩 0 Average: 1.7 (Positive πŸ™‚) AI Insights: You’re trending upward this week β€” notes show that exercise days improved mood. Try keeping short walks mid-week to stabilize energy. 🧩 Requirements n8n Data Tables enabled OpenAI credential (GPT-4o or GPT-4 Turbo) Gmail OAuth2 credential to send summaries πŸ”§ Setup Instructions Connect your credentials: Add your own OpenAI and Gmail OAuth2 credentials. Set your Data Table ID: Open the Insert Mood Row node and enter your own Data Table ID. Without this, new moods won’t be stored. Replace the email placeholder: In the Gmail nodes, replace your.email@example.com with your actual address. Deploy and run: Send a test POST request to /mood (e.g. { "mood": "πŸ™‚", "note": "productive day" }) to log your first entry. ⚠️ Before activating the workflow, ensure you have configured the Data Table ID in the β€œInsert Mood Row” node. 🧠 AI Analysis Interprets mood patterns using GPT-4o. Highlights trends, potential triggers, and suggests 3 specific actions. Runs automatically every week and month. πŸ”’ Security No personal data is exposed outside your n8n instance. Always remove or anonymize credential references before sharing publicly. πŸ’‘ Ideal For Personal mood journaling and AI feedback Therapists tracking client progress Productivity or self-quantification projects πŸ—’οΈ Sticky Notes Guide 🟑 Mood Logging Webhook POST /mood receives mood + optional note. ⚠️ Configure your own Data Table ID in the β€œInsert Mood Row” node before running. 🟒 Weekly Summary Runs every Sunday 20:00 β†’ aggregates last 7 days β†’ generates AI insights + emails report. πŸ”΅ Monthly Summary Runs on Day 1 at 08:00 β†’ aggregates last 30 days β†’ creates monthly reflection. 🟣 AI Analysis Uses OpenAI GPT-4o to interpret trends and recommend actions. 🟠 Email Delivery Sends formatted summaries to your inbox automatically.

Jose CastilloBy Jose Castillo
105