AI Social Media Content Curator for Hacker News GitHub Projects

Unlock Automated Social Media Content Creation with this AI Agent

This AI Agent automates the entire process of discovering trending GitHub projects on Hacker News, crafting engaging social media posts using OpenAI, and distributing them across your Twitter (X) and LinkedIn profiles. It's designed for tech-focused solopreneurs, founders, and CTOs who want to maintain an active and relevant social media presence with minimal manual effort.

How it Works

The agent periodically crawls Hacker News, specifically looking for discussions pointing to GitHub repositories. For each new repository found, it visits the GitHub page to gather more details. This information, along with the project's title and URL, is then fed to an OpenAI model (e.g., GPT-4o-mini) which generates optimized posts for both Twitter and LinkedIn. Before posting, it sends a notification via Telegram for optional review. Finally, it posts the content and updates an Airtable base to keep track of shared items, preventing duplicates.

Key Features & Benefits

• Automated Content Discovery: Continuously monitors Hacker News for fresh GitHub projects, saving you hours of manual searching.
• AI-Powered Content Generation: Leverages OpenAI's LLMs (specifically GPT-4o-mini in this template) to create compelling, context-aware posts tailored for Twitter and LinkedIn, ensuring your content is engaging and informative.
• Multi-Platform Distribution: Seamlessly posts to both Twitter (X) and LinkedIn, expanding your reach.
• Duplicate Prevention & Tracking: Integrates with Airtable to log all posted content, ensuring you don't share the same project multiple times and providing a clear overview of your activity.
• Scheduled Operation: Runs automatically on a configurable schedule, keeping your social media feeds consistently updated.
• Human-in-the-Loop Notification: Sends a Telegram message with the generated posts before publishing, allowing for a quick review or intervention if needed.
• Error Handling: Includes basic checks to ensure content generation is successful and filters out errored items.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key with access to a suitable model (e.g., gpt-4o-mini, gpt-4).
• Airtable account and a Personal Access Token.
• Twitter (X) account with Developer Portal access for API credentials (or suitable n8n credential setup).
• LinkedIn account with permissions to post on your behalf (configured in n8n).
• Telegram Bot Token and your Chat ID for receiving notifications.

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure the 'Schedule Trigger' node to define how often the workflow should run (e.g., every 6 hours).
4. In the 'Generate Content' (OpenAI) node:
   • Select or add your OpenAI API credential.
   • Ensure the desired model (e.g., 'gpt-4o-mini') is selected. You can customize the system and user prompts to refine the AI's output.
5. Configure the Airtable nodes ('Search Item', 'Create Item', 'Update X Status', 'Update L Status'):
   • Add your Airtable Personal Access Token credential.
   • Enter your Airtable Base ID and Table ID. The table should have fields like 'Post' (Text, for Hacker News Post ID), 'Title' (Text), 'Url' (URL), 'Tweet' (Long Text), 'LinkedIn' (Long Text), 'TDone' (Checkbox/Boolean for Twitter posted), 'LDone' (Checkbox/Boolean for LinkedIn posted).
6. Configure the 'Ping Me' (Telegram) node:
   • Select or add your Telegram API credential (Bot Token).
   • Enter your 'Chat ID' to receive notifications.
7. Configure the 'X' (Twitter) node:
   • Select or add your Twitter API credential.
8. Configure the 'LinkedIn' node:
   • Select or add your LinkedIn API credential.
9. Review Python code in 'Extract Meta' and JS code in 'Filter Unposted Items' and 'Validate Generate Content'. These are generally pre-configured for the task but can be tweaked if you have specific needs.
10. Activate the workflow. Monitor its first few runs to ensure posts are generated and published as expected.