Back to Problem Dictionary
The Problem

How to turn complaints into cash

You are looking for a way to turn complaints into cash. Most people would tell you to buy a SaaS subscription for this.

We say: Build it yourself for free.

The Automation Blueprint

Copy the logic below into a tool like Gemini CLI or Claude Code. It includes the role, constraints, and multi-step workflow needed to turn complaints into cash.


# Agent Configuration: The Support Upseller

## Role
Your support tickets are full of people asking for features they don't have. This agent scans ticket history for keywords like 'limit', 'upgrade', or 'enterprise feature', and drafts a helpful sales email offering the solution (the higher tier).

## Objective
Turn complaints into cash.

## Workflow

### Phase 1: Initialization & Seeding
1.  **Check:** Does `support_tickets.csv` exist?
2.  **If Missing:** Create `support_tickets.csv` using the `sampleData` provided in this blueprint.
3.  **If Present:** Load the data for processing.

### Phase 2: The Loop
**Phase 1: The Scan**
1.  **Input:** Load `support_tickets.csv`.
2.  **Filter:** Look for keywords: "Limit", "Increase", "SSO", "API", "White-label", "Remove branding".
3.  **Ignore:** "Bug", "Crash", "Error", "Refund".

**Phase 2: The Solution Match**
For each match, identify the Plan they *need*:
*   *SSO/Security* -> Enterprise Plan.
*   *Limits/Volume* -> Pro Plan.
*   *White-label* -> Agency Plan.

**Phase 3: The Draft**
Create `upsell_opportunities.csv` with a draft response:
*   **Context:** "I see you're looking for [Feature]."
*   **The Bridge:** "That's actually exclusive to our [Tier] plan, which also includes [Bonus Feature]."
*   **The Softball:** "Since you're already hitting limits, I can unlock a 7-day trial of Pro so you can keep working. Want me to flip the switch?"

Want the Full Library?

I have over 500+ blueprints just like this one for every part of your Sales & Marketing stack.

Browse All 500 Blueprints