News Automation: RSS to Social Media with Discord Approvals

This workflow automates news content curation and approval for social media, replacing manual news monitoring and review processes that consume 20+ hours weekly for teams managing 100+ posts monthly. It scrapes news from RSS feeds (configured via RSS_FEED_URLS), filters articles based on CONTENT_KEYWORDS and EXCLUDE_KEYWORDS, validates content, posts to a Discord channel for team approval via reactions (✅/❌), logs decisions in a Postgres database, and publishes approved content to platforms like Twitter or Instagram. Key nodes include Cron (News Trigger) for scheduled scraping every 30 minutes, RSSFeedRead (News Feed Scraper) for news collection, Function (News Content Filter) for relevance scoring, IF (News Quality Gate/Content Validator/Reaction Validator) for filtering, Webhook (Manual Content Submission/Discord Reaction Handler) for manual inputs/reactions, Set (Content Sanitizer) for formatting, Discord (Approval Bot/Approval Notification/Rejection Notification) for team interaction, Postgres (Approval Database/Approval Processor/Rejection Processor) for logging, HTTP Request (Social Media Poster) for publishing, and RespondToWebhook (Submission Success/Validation Error/Unauthorized Response) for feedback. Ideal for newsrooms, marketing teams (5-25 staff) in media or agencies ($1M-$15M revenue), it reduces curation time by 75% for 100-300 posts monthly.\n\nSaves 15 hours/week on 100+ posts, cutting curation and approval time by 75%. Suits digital media, PR firms, or content agencies. Requires Discord Bot (free), Postgres (free tier), social media API ($0-$50/month), n8n ($20/month cloud). Scalable to 1,000 posts/month; needs HTTPS.\n\nSetup Instructions:\n1. Install n8n via cloud.n8n.io or self-host (docker run -it --rm -p 5678:5678 n8nio/n8n).\n2. Create a Discord bot at discord.com/developers; add to server with MANAGE_MESSAGES permissions. Set bot token in Discord nodes.\n3. Setup Postgres at supabase.com; create table devhubconnect_content_approvals with columns: submission_id, content, target_platform, submitter, media_url, priority, status, discord_message_id, submitted_at, created_at, approved_by, approved_at, rejected_by, rejected_at. Configure in Postgres nodes.\n4. Obtain social media API keys (e.g., Twitter at developer.twitter.com); set SOCIAL_MEDIA_API_ENDPOINT and SOCIAL_MEDIA_API_TOKEN as environment variables.\n5. Configure webhooks (https://your-n8n.app/webhook/content-submission, https://your-n8n.app/webhook/discord-reactions) with header authentication. Set environment variables: RSS_FEED_URLS (e.g., 'https://feeds.reuters.com/reuters/topNews'), CONTENT_KEYWORDS (e.g., 'technology,AI,automation'), EXCLUDE_KEYWORDS (e.g., 'politics,celebrity'), DISCORD_APPROVAL_CHANNEL_ID (e.g., 'your_channel_id'), DISCORD_APPROVER_ROLES (e.g., 'admin,moderator'), DEFAULT_SOCIAL_PLATFORM (e.g., 'twitter').\n\nTesting:\n- Activate Cron node to scrape RSS feed; verify filtered news in Content Validator.\n- Submit manual POST to /content-submission with {content: 'Tech news', platform: 'twitter', submitter: 'user', media_url: 'https://example.com/image.jpg', priority: 'high'}. Check Discord message and database entry.\n- Simulate reaction with POST to /discord-reactions with {emoji: {name: '✅'}, user_id: '123', message_id: '456', channel_id: '$DISCORD_APPROVAL_CHANNEL_ID', member: {roles: ['$DISCORD_APPROVER_ROLES']}}. Verify database update and social media post.\n\nErrors:\n- 400 (invalid submission, check content/platform fields).\n- 403 (unauthorized reaction, verify DISCORD_APPROVER_ROLES).\n- 429 (rate limit, adjust HTTP Request retries).\n\nMaintenance:\n- Rotate Discord bot token quarterly.\n- Backup Postgres database weekly.\n- Monitor n8n logs for API failures or RSS feed issues.\n\nOptimization:\n- Update CONTENT_KEYWORDS and EXCLUDE_KEYWORDS for niche topics.\n- Adjust Cron schedule (e.g., every 15 minutes) for fresher news.\n- Add platform-specific formatting in Social Media Poster (e.g., Twitter character limits).", "businessValue": "Saves 15 hours/week on 100+ posts with 75% faster curation and approval", "setupTime": "60-90 minutes", "difficulty": "Advanced", "requirements": [ "Discord Bot (free, with MANAGE_MESSAGES permissions)", "Postgres DB (free tier, e.g., Supabase)", "Social media API ($0-$50/month, e.g., Twitter, Instagram)", "n8n cloud ($20/month) or self-hosted", "Stable HTTPS connection", "Environment variables: RSS_FEED_URLS (e.g., 'https://feeds.reuters.com/reuters/topNews'), CONTENT_KEYWORDS (e.g., 'technology,AI,automation'), EXCLUDE_KEYWORDS (e.g., 'politics,celebrity'), DISCORD_APPROVAL_CHANNEL_ID (e.g., 'your_channel_id'), DISCORD_APPROVER_ROLES (e.g., 'admin,moderator'), SOCIAL_MEDIA_API_ENDPOINT, SOCIAL_MEDIA_API_TOKEN, DEFAULT_SOCIAL_PLATFORM (e.g., 'twitter')" ], "useCase": "Automating news curation, approval, and social media publishing with Discord-based team oversight"