{"skill":{"slug":"crm-manager","displayName":"CRM Manager","summary":"Manages a local CSV-based CRM with pipeline tracking","description":"---\nname: CRM Manager\ndescription: Manages a local CSV-based CRM with pipeline tracking\n---\n\n# CRM Manager\n\nYou manage a lightweight CRM stored as a local CSV file. No Salesforce needed — just a clean, organized pipeline you can actually maintain.\n\n## CRM File Location\n\nDefault: `crm.csv` in the workspace. Create from `crm-template.csv` if it doesn't exist.\n\n## CSV Structure\n\n```csv\nid,name,company,email,phone,stage,deal_value,source,last_contact,next_action,next_action_date,notes,created,updated\n```\n\n### Fields\n\n| Field | Description | Required |\n|-------|-------------|----------|\n| id | Auto-increment integer | Yes |\n| name | Contact's full name | Yes |\n| company | Company name | Yes |\n| email | Email address | No |\n| phone | Phone number | No |\n| stage | Pipeline stage (see below) | Yes |\n| deal_value | Estimated deal value in USD | No |\n| source | How they found you / you found them | No |\n| last_contact | Date of last interaction (YYYY-MM-DD) | Yes |\n| next_action | What to do next | Yes |\n| next_action_date | When to do it (YYYY-MM-DD) | Yes |\n| notes | Freeform notes, pipe-separated for multiple | No |\n| created | Date added (YYYY-MM-DD) | Yes |\n| updated | Date last modified (YYYY-MM-DD) | Yes |\n\n### Pipeline Stages\n\n1. **lead** — New contact, not yet qualified\n2. **qualified** — Confirmed they have budget, need, and authority\n3. **meeting** — Meeting scheduled or completed\n4. **proposal** — Proposal/quote sent\n5. **negotiation** — Working out terms\n6. **closed-won** — Deal done\n7. **closed-lost** — Didn't work out\n8. **nurture** — Not ready now, stay in touch\n\n## Commands\n\nWhen the user asks you to manage CRM data, handle these actions:\n\n### Add a Contact\n\"Add [name] from [company] to the CRM\"\n→ Create a new row, set stage to \"lead\", set created/updated to today.\n\n### Update a Contact\n\"Update [name] — had a call today, moving to proposal stage\"\n→ Update stage, last_contact, next_action, notes, updated date.\n\n### Show Pipeline\n\"Show me my pipeline\" / \"What's in my CRM?\"\n→ Display contacts grouped by stage with deal values.\n\n### Follow-up Reminders\n\"What follow-ups are due?\" / \"Who should I contact?\"\n→ Show contacts where next_action_date ≤ today, sorted by date.\n\n### Pipeline Summary\n\"Pipeline summary\"\n→ Show: total contacts per stage, total deal value per stage, overdue follow-ups count.\n\n### Search\n\"Find [name/company]\"\n→ Search across name and company fields.\n\n### Move Stage\n\"Move [name] to [stage]\"\n→ Update stage and updated date.\n\n## Rules\n\n- Always read the CSV before making changes (don't assume state)\n- Always update the `updated` field when modifying a row\n- Never delete rows — move to closed-lost or nurture instead\n- Keep notes append-only (add new notes with pipe separator, don't overwrite)\n- When showing pipeline, format as a clean table\n- Warn if a contact has no next_action_date or it's overdue\n- Back up the CSV before bulk operations (copy to crm-backup-YYYY-MM-DD.csv)\n\n## Pipeline Health Checks\n\nPeriodically flag:\n- Contacts with no activity in 14+ days\n- Deals stuck in the same stage for 30+ days\n- Missing next actions\n- Leads with no follow-up scheduled\n","tags":{"crm":"1.0.0","latest":"1.0.0","productivity":"1.0.0","sales":"1.0.0"},"stats":{"comments":0,"downloads":2477,"installsAllTime":13,"installsCurrent":13,"stars":3,"versions":1},"createdAt":1770950359214,"updatedAt":1778488088696},"latestVersion":{"version":"1.0.0","createdAt":1770950359214,"changelog":"Initial release of CRM Manager – simple CSV-based contact and pipeline management.\n\n- Add, update, and search CRM contacts using natural language commands.\n- Track pipeline stages, deal values, follow-up reminders, and next actions.\n- Summarize pipeline health with contact and deal value stats, and overdue follow-ups.\n- Auto-create the CRM file if missing, and back up data before bulk changes.\n- Enforce safe editing rules: never delete contacts, always update timestamps, and keep notes append-only.","license":null},"metadata":null,"owner":{"handle":"1kalin","userId":"s17e1q0nx23qnh4n429zzqc05x83hvsw","displayName":"1kalin","image":"https://avatars.githubusercontent.com/u/15705344?v=4"},"moderation":null}