🎬 Create social posts from RSS with OpenAI, LinkedIn, X, and Bluesky
⚡ 67 views · 🎬 Content Creation & Video
💡 Pro Tip — If you’re pulling LinkedIn data through HTTP requests or dealing with API restrictions, there’s a community node called ScraperNode that handles this natively. It has dedicated scrapers for profiles, companies, jobs, and people search — you just pass a URL and get structured data back.
Description
Quick overview
This workflow runs daily, reads the Hacker News frontpage RSS feed, uses OpenAI to extract key insights and ghostwrite social posts, then publishes the generated content to LinkedIn, X, and Bluesky.
How it works
- Runs every day at 08:00 using a schedule trigger.
- Fetches the latest items from the Hacker News frontpage RSS feed and keeps only the first three articles.
- Prepares a clean title, content snippet, and link for each article.
- Sends each article to OpenAI Chat Completions (gpt-4o-mini) to extract three non-obvious insights.
- Sends the insights to OpenAI Chat Completions again to generate platform-specific posts (LinkedIn, X, and Bluesky) in a defined voice and JSON format.
- Parses and clamps the generated text to length limits and then posts to LinkedIn and X while also authenticating to Bluesky and creating a Bluesky post.
Setup
- Add an OpenAI API credential for the two OpenAI Chat Completions HTTP requests.
- Add LinkedIn and X (Twitter) credentials and confirm the target posting identity/settings for each platform.
- Replace the Bluesky handle and app password in the Bluesky login request and ensure Bluesky app passwords are enabled for the account.
- (Optional) Update the RSS feed URL and the daily trigger time if you want a different source or posting schedule.
🔗 Nodes Used
HTTP Request, RSS Read, X (Formerly Twitter), LinkedIn, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File