LinkedIn and Reddit integration

Extract Trends and Auto-Generate Social Media Content with OpenAI, Reddit, and Google Trends: Approve and Post to Instagram, TikTok, and More Description What Problem Does This Solve? 🛠️ This workflow automates trend extraction and social media content creation for businesses and marketers. It eliminates manual trend research and content generation by fetching trends, scoring them with AI, and posting tailored content to multiple platforms. Target audience: Social media managers, digital marketers, and businesses aiming to streamline content strategies. What Does It Do? 🌟 Fetches trending topics from Reddit, X and Google Trends Scores trends for relevance using OpenAI. Generates content for Twitter/X, LinkedIn, Instagram and Facebook Posts to supported platforms Stores results in Google Sheets for tracking Key Features 📋 Real-time trend fetching from Reddit and Google Trends. AI-driven trend scoring and content generation (OpenAI). Automated posting to Twitter/X, LinkedIn, Instagram, and Facebook. Persistent storage in Google Sheets. Setup Instructions Prerequisites ⚙️ n8n Instance**: Self-hosted or cloud n8n instance. API Credentials**: Reddit API: Client ID and secret from Reddit. SerpApi (Google Trends): API key from SerpApi, stored in n8n credentials OpenAI API: API key with GPT model access. Twitter/X API: OAuth 1.0a credentials with write permissions. LinkedIn API: OAuth 2.0 credentials with w_organization_social scope. Instagram/Facebook API: Meta Developer app with posting permissions. Google Sheets API: Credentials from Google Cloud Console. Installation Steps 📦 Import the Workflow: Copy the workflow JSON from the "Template Code" section below. Import it into n8n via "Import from File" or "Import from URL". Configure Credentials: Add API credentials in n8n’s Credentials section for Reddit, SerpApi, OpenAI, Twitter/X, LinkedIn, Instagram/Facebook, and Google Sheets. Assign credentials to respective nodes. For example: In the Fetch Google Trends node (HTTP Request), use n8n credentials for SerpApi instead of hardcoding the API key. Example: Set the API key in n8n credentials as SerpApiKey and reference it in the node’s query parameter: api_key={{ $credentials.SerpApiKey }}. Set Up Google Sheets with the following columns (exact column names are case-sensitive) -Timestamp | Trend | Score | BrandVoice | AudienceMood | Customize Nodes: OpenAI Nodes** (Trend Relevance Scoring, Generate Social Media Content): Update the model (e.g., gpt-4o) and prompt as needed. HTTP Request Nodes** (Post to Twitter/X, Post to LinkedIn, etc.): Verify URLs, authentication, and payloads. Brand Voice/Audience Mood**: Adjust Prepare Trend Scoring Input for your desired brand_voice (e.g., "casual") and audience_mood (e.g., "curious"). Test the Workflow: Fetch Reddit Trends to Store Selected Trends- to score and store trends. Retrieve Latest Trends to end) to generate and post content Check Google Sheets for posting statuses How It Works High-Level Steps 🔍 Fetch Trends**: Pulls trends from Reddit,X and Google Trends. Score Trends**: Uses OpenAI to score trends for relevance. Generate Content**: Creates platform-specific social media content. Post Content**: Posts to LinkedIn, Facebook or X Detailed descriptions are available in the sticky notes within the workflow screenshot above. Node Names and Actions Trend Extraction and Scoring Daily Trigger Idea: Triggers the workflow daily. Set Default Inputs: Sets default brand_voice and inputs. Fetch Reddit Trends: Fetches Reddit posts. Extract Reddit Trends: Extracts trends from Reddit. Fetch Google Trends: Fetches Google Trends via SerpApi. Extract Google Trends2: Processes Google Trends data. Fetch Twitter Mentions: Fetches Twitter mentions. Translate Tweets to English: Translates tweets. Fix Tweet Translation Output: Fixes translation format. Detect Audience Mood: Detects audience mood. Fix Audience Mood Output: Fixes mood output format. Analyze News Sentiment: Analyzes news sentiment. Combine Data (Merge): Merges all data sources. Merge Items into Single Item: Combines data into one item. Combine Trends and UGC: Combines trends with UGC. Prepare Trend Scoring Input: Prepares data for scoring. Trend Relevance Scoring: Scores trends with OpenAI. Parse Trend Scores: Parses scoring output. Store Selected Trends: Stores trends in Google Sheets. Content Generation and Posting Retrieve Latest Trends: Retrieves trends from Google Sheets. Parse Retrieved Trends: Parses retrieved trends. Select Top Trends: Selects the top trend. Generate Social Media Content: Generates platform-specific content. Parse Social Media Content: Parses generated content. Generate Images: Generates images for posts (if applicable). -Handle Approvals/Rejection before Posting Post to Instagram: Posts to Instagram. Post to Facebook: Posts to Facebook. Post to LinkedIn: Posts to LinkedIn. Customization Tips Add Trend Sources** 📡: Include more sources (e.g., Instagram trends) by adding nodes to Combine Data (Merge). Change Content Tone** ✍️: Update the Generate Social Media Content prompt for a different tone (e.g., "humorous"). Adjust Schedule** ⏰: Modify Daily Trigger Idea to run hourly or weekly. Automate TikTok/YouTube** 🎥: Add video generation (e.g., FFMPEG) to post TikTok and YouTube Shorts

