Zum Inhalt springen
NEUMarktplatz und dein Team: Verkaufe, was du baust, und bekomm Pläne und Änderungen, die getestet sind, bevor du sie siehst. Neuigkeiten ansehen

Bibliothek / Texterstellung & Content-Generierung

Texterstellung & Content-Generierung

YouTube-Videos mit Gemini, Telegram und Sheets in LinkedIn-Karussells umwandeln

Wird manuell für eine eingefügte YouTube-URL gestartet, ruft das Transkript ab, erstellt mit Gemini ein Karussell mit 8 Folien und eine Bildunterschrift, bewertet die Bildunterschrift und sendet das Ergebnis über Telegram.

Was sie bewirkt

## 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.

Die Schritte

  1. When Clicking 'Test Workflow'
  2. Paste YouTube Video URL
  3. Extract Video ID
  4. Fetch Video Transcript
  5. Transcript Found?
  6. Get Video Details (Fallback)
  7. Prepare Transcript
  8. Prepare Fallback Content
  9. Combine Content Source
  10. Generate 8-Slide Carousel
  11. Validate Carousel JSON
  12. Is Carousel Valid?
  13. Repair Malformed Carousel JSON
  14. Write Caption and Hashtags

Insgesamt 22 Schritte.

Ähnliche Automatisierungen