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?