The n8n workflow itself is free, but you need active paid accounts for Dumpling AI and OpenAI API usage.

What do I need to get started?

A Google Sheet with 'link' and 'blog post' columns, Dumpling AI API access, OpenAI key, and Gmail OAuth2 credentials.

How do I import this into n8n?

Copy the workflow JSON into n8n via the import feature, then connect the listed credentials and update the sheet ID.

Turn YouTube Transcripts into Newsletter Drafts using Dumpling AI + GPT-4o

Verified

Converts YouTube links from Sheets into AI-generated newsletter drafts with email alerts.

n8nAI & LLMBeginner👁 78 views

Open template

Updated 2026-06-16

What this workflow does

This automation pulls YouTube video links from Google Sheets, fetches transcripts using HTTP requests, and applies OpenAI to produce email-ready drafts that are logged back into the sheet.

It is designed for newsletter writers, YouTube creators, and agencies who need to repurpose video content into polished drafts with minimal manual effort.

Who is this for?

Newsletter writers, marketers, and YouTube creators who repurpose video content into email drafts. Also useful for agencies and VAs batching content workflows.

What problem it solves

Manually extracting YouTube transcripts and turning them into newsletter drafts is slow and repetitive. This workflow automates the process from link to draft using AI.

Live workflow preview

Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.

Open the template on n8n to import and run it. View source template →

What it automates

Weekly video roundup

A marketer pulls new YouTube links into a sheet each Monday and gets polished newsletter drafts by end of day without manual transcription.

Creator email follow-ups

A YouTuber adds video URLs after publishing and receives ready-to-send email summaries for their subscriber list.

Agency content batching

A VA team processes multiple client videos in one run, logging drafts back to the shared Google Sheet for review.

How the workflow works

The 4 nodes in this automation, in order.

1Google SheetsgoogleSheets
2HTTP RequesthttpRequest
3Gmailgmail
4OpenAI@n8n/n8n-nodes-langchain.openAi

Apps & integrations used

Google SheetsHTTP RequestGmailOpenAI

How to set up Turn YouTube Transcripts into Newsletter Drafts using Dumpling AI + GPT-4o

1Connect Google Sheets, Dumpling AI (HTTP Header Auth), OpenAI, and Gmail OAuth2 credentials in n8n.
2Enter your Google Sheet ID and tab name in the two Google Sheets nodes.
3Add YouTube links to the 'link' column; leave 'blog post' empty for new rows.
4Review or edit the system prompt inside the GPT-4o node for tone and structure.
5Set the Gmail node recipient address and subject line.
6Run manually or add a Schedule node to trigger on a recurring basis.

How to customize this workflow

→Swap GPT-4o for GPT-4 or Claude via the OpenAI node.
→Change trigger from manual to Schedule or Webhook for new sheet rows.
→Add a Notion or Airtable node after the draft is created.
→Insert a filter to skip videos longer than a chosen duration.