Generate and publish approved employee LinkedIn posts with OpenAI and LinkedIn
Ready for 3.0What this workflow does
This AI workflow has 30 nodes and runs on a schedule (every day) (plus 2 other triggers). Along the way it connects Gmail, Google Sheets, OpenAI and Slack. It also calls api.linkedin.com over HTTP.
How it runs
Trigger: On a schedule (every day) (plus 2 other triggers).
- Fetch Latest Blogs (RSS Read): reads an RSS feed
- Create Employee Personas (Code): runs custom JavaScript code
- Fetch Selected Post (Google Sheets): uses Google Sheets
- Limit: keeps the first few items
- Split Employee Roles (Split Out): splits a list into separate items
- Check Approval Status (If): checks a condition and branches into true / false
- Check Existing Blog (Google Sheets): uses Google Sheets
- Generate AI LinkedIn Posts (OpenAI): uses OpenAI
- Update Approved Status (Google Sheets): update
- Update Rejected Status (Google Sheets): update
…plus 17 more steps. See the full node list below.
Services it uses
HTTP calls to: api.linkedin.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 (16)
- Execute Sub-workflow
n8n-nodes-base.executeWorkflow - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - RSS Read
n8n-nodes-base.rssFeedRead - Limit
n8n-nodes-base.limit - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut - OpenAI
@n8n/n8n-nodes-langchain.openAi - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - HTTP Request
n8n-nodes-base.httpRequest - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow scans an RSS blog feed on a schedule, logs newly found posts to Google Sheets, uses OpenAI to generate role-based LinkedIn drafts, and emails approval links via Gmail; approved drafts are then published to LinkedIn and tracked in…