Generate YouTube Content Ideas from Video Analysis with Dumpling AI and GPT-4o

Description

Who's it for

This template is perfect for YouTube creators, content marketers, and social media managers who want to turn existing videos into fresh, high-performing content ideas—automatically. It’s ideal if you want to save time brainstorming and focus on publishing videos that your audience actually wants.

What it does

This workflow watches a Google Sheet for new YouTube video links. For each new video, it fetches the transcript and top comments using Dumpling AI, then sends that data along with the original search topic to GPT-4o.

GPT-4o returns 3–5 new content ideas based on:
What was discussed in the video
What people are searching for
What viewers are saying in the comments

Each idea is saved to another Google Sheet and also sent to your email.

How it works

Trigger: Watches for new rows in the "YouTube Finds" sheet
Transcript & Comments: Sends video URL to Dumpling AI to fetch transcript and comments
Merge & Format: Cleans and aggregates comments into one input
AI Prompting: GPT-4o analyzes transcript, topic, and comments to suggest ideas
Output: Splits and saves the results to a "YouTube Content Idea" sheet and emails them

Requirements

🧠 OpenAI API Key stored securely in credentials
🤖 Dumpling AI API Key stored as HTTP header credentials
📄 Google Sheets with the following setup:

Input Sheet ("YouTube Finds")
Video Link
search topic

Output Sheet ("YouTube Content Idea")
title
whyGoodIdea
engagementPotential

How to customize

You can:
Change the number of ideas returned by GPT-4o
Adjust the AI prompt to reflect your niche (e.g. education, tech, travel)
Add an approval step before sending the email
Extend it to post ideas directly into Trello, Notion, or Airtable

> This workflow gives you an automated content strategist working 24/7—turning every YouTube upload into a launching pad for future content.