For deeper knowledge to create custom workflows, let's chat here. ๐ง This Script Turns My YouTube Video Into a Newsletter โ Automatically
Every time I upload a video, this automation:
โ Pulls my video
โ Scrapes the transcript
โ Feeds it to Gemini
โ Generates a full newsletter
โ Drops it in Gmail drafts, ready to send
Inside this video I show you:
โ
How to trigger via RSS whenever a new video goes live
โ
How to fetch transcripts using Apify
โ
How to store transcripts in Airtable for reuse
โ
How to turn the transcript into a newsletter using an LLM chain
โ
And finallyโhow to push it straight to Gmail
๐พ You can follow the whole thing step-by-step, or just download the JSON workflow from Skool and plug it straight in.
๐ฏ Bonus: This is part of a bigger setup where Iโm building a full content automation suiteโthumbnails, tweets, newsletters, blog posts, affiliate CTAsโbased on one video. Want to see that next?