Generate content strategy reports analyzing Reddit, YouTube & X with Gemini
### **Description**
This workflow provides a powerful AI assistant for content creators, book editors, and marketers. It automates the collection and analysis of trending discussions from Reddit, YouTube, and X (Twitter), generating insightful topic reports. This frees you from hours of tedious data compilation, allowing you to make faster, more accurate topic decisions based on deep AI analysis.
### **How it works**
This workflow simulates the complete research process of a strategic editor:
1. **Initiate & Collect**: A user submits a keyword via a public Form Trigger. The workflow then automatically fetches relevant, trending content in parallel from the official APIs of Reddit, YouTube, and X (Twitter).
2. **Multi-stage AI Processing & Analysis**: The workflow utilizes a layered AI pipeline to process the data.
* First, a lightweight Gemini model in the `AI Pre-filter Content` node rapidly screens the vast amount of content to filter out noise.
* Next, a more powerful Gemini Pro model in the `AI Deep Analysis` node performs a detailed, structured analysis on each high-value item, extracting summaries, sentiment, and key arguments.
* Finally, a "strategist" AI model in the `AI Synthesize Final Report` node aggregates all analyses to generate the comprehensive final topic report in HTML.
3. **Multi-Channel Report Distribution**: The workflow distributes the final report to multiple channels based on pre-defined templates. The `Send Gmail Report` node sends the complete HTML report. The `Send Feishu Notification` node sends a concise summary card to a group chat. Meanwhile, the `Archive to Google Sheets` node archives key data.
### **Setup Steps**
This workflow takes approximately 20-30 minutes to set up, with most of the time spent connecting your accounts.
1. **Connect Your API Accounts**: In the n8n `Credentials` section, you will need to prepare and connect credentials for the following services:
* **Google**: For the Gemini AI model, Gmail sending, and Google Sheets archiving. This requires a Google Cloud API Key and OAuth2 credentials.
* **Reddit**: For fetching Reddit posts. This requires a Reddit account with OAuth2 configured in n8n to allow searches.
* **YouTube**: For collecting YouTube videos. You'll need to enable the YouTube Data API v3 in your Google Cloud Console and get an API Key.
* **Twitter**: For the official Twitter node, requiring a free developer account and an App with v2 API access.
2. **Configure Output Channels**: In the final nodes (`Send Gmail Report`, `Send Feishu Notification`, `Archive to Google Sheets`), update the recipient email address, the Feishu bot's Webhook URL, and the target spreadsheet ID to match your own.
3. **Activate and Share the Trigger**: Activate the workflow. The first `Form Trigger` node will automatically generate a public URL. Share this link with your team members to let them start using the tool.
