Pipedrive

Promptfree, for everyone, and the only version there is

Open the prompt in Claude CodeOpen the prompt in CodexOpen the prompt in Cursor

Copy

Build me a pipeline CRM for a small sales team, with the email problem solved honestly.

STACK
- Astro with a Node adapter, SQLite via better-sqlite3
- IMAP for reading mail, SMTP for sending

THE MODEL
- Organisation, person, deal, activity — four tables, related by id
- A deal has a stage, a value, an expected close date and one owner
- Stages defined in config with a probability each; pipeline value is the weighted sum

EMAIL, THE PART THAT MATTERS
- Poll IMAP, match messages to people by address, and file them against the person's open deal
- Ambiguous matches go to a review queue rather than being guessed
- Store message id, subject, direction and a body snapshot; never delete on the server

ACTIVITIES
- Call, meeting, task — each with a due date and an owner
- A deal with no future activity is marked as rotting after a configurable number of days, and that is the main list on the dashboard

HISTORY
- Every stage change appended with who and when, so time-in-stage is computable
- Never overwrite a field: the previous value goes to a revision table

REPORTS
- Deals won and lost per month, average time in each stage, and pipeline by stage
- All computed at query time from the history

Include a README on the IMAP credentials, the matching rules, and how to export everything as CSV.