Extract Trends, Auto-Generate Social Content with AI, Reddit, Google & Post

# 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 and Google Trends - Scores trends for relevance using OpenAI. - Generates content for Twitter, 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, 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 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 1. **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. 2. **Configure Credentials**: - Add API credentials in n8n's Credentials section for Reddit, SerpApi, OpenAI, Twitter, 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 }}`. 3. **Set Up Google Sheets** with the following columns (exact column names are case-sensitive): - Timestamp | Trend | Score | BrandVoice | AudienceMood | 4. **Customize Nodes**: - **OpenAI Nodes** (`Trend Relevance Scoring`, `Generate Social Media Content`): Update the model (e.g., `gpt-4`) and prompt as needed. - **HTTP Request Nodes** (`Post to Twitter`, `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). 5. **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 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 Twitter. *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.

Platform

n8n

Category

Marketing

Price

Free

Creator

Immanuel

• if
• set
• code
• wait
• gmail
• merge
• reddit
• webhook
• linkedIn
• stickyNote