I make content about AI products and industry trends, and honestly, a big chunk of the job is repetitive. I collect recent info, look for an angle, draft a script, dump everything into a spreadsheet, and then turn whatever survives into a video.
Doing that by hand every day got old fast, because half my time went into moving the same information between tools before I could even start the actual creative part. Most of those steps felt predictable, so at some point I figured I might as well connect them with n8n. The goal was simple enough: collect data, generate topics, write a script, and get everything ready for video production. And the workflow worked — it's just that the content didn't always work with it.
What I built
The first part of the workflow pulls information from the sources I normally use for research, and that data goes to an AI model which picks out possible topics and drafts an angle for each one before everything lands in a spreadsheet. So instead of opening ten websites and copy-pasting into a doc, I just scroll through one sheet where each row already has the source material plus a possible direction. Once I pick a topic, the next stage drafts a script, and originally I wanted that draft to go straight into production — the dream pipeline looked like this: research → topic selection → script → video.
