Turn Any Podcast Episode Into a LinkedIn Newsletter Article Automatically

Built with n8n
1

Hey n8n community!

Sharing a workflow I built using WayinVideo API and GPT-4o-mini that automatically turns any podcast or video episode into a full LinkedIn newsletter article — saved to Google Sheets as a draft ready to review and publish.

What Problem This Solves

You record a podcast episode. You know there is a great LinkedIn article inside it. But writing it from scratch means watching the whole thing again, taking notes, and then writing. That takes hours.

This workflow takes the episode URL, transcribes the full audio with speaker labels, and writes a complete LinkedIn article from the actual content — headline, body, five key takeaways, and hashtags — all in one run.

How It Works

1. Form — collects five things:

  • Podcast or video URL (YouTube, Zoom, Vimeo, Loom etc.)
  • Episode title
  • Host and guest names
  • Target audience
  • Your preferred LinkedIn tone (professional, casual, data-driven etc.)

2. HTTP Request — Submit to WayinVideo — sends the video URL to WayinVideo Transcription API. It transcribes the full episode with speaker labels and timestamps — no file size limits, no downloading needed

3. Wait 60 Seconds — gives WayinVideo time to start processing

4. HTTP Request — Poll Results — fetches the transcript using the task ID returned in step 2

5. IF Node — checks if transcription is complete. If not ready, waits 30 more seconds and checks again. Loops until status = SUCCEEDED

6. Code Node — formats each transcript segment with speaker label and timestamp — ready for GPT to read

7. AI Agent — GPT-4o-mini — reads the full transcript and writes a complete LinkedIn article following 7 readability rules — short paragraphs, strong hook, no filler, ends with a CTA

8. Code Node — parses the AI output and extracts headline, article body, key takeaways, and hashtags into separate fields

9. Google Sheets — saves everything as one row with Status set to Draft

What Gets Saved to Google Sheets

Each episode generates one row with:

  • Episode title and video URL
  • Episode duration in minutes
  • LinkedIn headline
  • Full article body (400–600 words)
  • Five key takeaways
  • Hashtags
  • Word count
  • Generated date
  • Status — Draft

Setup Steps

  1. Add your WayinVideo API key in the two HTTP Request nodes — Submit Transcription and Get Transcript Results — Video Transcription API - WayinVideo API Docs
  2. Add your OpenAI API key in the GPT-4o-mini node
  3. Connect your Google Sheets OAuth2 credential
  4. Replace YOUR_GOOGLE_SHEET_ID with your actual Sheet ID
  5. Create a sheet tab named LinkedIn Drafts with these columns:
    Podcast Title | Video URL | Episode Duration (min) | LinkedIn Headline | LinkedIn Article | Key Takeaways | Hashtags | Word Count | Generated On | Status
  6. Activate the workflow and open the Form URL

Works With

YouTube, Zoom recordings, Vimeo, Loom, TikTok — any public video URL. Non-English episodes are supported too — just change target_lang in the transcription node.

Drop a comment if you want the full workflow JSON — happy to share!

1 Like