Skip to main content

Turn YouTube transcripts into newsletter drafts using Dumpling AI + GPT-4o

Workflow preview

Workflow preview
100%
Turn YouTube transcripts into newsletter drafts using Dumpling AI + GPT-4o preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

What this workflow does This workflow turns YouTube video links into ready to edit newsletter drafts using Dumpling AI and GPT 4o. It reads new video URLs from a Google Sheet, extracts their tra...

Best for

  • Content Creation automation workflows
  • Multimodal AI automation workflows
  • intermediate n8n builders looking for reusable templates

Tools used

n8n-nodes-base.manualtrigger, n8n-nodes-base.googlesheets, n8n-nodes-base.splitinbatches, n8n-nodes-base.httprequest, @n8n/n8n-nodes-langchain.openai, n8n-nodes-base.gmail, n8n-nodes-base.stickynote

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Yang.

Original n8n.io source

1.1 Workflow description

Title
Turn YouTube transcripts into newsletter drafts using Dumpling AI + GPT-4o
Workflow name
Turn YouTube transcripts into newsletter drafts using Dumpling AI + GPT-4o

đź§ľ What this workflow does

This workflow turns YouTube video links into ready-to-edit newsletter drafts using Dumpling AI and GPT-4o. It reads new video URLs from a Google Sheet, extracts their transcripts, summarizes them into email-friendly content, and logs the finished draft back into the same sheet. An email notification is also sent to alert the user once each draft is created.


👤 Who is this for

  • Newsletter writers or marketers repurposing video content
  • YouTube creators building email follow-ups from videos
  • Agencies or VAs batching social → email content
  • Automation users streamlining content workflows

⚙️ How to set up

âś… Requirements

  • Google Sheet with the following columns:
    • link — YouTube video URL
    • blog post — for saving the generated newsletter draft
  • Active accounts for:
    • Dumpling AI (API for YouTube transcripts)
    • OpenAI GPT-4 or GPT-4o
    • Google Sheets
    • Gmail (OAuth2 credential)

đź”§ Setup steps

  1. Connect all credentials using n8n's Credential Manager:

    • Google Sheets (OAuth2)
    • Dumpling AI (via HTTP Header Auth)
    • OpenAI
    • Gmail
  2. Update the sheet ID and tab name in both Google Sheets nodes.

  3. Customize the GPT-4o prompt (optional):

    • Located in the “GPT-4o: Write Newsletter Draft from Transcript” node
    • You can edit tone, structure, and audience targeting in the system message
  4. Verify email recipient in the Gmail node and update if needed.


đź§  How it works

  1. The workflow is triggered manually or on schedule.
  2. It pulls YouTube links without drafts from the sheet.
  3. Each video’s transcript is fetched using Dumpling AI.
  4. GPT-4o summarizes the transcript into a clean, friendly newsletter format.
  5. The draft is written back to the same row in Google Sheets.
  6. An email is sent to notify the user that the draft is ready.

🛠️ Customization ideas

  • Send finished drafts to Notion or Airtable instead of Sheets
  • Generate social media posts from the same transcript
  • Add automatic review steps using GPT scoring or editing
  • Trigger this on new form submissions or YouTube uploads instead

This is a fast, AI-powered way to turn long-form video content into clean, polished newsletters — ready to share or schedule with minimal editing.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Manual Trigger: Start Workflow

Type / Role
n8n-nodes-base.manualTrigger - manualTrigger
Config choices
Version 1

Block 2 - Read YouTube Links from Google Sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 3 - Loop: Process Each YouTube Link

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 4 - Dumpling AI: Get YouTube Transcript

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 5 - GPT-4o: Write Newsletter Draft from Transcript

Type / Role
@n8n/n8n-nodes-langchain.openAi - openAi
Config choices
Version 1.8

Block 6 - Log Newsletter Draft to Google Sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 7 - Send Email Notification When Draft is Ready

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.1

Block 8 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Turn YouTube transcripts into newsletter drafts using Dumpling AI + GPT-4o
Complexity intermediate
Nodes 8
Categories Content Creation, Multimodal AI
Author Yang
Published 08 Jul 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/5798/5798.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Turn YouTube transcripts into newsletter drafts using Dumpling AI + GPT-4o do?

What this workflow does This workflow turns YouTube video links into ready to edit newsletter drafts using Dumpling AI and GPT 4o. It reads new video URLs from a Google Sheet, extracts their tra...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Content Creation, Multimodal AI use case.