Cross-post RSS feed articles to X, LinkedIn and Facebook with PostgreSQL
Ready for 3.0What this workflow does
This workflow has 21 nodes and runs on a schedule (every minute). Along the way it connects Postgres, X (Formerly Twitter), LinkedIn and Facebook Graph API.
How it runs
Trigger: On a schedule (every minute).
- Set RSS Posting Configuration (Edit Fields (Set)): sets 14 fields: feed_urls, feed_name, dry_run…
- Build Post Configurations (Code): runs custom JavaScript code
- Initialize Post Ledger (Postgres): run a query
- Validate Post Configurations (Code): runs custom JavaScript code
- Check Configuration Validity (If): checks a condition and branches into true / false
- Create RSS Fetch Requests (Code): runs custom JavaScript code
- Summarize Config Errors (Code): runs custom JavaScript code
- Fetch Enabled RSS Feeds (RSS Read): reads an RSS feed
- Normalize for Publishing (Code): runs custom JavaScript code
- Generate Article Hash (Crypto): hashes or encrypts values
…plus 10 more steps. See the full node list below.
Services it uses
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)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Postgres
n8n-nodes-base.postgres - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - RSS Read
n8n-nodes-base.rssFeedRead - Crypto
n8n-nodes-base.crypto - Switch
n8n-nodes-base.switch - X (Formerly Twitter)
n8n-nodes-base.twitter - LinkedIn
n8n-nodes-base.linkedIn - Facebook Graph API
n8n-nodes-base.facebookGraphApi
From the author
Quick overview This workflow reads new RSS articles on a configurable schedule and turns them into ready-to-publish posts for X, LinkedIn, and Facebook. Each publication is recorded in PostgreSQL to prevent duplicates. How it works 1. Runs on a 15-minute…