Customer Interview Synthesizer

You ran the interviews. Now comes the week of sticky notes.

Customer Interview Synthesizer is an OpenClaw skill that codes every speaker turn in your transcripts with JTBD labels, clusters themes across all your interviews, and renders a frequency-vs-severity opportunity map with sourced quotes — in one pipeline run instead of one exhausting week.

Most research synthesis tools either give you raw transcripts or require a specialized SaaS subscription. This skill runs entirely in your agent, against your files, with no data leaving your machine.

What it does

• Tags every transcript turn with JTBD codes: pain, goal, workaround, anti-goal, job, and quote-worthy
• Clusters codes across 5-30 interviews into named themes with quote counts and source attribution
• Ranks themes by opportunity score (frequency × severity) in a markdown table
• Generates a quote bank per theme with speaker and interview ID — paste directly into a PRD

What's in the package

All files listed below are bundled as fenced code blocks inside SKILL.md — there's no separate folder to install. Copy each code block into its own file using the path shown above it.

• SKILL.md — the full synthesis workflow your agent follows.
• scripts/code_transcript.py — tags a single interview transcript with JTBD codes.
• scripts/cluster_themes.py — clusters codes across all interviews into themes.
• scripts/render_opportunity_map.py — renders the opportunity map table and quote bank as markdown.
• data/jtbd-prompts.md — JTBD code taxonomy with definitions and calibration notes.
• scripts/examples/ — two sample transcripts, coded JSONs, themes.json, and a rendered opportunity map to verify the pipeline works.

How it ships

Drop SKILL.md into ~/.openclaw/skills/customer-interview-synthesizer/. Restart OpenClaw. Run /customer-interview-synthesizer or describe what you need — your agent picks it up.

Pairs well with Linnea (research persona) for full discovery-to-synthesis workflows.

Questions: hackedcubeapps@gmail.com (response within 48 hours).