Generate and approve SEO content with OpenAI, Airtable, Slack, and WordPress
Needs changesWhat this workflow does
This AI workflow has 42 nodes and runs on a schedule (legacy Cron node) (plus 2 other triggers). Along the way it connects Airtable, Wordpress, X (Formerly Twitter) and LinkedIn and 2 more.
How it runs
Trigger: On a schedule (legacy Cron node) (plus 2 other triggers).
- DB: Fetch Idea Topics (Airtable): search
- DB: Fetch Approved Content (Airtable): search
- Fetch Rejected Content (Airtable): search
- Loop: Process Idea Topics (Loop Over Items (Split in Batches)): loops over the items in batches
- Loop: Process Approved Content (Loop Over Items (Split in Batches)): loops over the items in batches
- Loop: Process Rejected Content (Loop Over Items (Split in Batches)): loops over the items in batches
- DB: Mark Topic as Processing (Airtable): update
- Approved Data Exists? (If): checks a condition and branches into true / false
- DB: Mark Record as Processing (Regen Lock) (Airtable): update
- Check: Valid Topic (If): checks a condition and branches into true / false
…plus 29 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Cron in Trigger: Generate Content: replace with Schedule Trigger.
- OpenAI (legacy) in AI: Generate SEO Blog Content, AI: Create Twitter Thread, AI: Create LinkedIn Post…: replace with OpenAI node (AI section).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Trigger: Generate Content | Schedule Trigger |
| OpenAI (legacy) AI: Generate SEO Blog Content, AI: Create Twitter Thread, AI: Create LinkedIn Post, AI: Improve Blog Content, AI: Regenerate Twitter Thread, AI: Regenerate LinkedIn Post | OpenAI node (AI section) |
Nodes used (14)
- Cron
n8n-nodes-base.cron - If
n8n-nodes-base.if - Airtable
n8n-nodes-base.airtable - Wordpress
n8n-nodes-base.wordpress - X (Formerly Twitter)
n8n-nodes-base.twitter - LinkedIn
n8n-nodes-base.linkedIn - Schedule Trigger
n8n-nodes-base.scheduleTrigger - OpenAI
n8n-nodes-base.openAi - OpenAI
@n8n/n8n-nodes-langchain.openAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Slack
n8n-nodes-base.slack - Wait
n8n-nodes-base.wait - Switch
n8n-nodes-base.switch - Merge
n8n-nodes-base.merge
From the author
Quick overview This workflow runs on schedules to generate blog and social content from Airtable ideas using OpenAI, routes drafts to Slack for approval, publishes approved content to WordPress, Twitter/X, and LinkedIn, and regenerates rejected drafts for…