Generate Blog Post Ideas from Customer Questions

1. 1

   Export recent Zendesk tickets (last 30 days) to CSV

2. 2

   Import to Google Sheets and filter for tickets tagged as "question"

3. 3

   Send ticket subject lines to OpenAI with prompt: "Convert this support question into a blog post title"

4. 4

   Group similar topics using OpenAI embeddings or keyword matching

5. 5

   Post top 10 ideas to #content-ideas Slack channel monthly

Template outline

The structure to recreate in your own workspace. Field names and thresholds are starting points.

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