NERDY HACKS · RESEARCH & PLANNING

Copywriter loads 40+ client podcast transcripts into NotebookLM, pulls every customer-impact quote into a table, and turns them into case studies

A homepage copywriter transcribes a client's podcast episodes, adds the transcripts to NotebookLM and asks for every quote about customer impact in a table, then pastes the table into a custom Gemini Gem that drafts case studies.

TOOL USED

NotebookLM, Gemini

SPOTTED ON

u/alexnapierholland · Oct 28, 2025

THEIR CLAIM

1-2 days of work in under an hour

TL;DR

What did u/alexnapierholland use NotebookLM for?

A homepage copywriter transcribes a client's podcast episodes, adds the transcripts to NotebookLM and asks for every quote about customer impact in a table, then pastes the table into a custom Gemini Gem that drafts case studies. A job that used to take them several days now takes an hour or two, they say.

What they did

For a client with a podcast, they transcribed more than 40 episodes and added the transcripts to NotebookLM. They asked it to find every quote about customer impact and put them in a table with the quote, person, company and use case. They then pasted the table into a custom Gemini Gem set up to turn it into case studies.

How it went

A job that used to take them several days now takes an hour or two, they say.

"1-2 days of work done in under an hour"

— u/alexnapierholland

Worth knowing

  • Check each quote against the transcript before publishing, and get the client's OK to quote customers by name. Auto-transcripts can mishear names and companies.
  • Price check: Google Gemini: free plan; Google AI Plus: US$4.99/month (checked Nov 1, 2026).

Try it yourself

Paste this into a chatbot, then add your own details underneath.

(Add the episode transcripts as sources.) "Find every quote where a guest describes the impact our product had on their work. Put them in a table with columns: exact quote, person, company, use case, episode. Only include quotes that appear word for word in the sources."

Original post

See u/alexnapierholland's original post on Reddit → (Oct 28, 2025)

Filed under Research & Planning hacks · Content Creators

Sources

  1. u/alexnapierholland on Reddit, Oct 28, 2025 — the original post
  2. Google Gemini pricing — checked Nov 1, 2026

THE NERD SIGNAL

Rocky digs through the AI noise. You get the good bits.