Automation library · Content

Generate content strategy reports analyzing Reddit, YouTube & X

Started by someone submitting a form, and works across Gmail, Google Sheets, Reddit and X. It hands the judgement calls to Gemini. 31 steps, 1 branch, 1 loop or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: Gemini

Download free
31 stepsLarge: read it before trusting it with anything live
1Branch: places the flow splits
1Loop or waits
4Services it connects to

The flow

Starts it 1Model 6Logic 15Service 9

The steps in the order they run, from what starts it.

  1. 1Apify抓取x推文Http RequestService
  2. 2ScrapingBee抓取x推文Http RequestService
  3. 3twitterapi抓取x推文Http RequestService
  4. 4Form TriggerForm triggerStarts it
  5. 5Pre-filter ContentLm Chat Google GeminiModel
  6. 6Deep AnalysisLm Chat Google GeminiModel
  7. 7SynthesisLm Chat Google GeminiModel
  8. 8Analysis ParametersSetLogic
  9. 9AI Pre-filteringChain LlmModel
  10. 10AI Deep AnalysisChain LlmModel
  11. 11AI: Synthesize Final ReportAgentModel
  12. 12YouTube: Search VideosHttp RequestService
  13. 13Reddit: Search PostsRedditService
  14. 14X: Search TweetsTwitterService
  15. 15Parse AI Filter ResultsCodeLogic
  16. 16Structure Analysis ResultCodeLogic
  17. 17Format Report PayloadsSetLogic
  18. 18Split OutSplit OutLogic
  19. 19Format Reddit DataSetLogic
  20. 20Parse Twitter DataCodeLogic
  21. 21IF: Is Content RelevantIfLogic
  22. 22Aggregate: Deep Analysis ResultsAggregateLogic
  23. 23Archive DataGoogle SheetsService
  24. 24Splicing final reportSetLogic
  25. 25Send Feishu CardHttp RequestService
  26. 26Format YouTube DataSetLogic
  27. 27Merge: All SourcesMergeLogic
  28. 28Aggregate: Relevant ItemsAggregateLogic
  29. 29Handle Filter ErrorsCodeLogic
  30. 30Send HTML ReportGmailService
  31. 31Loop Over ItemsSplit In BatchesLogic

How it's built

Starts on
Someone submitting a form
Steps
31, with 1 branch, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets, Reddit, X
Model
Gemini

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Sheets, Reddit and X accounts, and a key for Gemini. You connect your own accounts after importing it; none are included.

What starts it?

It starts on someone submitting a form.

Does it use AI?

Yes. It calls Gemini. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 31 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 31 steps before you point it at anything that matters.