🚀 New Video: Create an AI Agent to Automate your Blog Posts on n8n (Self-Learning)

Joanna Stewart

May '25 • YouTube Resources 🚀

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?

2 comments

Luke's AI Group

skool.com/ai-automation-hub-5735

A community about using the latest AI tools and AI Automations.

AI Automations by Jack

Vibe Coding Academy

Bring people together around your passion and get paid.