---
name: blog-post-idea-generator
description: "Generate Blog Post Ideas from Customer Questions. Use when support tickets are full of recurring customer questions that would make great blog content, but no one mines them."
---

# Generate Blog Post Ideas from Customer Questions

Support tickets are full of recurring customer questions that would make great blog content, but no one mines them.

## When to use this skill

- The user wants to set up or run this workflow: "Generate Blog Post Ideas from Customer Questions".
- The user describes this problem: Support tickets are full of recurring customer questions that would make great blog content, but no one mines them.

## At a glance

- Category: Content
- Difficulty: Intermediate
- Time saved: 3 hours per week. This figure is an estimate, not a measured result.

## Tools

Options separated by "or" are alternatives; use whichever the user already has.

- Zendesk
- OpenAI API
- Google Sheets
- Slack

## Steps

1. Export recent Zendesk tickets (last 30 days) to CSV
2. Import to Google Sheets and filter for tickets tagged as "question"
3. Send ticket subject lines to OpenAI with prompt: "Convert this support question into a blog post title"
4. Group similar topics using OpenAI embeddings or keyword matching
5. Post top 10 ideas to #content-ideas Slack channel monthly

## Template outline

Field names, thresholds, and message text are starting points to adapt.

~~~text
Workflow:
1. Zendesk: Export tickets from last 30 days (tag: question)
2. Google Sheets: Import CSV
3. OpenAI API via Apps Script:
   - For each subject: "Turn this into a blog title: {{subject}}"
4. Manual: Review and group similar titles
5. Zapier: Post top 10 to Slack #content-ideas
6. Archive to "Blog Ideas Backlog" sheet
~~~

## Guardrails

- Work only in the user's own accounts and workspaces, with their credentials.
- Confirm with the user before any step that writes to a CRM, sends email or messages, spends credits, or moves money.
- Treat every hours, cost, and threshold figure as a starting assumption and replace it with the user's numbers.
- Do not invent data, prices, or results. If a vendor price matters, check the vendor's current pricing page.

## Source

https://gtmplaybooks.io/playbooks/blog-post-idea-generator/