The Prompt Vault

You are my Sales Chief of Staff. I will provide a JSON array of our active deals, upcoming tasks, and stale leads.

Generate a crisp, motivating morning briefing for Telegram:

Formatting Guide:
🌅 **Good Morning! Here is your Sales Briefing for [Date]:**

🎯 **TOP PRIORITY TODAY (Action Required):**
- [Deal Title] ($[Value]) - Contact: [Name] ([Company]). Next Step: [Next Step]. Why: [Strategic importance].

⚠️ **STALE LEADS (No activity in 4+ days):**
- [Deal Title] - In [Stage] for [X] days. Recommended action: [Revival prompt suggestion].

📊 **PIPELINE SNAPSHOT:**
- Total Pipeline: $[Total] across [Count] active deals
- Deals in Final Proposal / Review: $[Total]

Let's make today count! ⚡

You are my Executive Sales Copilot. I will provide raw notes or a meeting transcript from a discovery call.

Process this input and output TWO sections:

SECTION 1: CRM UPDATE
- Executive Summary: 3 bullet points highlighting main pain points and required deliverables.
- Key Decision Criteria: Budget, timeline, decision makers.
- Potential Objections: What might cause this deal to stall?
- Suggested Deal Stage: (e.g. Discovery -> Proposal Sent)
- Win Probability Score: (0-100% with brief justification)

SECTION 2: CUSTOM FOLLOW-UP EMAIL
- Subject: Contextual, personalized, zero spam triggers.
- Body:
  - Thank them for their time and reference one memorable detail from the chat.
  - Summarize the core challenges discussed.
  - Detail our agreed next action items with explicit deadlines.
  - End with a low-friction question.
- Tone: Consultative, concise (under 180 words), authentic.

Here are the raw notes / transcript:
[PASTE HERE]

I need a complete relational database schema for my custom business CRM.

Here are my business details:
- Business Model: [e.g., Agency / B2B Consulting / Home Contractor / SaaS / E-commerce]
- Core Offer & Price: [e.g., $3,000 onboarding + $1,500/mo retainer]
- Key Sales Stages:
  1. Lead Capture (Inbound form or referral)
  2. Discovery Call Booked
  3. Proposal & Scope Presented
  4. Contract / In Review
  5. Closed Won
  6. Closed Lost (with loss reason tracking)

Please generate:
1. Complete PostgreSQL DDL with foreign key constraints, default UUIDs, created_at/updated_at timestamps, and ENUM types for stages.
2. An Entity Relationship summary explaining each table's role.
3. Realistic sample seed records (3 companies, 5 contacts, 4 deals with rich activity notes) so the database can be populated immediately.

Create a clean TypeScript Cloudflare Worker that acts as a robust inbound webhook receiver for my CRM.

Functionality:
1. Listens for POST requests at `/webhook/lead`.
2. Validates incoming payload: first_name, last_name, email, phone, company, message, source, estimated_budget.
3. Authenticates with Supabase REST API using environment variables `SUPABASE_URL` and `SUPABASE_KEY`.
4. Logic:
   - Queries `contacts` by email.
   - If contact exists: appends an activity log in `activities` with the new inquiry message and updates `next_step_due`.
   - If contact does not exist: inserts into `contacts` and creates a new deal in `deals` with stage `new_inquiry`.
5. Returns proper CORS headers and JSON response with status codes.

Generate a complete, single-file interactive CRM Dashboard application using React, Lucide React icons, and Tailwind CSS for Claude Artifacts.

Key Features & UI Structure:
1. Header & Summary Stats Bar:
   - Total Pipeline Value ($), Active Opportunities, Win Rate (%), and Hot Leads (due today).
2. Interactive Kanban Board:
   - Columns: Inquiries, Discovery, Proposal Sent, Review, Closed Won, Closed Lost.
   - Cards display: Deal Name, Client Company, Contact, Deal Value, Days in Stage Badge, and Next Action.
   - 1-click stage advancement buttons on each card.
3. Quick Filters & Action Toolbar:
   - Instant search by client name, email, or deal title.
   - '+ New Opportunity' modal with input validation.
4. Detail Drawer (Slide-Over Panel):
   - Opens when clicking any deal card.
   - Shows complete contact details (phone, email, source).
   - Activity Timeline with call logs, notes, and an input box to quickly add timestamped notes.
5. Modern Visual Design:
   - Dark mode slate/zinc palette with emerald/cyan accent glows.
   - Clean typography and smooth transitions.

Include rich mock data matching these specs so the UI is immediately interactive upon render.