Automation library · Data collection

Send a weekly legal tech AI digest with OpenAI and Gemini

Started by a clock, and works across Excel, Outlook and RSS. It hands the judgement calls to Gemini and OpenAI. 24 steps: large, and worth reading before you trust it with anything live.

LargeCalls a model: Gemini, OpenAI

Download free
24 stepsLarge: read it before trusting it with anything live
0Branches: places the flow splits
0Loops or waits
3Services it connects to

The flow

Starts it 1Model 4Logic 13Service 6

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

  1. 1GPT-4o-mini ModelLm Chat Open AiModel
  2. 2Schedule TriggerSchedule triggerStarts it
  3. 3AI: Summarize ArticlesAgentModel
  4. 4Fetch Google News RSSRss Feed ReadService
  5. 5Fetch Reddit RSSRss Feed ReadService
  6. 6Fetch Hacker News RSSRss Feed ReadService
  7. 7Parse AI + Build PromptsCodeLogic
  8. 8Normalize Google NewsCodeLogic
  9. 9Normalize RedditCodeLogic
  10. 10Normalize Hacker NewsCodeLogic
  11. 11Image Prompt 1CodeLogic
  12. 12Image Prompt 2CodeLogic
  13. 13Merge SourcesMergeLogic
  14. 14Gemini Image 1Google GeminiModel
  15. 15Gemini Image 2Google GeminiModel
  16. 16Select 7 ArticlesCodeLogic
  17. 17Merge ImagesMergeLogic
  18. 18Prep Images for UploadCodeLogic
  19. 19Upload Image to WPHttp RequestService
  20. 20Collect Image URLsCodeLogic
  21. 21Attach Images to ArticlesCodeLogic
  22. 22Build Newsletter HTMLCodeLogic
  23. 23Get rowsMicrosoft ExcelService
  24. 24Send Newsletter EmailMicrosoft OutlookService

How it's built

Starts on
A clock
Steps
24
Size
Large: read it before trusting it with anything live
Connects to
Excel, Outlook, RSS
Model
Gemini, OpenAI

Questions

What does it need to run?

An n8n account, plus your own Excel, Outlook and RSS accounts, and a key for Gemini and OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

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

How long does it take to set up?

Take your time. At 24 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 24 steps before you point it at anything that matters.