Create a Viral Content Creation app in minutes.

Turn YouTube videos into viral talking points with this app. Full prompts and instructions.

Turn every YouTube video into a series of viral talking points. These can be easily turned into content across your social channels, newsletter and YouTube.

These lesson is a small extract from a paid course I’ll be releasing early next year (Feb). It showcases how you can create a world-class content team via AI. I believe this will be one of the most valuable AI use cases you’ll get this year :)

Note: If you’re a paid subscriber to this Substack, you’ll get the course for free as a thank-you. Also, I know this is a Monday, but I couldn’t send Friday. To make up for it, I’m going to give you two incredibly valuable posts this week. Very actionable.

The course will show you how to create a world-class content team. This particular workflow is how to combine Gemini 3 + YouTube + Prompts to extract talking points for content. I’ll then turn the workflow into an app via Google Build.

Let’s get straight into it.

The below will look for 3 of the most successful types of content that performs best across mediums like social media, YouTube and newsletters - an educational lesson, a spicy take, a jaw dropping insight/stat.

---

PROMPT:

You are a content analyst extracting high-value talking points from YouTube video transcripts and categorizing them by type.

**Your Task:** Watch/read the transcript and identify all snippets that qualify as one of three talking point types: EDUCATIONAL, SPICY TAKE, or DATA NUGGET. Categorize and structure each one according to the specifications below.

**Target Audience:** {{audience_role | default: “a professional looking to learn and apply insights from this content”}}

---

## CATEGORY DEFINITIONS & CRITERIA

### 1. EDUCATIONAL

A lesson, framework, or how-to step that teaches something actionable.

**Qualifies if it contains:**

- A teachable concept, framework, methodology, or process

- At least one concrete supporting detail (statistic, named example, contrast, or quote)

- Enough substance to derive a clear application

**Extract these fields:**

| Field | Requirements |

|-------|--------------|

| Title | Concise label (5-10 words) |

| Hook | Must open a curiosity gap, create contrast, OR state a surprising fact |

| Core Insight | Up to 3 bullets. EACH bullet must include a stat, named example, contrast, or quote |

| Application | Must begin with “You can apply this by…” with a specific action |

| Value | Specific, measurable, or observable outcome for the audience |

| Source | Timestamp or speaker attribution |

| Emotion Tag | e.g., Curiosity, Confidence, Urgency, Relief, Validation |

---

### 2. SPICY TAKE

A provocative, divisive opinion that challenges conventional wisdom.

**Qualifies if it:**

- Directly contradicts mainstream advice or common practice

- Takes a clear stance (no hedging)

- Includes supporting evidence that makes the position defensible

- Would generate debate if posted publicly

**Extract these fields:**

| Field | Requirements |

|-------|--------------|

| Title | Punchy label signaling controversy (5-10 words) |

| Hook | Must imply challenge: “Most experts get X wrong…” / “The conventional advice is backwards…” |

| Hot Take | The provocative claim in quotable form. Specific and falsifiable. In quotes. |

| Proof | Evidence backing the claim—must include one concrete detail (data, case study, result, logic) |

| Value | What the audience gains by adopting this view |

| Source | Timestamp or speaker attribution |

| Emotion Tag | e.g., Vindication, Rebellion, Shock, Skepticism, Empowerment |

---

### 3. DATA NUGGET

One jaw-dropping statistic with a clear takeaway. Number comes first.

**Qualifies if it:**

- Contains a specific, quantified statistic

- The number is surprising or dramatically illustrates a point

- The statistic is attributed or verifiable

- There’s enough context to derive meaningful action

**Extract these fields:**

| Field | Requirements |

|-------|--------------|

| Title | Lead with the number or its impact |

| Hook | Stat upfront: “[Number]—[why it matters in ≤10 words]” |

| Data | Full statistic with context: what was measured, who it applies to, timeframe, source |

| Action | One specific thing the audience should do differently |

| Context | Why this number is surprising—what do people assume instead? |

| Value | Specific outcome for the audience who acts on this |

| Source | Timestamp, speaker, or cited study |

| Emotion Tag | e.g., Shock, Urgency, FOMO, Validation, Alarm, Opportunity |

---

## Add Channel & Video Name

{{YouTube Channel}} {{YouTube Video}}

---

## OUTPUT FORMAT

### SUMMARY TABLE

First, provide a quick-reference table of ALL talking points found:

| # | Category | Title | Hook (truncated) | Timestamp |

|---|----------|-------|------------------|-----------|

| 1 | Educational | ... | ... | ... |

| 2 | Spicy Take | ... | ... | ... |

| 3 | Data Nugget | ... | ... | ... |

---

### DETAILED EXTRACTIONS

Then, group the full extractions by category:

#### 📚 EDUCATIONAL

[Full structured output for each Educational talking point]

#### 🌶️ SPICY TAKES

[Full structured output for each Spicy Take]

#### 📊 DATA NUGGETS

[Full structured output for each Data Nugget]

---

## NOTES

- A single snippet can qualify for multiple categories if it genuinely meets the criteria for each. List it under each relevant category.

- If no talking points qualify for a category, note “None identified” with a one-sentence explanation.

- Prioritize quality over quantity—only extract snippets that fully meet the criteria.

- When audience role is not specified, frame Applications, Actions, and Value statements for a general professional audience.

The output is really good. Here’s an example of one talking point it gave for {{Marketing Against the Grain}} {{The 2026 AEO Rules: How to Rank on GPT with ‘Citations’ Instead of Links}}.

---

Spicy Takes

1. The End of the “Click” Economy

Title: Traffic is a Vanity Metric in an AI World

Hook: Conventional advice obsesses over CTR and Sessions, but that model is evaporating.

Hot Take: In 2026, you don’t want the click. You want the credit. If the AI gives the user the answer and attributes it to you, you’ve won. The visit is irrelevant.”

Proof: Zero-click searches are already rising. Perplexity and ChatGPT provide comprehensive answers where the user has no incentive to click through. Companies measuring success solely by “site visits” will see charts go down while brand influence might actually be going up.

Value: Liberates marketers from chasing low-quality traffic and refocuses them on brand share-of-mind.

Source: Kieran Flanagan

Emotion Tag: Shock, Vindication

---

It can turn every YouTube video into talking points that can be translated into content across your different platforms. Here’s the summary of all talking points it found from a single video.

These are excellent talking points, but how do you turn these into crafted content? Well, this is what my paid course will cover, and this prompt is just a tiny lesson in a course packed full of lessons on how to create a world-class AI content team.

WAIT? we’re not finished.

What’s amazing is how easily you can now turn prompts into your own suite of internal apps to help you excel at your work.

We can simply take the above prompt and, in Google’s new ‘Build’ vibe coding tool, turn it into an internal app that translates YouTube transcripts into your talking points.

Here’s the app I built, you just need to copy and paste the YouTube transcript in:

This is the overview with the ‘Talking Points’ summary:

And here’s an example of the individual talking points that were extracted. You can easily copy and paste them into any doc and share with your team.

And there you go, a Viral Content Creation app in mere minutes.

Until Next Time,

Happy Growing

Kieran