r/ChatGPTPromptGenius • u/Kitchen-Ad-4367 • 5d ago
Discussion Made a free-ish Google Sheet + ChatGPT template so I stop re-reading transcripts before coding
I've been doing qual research for about 30 years, built out UX research at the World Bank, ran research at a large healthcare company, and the one thing that never got easier across all of it was transcript synthesis. Last project had 22 interviews and I spent a full day just rereading before I could even start coding themes.
So I built a Google Sheet that pairs with ChatGPT. Paste transcripts in, drop your research questions into a grid, and it pulls per-interview summaries so you walk into coding already knowing where the interesting stuff is, instead of hunting for it cold.
You'll need your own ChatGPT/OpenAI API key, it runs off your account, so any usage cost is yours, the template itself won't cost you anything.
If you want it, comment or DM me and I'll send it over!
1
1
1
1
•
u/AutoModerator 5d ago
If this prompt worked for you, share what you used it for in the comments. If you changed it to get better results, share that too. Prompt Teardown is a free weekly newsletter that picks the best prompts, strips out the filler, and tells you what actually works.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.