HumationHuman + Automation
Back to Catalog

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

YangYang
2049 views
2/3/2026
ExportZendeskTicketsCSVCustom Fields
Official Page

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

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

This n8n workflow automates the process of transforming YouTube video transcripts into newsletter drafts. It fetches video data from a Google Sheet, uses an AI model (likely GPT-4o via OpenAI) to generate content, and then sends the draft via Gmail. This workflow is ideal for content creators, marketers, or anyone looking to repurpose video content efficiently.

What it does

  1. Triggers Manually: The workflow is initiated manually by clicking 'Execute workflow'.
  2. Reads YouTube Video Data: It retrieves YouTube video URLs and potentially other relevant information from a specified Google Sheet.
  3. Loops Over Items: It processes each row (representing a YouTube video) from the Google Sheet individually.
  4. Fetches YouTube Transcript: For each YouTube video, it makes an HTTP request to an external service (likely Dumpling AI or a similar transcript API) to fetch the video's transcript.
  5. Generates Newsletter Draft with AI: It sends the fetched transcript to OpenAI (likely using GPT-4o) to generate a newsletter draft based on the transcript's content.
  6. Sends Newsletter Draft via Gmail: Finally, it sends the AI-generated newsletter draft as an email using Gmail.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance (cloud or self-hosted).
  • Google Sheets Account: A Google Sheets account with a spreadsheet containing your YouTube video data (e.g., video URLs).
  • Google Sheets Credential: An n8n credential configured for Google Sheets.
  • OpenAI API Key: An API key for OpenAI (likely for GPT-4o).
  • OpenAI Credential: An n8n credential configured for OpenAI.
  • Dumpling AI (or similar transcript API): An account or access to an API that can fetch YouTube video transcripts. This will require an HTTP Request node configuration.
  • Gmail Account: A Gmail account to send the newsletter drafts.
  • Gmail Credential: An n8n credential configured for Gmail.

Setup/Usage

  1. Import the Workflow:
    • Copy the provided JSON code.
    • In your n8n instance, go to "Workflows" and click "New".
    • Click the three dots in the top right corner and select "Import from JSON".
    • Paste the JSON code and click "Import".
  2. Configure Credentials:
    • For the "Google Sheets" node, select or create a Google Sheets credential. Ensure it has access to the spreadsheet you intend to use.
    • For the "HTTP Request" node, you will need to configure the URL and any necessary authentication (e.g., API keys, headers) for your chosen YouTube transcript service (e.g., Dumpling AI).
    • For the "OpenAI" node, select or create an OpenAI credential with your API key.
    • For the "Gmail" node, select or create a Gmail credential.
  3. Configure Nodes:
    • Google Sheets: Specify the Spreadsheet ID and Sheet Name where your YouTube video URLs are located.
    • HTTP Request: Update the URL and parameters to correctly call your chosen YouTube transcript API. You'll likely need to pass the YouTube video URL from the Google Sheet to this API.
    • OpenAI: Review and adjust the prompt for generating the newsletter draft to fit your desired tone and content structure. You will need to reference the transcript output from the previous HTTP Request node.
    • Gmail: Configure the recipient email address, subject line, and the body of the email. You'll likely use the output from the OpenAI node for the email body.
  4. Activate the Workflow: Once all configurations are complete, activate the workflow.
  5. Execute the Workflow: Click "Execute workflow" on the "Manual Trigger" node to run the workflow and start generating your newsletter drafts.

Related Templates

Generate song lyrics and music from text prompts using OpenAI and Fal.ai Minimax

Spark your creativity instantly in any chat—turn a simple prompt like "heartbreak ballad" into original, full-length lyrics and a professional AI-generated music track, all without leaving your conversation. 📋 What This Template Does This chat-triggered workflow harnesses AI to generate detailed, genre-matched song lyrics (at least 600 characters) from user messages, then queues them for music synthesis via Fal.ai's minimax-music model. It polls asynchronously until the track is ready, delivering lyrics and audio URL back in chat. Crafts original, structured lyrics with verses, choruses, and bridges using OpenAI Submits to Fal.ai for melody, instrumentation, and vocals aligned to the style Handles long-running generations with smart looping and status checks Returns complete song package (lyrics + audio link) for seamless sharing 🔧 Prerequisites n8n account (self-hosted or cloud with chat integration enabled) OpenAI account with API access for GPT models Fal.ai account for AI music generation 🔑 Required Credentials OpenAI API Setup Go to platform.openai.com → API keys (sidebar) Click "Create new secret key" → Name it (e.g., "n8n Songwriter") Copy the key and add to n8n as "OpenAI API" credential type Test by sending a simple chat completion request Fal.ai HTTP Header Auth Setup Sign up at fal.ai → Dashboard → API Keys Generate a new API key → Copy it In n8n, create "HTTP Header Auth" credential: Name="Fal.ai", Header Name="Authorization", Header Value="Key [Your API Key]" Test with a simple GET to their queue endpoint (e.g., /status) ⚙️ Configuration Steps Import the workflow JSON into your n8n instance Assign OpenAI API credentials to the "OpenAI Chat Model" node Assign Fal.ai HTTP Header Auth to the "Generate Music Track", "Check Generation Status", and "Fetch Final Result" nodes Activate the workflow—chat trigger will appear in your n8n chat interface Test by messaging: "Create an upbeat pop song about road trips" 🎯 Use Cases Content Creators: YouTubers generating custom jingles for videos on the fly, streamlining production from idea to audio export Educators: Music teachers using chat prompts to create era-specific folk tunes for classroom discussions, fostering interactive learning Gift Personalization: Friends crafting anniversary R&B tracks from shared memories via quick chats, delivering emotional audio surprises Artist Brainstorming: Songwriters prototyping hip-hop beats in real-time during sessions, accelerating collaboration and iteration ⚠️ Troubleshooting Invalid JSON from AI Agent: Ensure the system prompt stresses valid JSON; test the agent standalone with a sample query Music Generation Fails (401/403): Verify Fal.ai API key has minimax-music access; check usage quotas in dashboard Status Polling Loops Indefinitely: Bump wait time to 45-60s for complex tracks; inspect fal.ai queue logs for bottlenecks Lyrics Under 600 Characters: Tweak agent prompt to enforce fuller structures like [V1][C][V2][B][C]; verify output length in executions