Turn your blog into a set-and-forget content engine: every new article is instantly repurposed into channel-specific social posts with visuals, keeping your brand visible on LinkedIn, X, and Reddit without extra copywriting time. Perfect for lean marketing teams who want consistent, always-on distribution from a single source of content. How it works • Watches your blog RSS feed (or receives a single URL) and detects new articles. • Saves each post in Postgres so every article is only processed once. • Fetches the article HTML, extracts the main body content and sends it to OpenAI (GPT-4.1). • OpenAI creates platform-optimized copy: 1 LinkedIn post, 1 X/Twitter post, 1 Reddit post + image prompts. • Generates on-brand images with OpenAI and publishes everything automatically to LinkedIn, X, and Reddit. • You can also trigger it manually or via webhook whenever you want to push a specific campaign. Setup Steps • Time: around 20–40 minutes for someone familiar with n8n and the platforms. • Create a Postgres table “rss_items” with fields: guid (PRIMARY KEY), title, link, published_at. • Add credentials in n8n for: – Postgres – OpenAI – LinkedIn OAuth2 – X/Twitter OAuth2 + OAuth1 (for media upload) – Reddit OAuth2 • In the RSS node, set your blog feed URL (for example: https://yourblog.com/feed). • In the webhook node, confirm the URL/path you want external tools or other workflows to call with a “link” field. • Run the manual trigger with one test blog URL to verify: – Article content is extracted correctly. – AI returns LinkedIn/X/Reddit posts and image prompts. – Posts and images appear correctly on all social accounts. • Once tests look good, enable the Schedule Trigger so Blog2Social AI runs automatically at your chosen interval.

Reddit Pain Point to LinkedIn Content Automation Auto-discover real marketing problems and create viral LinkedIn content automatically This workflow transforms scattered Reddit discussions into a systematic lead generation machine by discovering actual marketing problems businesses face and automatically converting them into authoritative LinkedIn content that attracts qualified prospects. Overview This workflow handles the complete pain point discovery and content creation process using advanced AI analysis and automation. It manages Reddit API authentication, multi-source community monitoring, intelligent problem identification, solution development, and LinkedIn publishing with built-in error handling and content optimization for maximum engagement. Core Function: Real-time market intelligence that transforms Reddit conversations into high-converting LinkedIn content, positioning you as the expert who understands and solves specific business problems in your target industries. Key Capabilities Real-time pain point discovery** - Monitor 10+ specialized B2B subreddits for actual marketing problems being discussed right now Multi-industry intelligence** - Track Dentistry, Beauty, Accounting, Real Estate, Lawyer, Ecommerce, HR, Online Education, Coaching, and Interior Design sectors simultaneously AI-powered problem translation** - GPT-4.1 mini converts technical Reddit complaints into clear business problems with realistic context Solution architecture** - Automatically proposes specific automation solutions with viability scoring and ROI estimates LinkedIn content automation** - Gemini 2.5 Pro creates Spanish PYME-focused posts with professional imagery via Freepik Seedream V4 Compound intelligence** - System learns and improves, building a comprehensive database of market problems and solutions over time Authority positioning** - Creates content that makes prospects think "this person understands exactly what we're facing" Tools Used n8n**: The automation platform orchestrating both discovery and content creation systems Reddit API**: Direct access to community discussions and pain point identification OpenRouter**: Gateway to advanced AI models (GPT-4.1 mini, Gemini 2.5 Pro) GPT-4.1 mini**: Lightning-fast pain point detection and solution architecture Gemini 2.5 Pro**: Advanced copywriting and visual prompt creation SerpAPI**: Real-time market research and trend integration Freepik API**: Ultra-realistic business imagery generation with Seedream V4 Google Sheets**: Smart knowledge base for pain point storage and tracking LinkedIn Business API**: Professional content publishing and distribution How to Install Setup Time: 20-25 minutes for complete configuration Import the Workflow: Download the .json file and import it into your n8n instance Configure Reddit Access: Set up Reddit OAuth2 credentials for community monitoring Set Up AI Processing: Add your OpenRouter API key for GPT-4.1 mini and Gemini 2.5 Pro access Configure Market Research: Add SerpAPI credentials for real-time trend integration Set Up Image Generation: Configure Freepik API access for professional imagery Configure LinkedIn Publishing: Set up LinkedIn Business API for automated posting Create Knowledge Base: Copy the provided Google Sheets template and configure access Test Both Systems: Run research cycle and content creation independently Deploy Automation: Activate schedules (research every 10 days, content daily 9:30 AM) Use Cases Marketing Agencies: Discover client industry problems automatically and create content that demonstrates deep market understanding, positioning your agency as the one that "gets" specific industry challenges. Automation Consultants: Identify businesses struggling with manual processes through their Reddit discussions, then create educational content showcasing relevant automation solutions that attract pre-qualified leads. Business Coaches: Build authority through market insight by addressing real problems business owners are actively discussing, establishing credibility as the expert with solutions to specific industry challenges. Freelance Specialists: Develop niche expertise by focusing content on specific industry pain points discovered through community monitoring, enabling premium positioning and higher rates. Content Creators: Generate endless content ideas based on real market problems rather than guessing what to write about, ensuring every post addresses actual audience needs. B2B SaaS Companies: Monitor target market discussions to identify feature gaps, positioning opportunities, and create educational content that demonstrates product-market fit. Enterprise Sales Teams: Stay informed about prospect challenges through community intelligence, enabling more relevant outreach and positioning discussions. Pre-configured Google Sheets Template Knowledge Base Template Make a copy of the template to your Google Drive and update the sheet ID in the workflow nodes for proper pain point storage and retrieval. Connect with Me LinkedIn: https://www.linkedin.com/in/daniel-lianes/ Discovery Call: https://cal.com/averis/asesoria Consulting Session: https://cal.com/averis/consultoria-personalizada Was this helpful? Let me know! Your feedback is very valuable and helps me create better resources for the n8n community. Want to take automation to the next level? If you're looking to optimize your business processes or need expert help with a project, here's how I can assist you: Advisory (Discovery Call): Do you have a process in your business that you'd like to automate but don't know where to start? In this initial call, we'll explore your needs and see if automation is the ideal solution for you. Schedule a Discovery Call Personalized Consulting: If you already have a specific problem, an integration challenge, or need hands-on help building a custom workflow, this session is for you. Together, we'll find a powerful solution for your case. Book Your Consulting Session Stay Up to Date For more tricks, ideas, and news about automation and AI, let's connect on LinkedIn! Follow me on LinkedIn #n8n #automation #reddit #linkedin #ai #painpoints #seedream #contentcreation #leadgeneration #gemini #businessautomation #marketresearch #contentmarketing #socialmedia #freepik #gpt4 #productivity #entrepreneurship #pymes #averistech