Automate social media content creation & publishing with AI & human approval flow
Ready for 3.0What this workflow does
This AI workflow has 34 nodes and runs on a schedule (every minute) (plus 2 other triggers). Along the way it connects LinkedIn, OpenAI, Google Sheets and X (Formerly Twitter) and 1 more. It also calls api.thehive.ai and upload.twitter.com over HTTP.
How it runs
Trigger: On a schedule (every minute) (plus 2 other triggers).
- Get Topic + Img Desc (Google Sheets): uses Google Sheets
- Get Content + Image Prompt (Google Sheets): uses Google Sheets
- Get Post Data (Google Sheets): uses Google Sheets
- Prompt Generate (OpenAI): uses OpenAI
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Split Data (Code): runs custom JavaScript code
- Append Content + Img Prompt (Google Sheets): append or update
- Split Items (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Loop (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 21 more steps. See the full node list below.
Services it uses
HTTP calls to: api.thehive.ai, upload.twitter.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- LinkedIn
n8n-nodes-base.linkedIn - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenAI
@n8n/n8n-nodes-langchain.openAi - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - X (Formerly Twitter)
n8n-nodes-base.twitter - Edit Fields (Set)
n8n-nodes-base.set - Facebook Graph API
n8n-nodes-base.facebookGraphApi - Code
n8n-nodes-base.code
From the author
✅ What problem does this workflow solve? Managing content for multiple social media platforms manually is time-consuming and error-prone. This workflow automates content creation, image generation, approval flows, and publishing for LinkedIn, Twitter (X), and…