Daniel NkenchoBy Daniel Nkencho
601

Auto-reply & create Linear tickets from Gmail with GPT-5, gotoHuman & human review

This workflow automatically classifies every new email from your linked mailbox, drafts a personalized reply, and creates Linear tickets for bugs or feature requests. It uses a human-in-the-loop with gotoHuman and continuously improves itself by learning from approved examples. How it works The workflow triggers on every new email from your linked mailbox. Self-learning Email Classifier: an AI model categorizes the email into defined categories (e.g., Bug Report, Feature Request, Sales Opportunity, etc.). It fetches previously approved classification examples from gotoHuman to refine decisions. Self-learning Email Writer: the AI drafts a reply to the email. It learns over time by using previously approved replies from gotoHuman, with per-classification context to tailor tone and style (e.g., different style for sales vs. bug reports). Human Review in gotoHuman: review the classification and the drafted reply. Drafts can be edited or retried. Approved values are used to train the self-learning agents. Send approved Reply: the approved response is sent as a reply to the email thread. Create ticket: if the classification is Bug or Feature Request, a ticket is created by another AI agent in Linear. Human Review in gotoHuman: How to set up Most importantly, install the gotoHuman node before importing this template! (Just add the node to a blank canvas before importing) Set up credentials for gotoHuman, OpenAI, your email provider (e.g. Gmail), and Linear. In gotoHuman, select and create the pre-built review template "Support email agent" or import the ID: 6fzuCJlFYJtlu9mGYcVT. Select this template in the gotoHuman node. In the "gotoHuman: Fetch approved examples" http nodes you need to add your formId. It is the ID of the review template that you just created/imported in gotoHuman. Requirements gotoHuman (human supervision, memory for self-learning) OpenAI (classification, drafting) Gmail or your preferred email provider (for email trigger+replies) Linear (ticketing) How to customize Expand or refine the categories used by the classifier. Update the prompt to reflect your own taxonomy. Filter fetched training data from gotoHuman by reviewer so the writer adapts to their personalized tone and preferences. Add more context to the AI email writer (calendar events, FAQs, product docs) to improve reply quality.

gotoHumanBy gotoHuman
353

Dynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution

AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) 🧠 AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative — all powered by AI logic, sir. --- 💡 Key Advantages ⚡ Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. 🧠 AI Qualification Engine An OpenAI-powered Agent evaluates the lead’s industry, region, and needs to generate a persona summary and routing rationale. 📊 Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. 💬 Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. 🔁 Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- ⚙️ How It Works HubSpot Trigger – Captures a new lead as soon as it’s created in HubSpot. Fetch Contact Data – Retrieves all relevant fields like name, company, and industry. Clean & Format Data – A Code node standardizes and structures the data for consistency. Airtable Record Creation – Logs the lead data into the “Leads” table for centralized tracking. AI Agent Qualification – The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update – Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification – Sends a real-time message tagging the rep with lead info. Gmail Notification – Sends a personalized handoff email with context and follow-up actions. HubSpot Sync – Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- 🛠️ Setup Steps Trigger Node: HubSpot → Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the “Leads” table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- 🔐 Credentials Required HubSpot OAuth2 API – To fetch and update leads. Airtable Personal Access Token – To store and update lead data. OpenAI API – To power the AI qualification and matching logic. Slack OAuth2 – For sending team notifications. Gmail OAuth2 – For automatic email alerts to assigned reps, sir. --- 👤 Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- 💬 Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular — perfect for scaling across global sales teams, sir.

MANISH KUMARBy MANISH KUMAR
113