Library / Content Writing & Generation
Content Writing & Generation
Convert YouTube videos into LinkedIn carousels with Gemini, Telegram and Sheets
Runs on manual trigger for a pasted YouTube URL, fetches the transcript, generates an 8-slide carousel and caption with Gemini, scores the caption, and sends the result via Telegram.
What it does
## Turn YouTube videos into LinkedIn carousels with Gemini and Telegram ### How it works Paste any YouTube URL and execute. The workflow extracts the video ID, pulls the full transcript via Supadata, and falls back to the video title and description from the YouTube API when no transcript exists. Gemini converts the content into an 8-slide LinkedIn carousel (hook, insights, CTA), and a validation step repairs malformed JSON in a self-healing loop. A second Gemini pass writes the LinkedIn caption and hashtags, then a virality gate scores the caption from 1 to 10 — anything below 8 is automatically rewritten and re-scored until it passes. The finished package (caption + slide-by-slide copy) is sent to Telegram and email, a cover image is generated for the first slide, and every run is logged to Google Sheets. ### Setup steps - Replace videoUrl in the Set node with any YouTube video URL. - Add a Supadata API key (free tier) as an HTTP Header Auth credential with header name x-api-key. - Add a YouTube API key as a YouTube credential (only used for the description fallback). - Add a Google Gemini API key for the Gemini nodes. - Create a Telegram bot with @BotFather, add the token, and set the chat ID in both Telegram nodes. - Add SMTP credentials in the Email node and set the recipient address. - Connect Google Sheets credentials and replace YOUR_GOOGLE_SHEET_ID; the Carousels sheet needs columns: Date, Video ID, Slide Count, Virality Score, Status. ### Customization Change the slide count, caption style, virality threshold, image prompt style, destinations (Telegram, email, Slack), or log columns. Works with any language — the carousel language follows the video content.
The steps
- When Clicking 'Test Workflow'
- Paste YouTube Video URL
- Extract Video ID
- Fetch Video Transcript
- Transcript Found?
- Get Video Details (Fallback)
- Prepare Transcript
- Prepare Fallback Content
- Combine Content Source
- Generate 8-Slide Carousel
- Validate Carousel JSON
- Is Carousel Valid?
- Repair Malformed Carousel JSON
- Write Caption and Hashtags
22 steps in total.
Similar automations
Files & Cloud StorageConvert Instagram carousels into TikTok and Reels videos with ffmpeg and SocialRobot26 stepsForms & SurveysTurn articles into Instagram and LinkedIn carousels with GenMagic, Google Drive and10 stepsSocial Media PublishingGenerate TikTok and Instagram Carousels with GPT-Image-1 and Auto-Post28 stepsForms & SurveysCreate Instagram and Facebook carousels from articles with Claude, OpenAI and Slack64 steps