Generate content strategy reports analyzing Reddit, YouTube & X with Gemini

by Sheryl · 5,870 views · created 2025-06-26 · Market Research, AI Summarization

What this workflow does

This AI workflow has 31 nodes and runs when someone submits an n8n form (“选题捕手”). Along the way it connects Reddit, X (Formerly Twitter), Google Gemini Chat Model and Gmail and 1 more. It also calls googleapis.com, api.scrapingbee.com and api.apify.com over HTTP.

How it runs

Trigger: When someone submits an n8n form (“选题捕手”).

1. Analysis Parameters (Edit Fields (Set)): sets 3 fields: keyword, search_date, analysis_id
2. YouTube: Search Videos (HTTP Request): calls googleapis.com
3. Reddit: search
4. X: Search Tweets (X (Formerly Twitter)): search
5. Split Out: splits a list into separate items
6. Format Reddit Data (Edit Fields (Set)): sets 5 fields: source_weight, source_type, content…
7. Parse Twitter Data (Code): runs custom JavaScript code
8. Format YouTube Data (Edit Fields (Set)): sets 5 fields: source_weight, source_type, content…
9. Merge: merges the data from its input branches
10. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches

…plus 17 more steps. See the full node list below.

Services it uses

RedditX (Formerly Twitter)Google Gemini Chat ModelGmailGoogle Sheets

HTTP calls to: googleapis.com, api.scrapingbee.com, api.apify.com, api.twitterapi.io

Before you upgrade to n8n 3.0

Nodes used (16)

• HTTP Requestn8n-nodes-base.httpRequest
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• n8n Form Triggern8n-nodes-base.formTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Redditn8n-nodes-base.reddit
• Split Outn8n-nodes-base.splitOut
• X (Formerly Twitter)n8n-nodes-base.twitter
• Coden8n-nodes-base.code
• Mergen8n-nodes-base.merge
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Ifn8n-nodes-base.if
• Aggregaten8n-nodes-base.aggregate
• AI Agent@n8n/n8n-nodes-langchain.agent
• Gmailn8n-nodes-base.gmail
• Google Sheetsn8n-nodes-base.googleSheets

From the author

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…

View the original on n8n.io → Check your own copy