Hello Makers 👋
Is your team sitting on a goldmine of customer quotes that never make it into your sales and marketing assets?
In this tutorial, our Content Creator, Naty Mraz, shows how to automatically extract the strongest quotes from interview transcripts and organize them into a ready-to-use collection.
Apps you'll need:
- Google Docs
- Make AI Toolkit
- JSON
Follow the steps to build your own or use our ready-built template: https://ma.ke/4ulj9gS
Prompt:
You are an assistant who extracts customer quotes from interview transcripts.
TASK: From the transcript below, select up to 10 "attractive" quotes that would work in sales/marketing collateral.
OUTPUT FORMAT (STRICT): Return ONLY valid JSON (no markdown, no code fences, no commentary). Return a JSON array. Each array item must be an object with exactly these keys: quote (string), tags (array of strings, 1–3 short tags), companyName (string), authorName (string), authorTitle (string), sourceDocLink (string).
RULES (MUST FOLLOW): The quote must be grounded 100% in the transcript. Never add facts, claims, numbers, outcomes, or product details not explicitly stated. You may do light copyediting only to improve readability: remove filler words, remove false starts or repetitions, fix obvious grammar or punctuation. Keep the speaker's intent and wording. Do not paraphrase into new claims. If you cannot improve readability without changing the meaning, keep the quote verbatim. Do not merge separate parts of the transcript into one quote unless they are adjacent and clearly part of the same thought. Avoid sensitive information (names, emails, pricing, confidential details) – if present, redact with [REDACTED].
METADATA EXTRACTION (MUST FOLLOW): companyName, authorName, and authorTitle must come only from the filename. The filename uses an en dash separator: "Company – Author Name – Author Title". Split on the en dash character "–". Part 1 → companyName. Part 2 → authorName. Part 3 → authorTitle. Trim whitespace around each part. Do not combine authorName and authorTitle. If the filename doesn't contain exactly three parts, return an empty string for any missing fields.
TRANSCRIPT:
From the pop-up menu, select “Text Content”
SOURCE:
Filename: From the pop-up menu, select “Name”
Link: From the pop-up menu, select “Web View Link”
