Social media keyword analysis: topic report to Gmail an

This automation template helps find fresh, viral content ideas by analyzing activity on Reddit, YouTube, and X (Twitter) based on a user-submitted keyword. The system generates a structured HTML report with topic recommendations and delivers it via Gmail and Feishu, eliminating hours of manual research.

## Who it´s for
- Digital media editors seeking fresh publication topics
- Content strategists identifying real-time trends
- Marketers creating viral content from public discussions
- Bloggers and channel creators aiming to stay ahead of trends
- SMM teams automating social media insights collection

## What the automation does
- User submits a keyword via web form
- System scrapes content in parallel from Reddit, YouTube, and X (Twitter)
- Data is normalized and filtered for relevance using AI (Google Gemini + LangChain)
- Deep sentiment and engagement potential analysis is performed
- An HTML report with recommended topics and headlines is generated
- Report is sent via Gmail, notification delivered to Feishu
- Raw data is archived in Google Sheets

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on HTTP webhook and form_submit
- Integrations with Reddit, YouTube, X (Twitter), Gmail, Feishu, Google Sheets, ScrapingBee, Apify, twitterapi.io
- Basic textual guide for setup and adaptation

## Requirements for setup
- Active accounts in all required services (Reddit, YouTube, X, Gmail, Feishu, Google Sheets)
- API keys or access credentials for ScrapingBee, Apify, twitterapi.io
- Operational n8n instance with external API access
- Configured environment for Google Gemini and LangChain

## Benefits and outcomes
- Saves up to 10 hours per week on manual trend hunting
- Automatically detects viral topics and discussions
- Improves content planning quality with real data
- Enables weekly monitoring without extra effort
- Archives all raw data in Google Sheets for further analysis
- Sends instant notifications to Feishu for team coordination

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.