7DayCRM & Autonomous Agency Operations Dashboard
Next.js App Router + Prisma operational CRM and webhook automation engine engineered to take service businesses from inbound lead capture to automated SLA fulfillment.
STAR Engineering Breakdown
01 · Situation & Problem
Inbound agency leads and onboarding tasks were fragmented across forms, spreadsheets, and chat threads, creating response latency and manual status-tracking overhead.
02 · Technical Execution
Built a full-stack Next.js App Router and Prisma application featuring idempotent webhook ingestion, strict deal-stage transitions, and automated n8n/Slack operational triggers.
03 · Reliability & Idempotency
Implemented deterministic idempotency keys and database transactions so retried webhooks or concurrent form submissions never created duplicate CRM records or double-fired client notifications.
04 · Verified Impact
Reduced manual operational overhead by 15+ hours per week and enforced a predictable 7-day client onboarding and fulfillment cadence.
export async function upsertInboundLead(payload: VerifiedLeadInput) {
return prisma.lead.upsert({
where: { idempotencyKey: payload.idempotencyKey },
update: { lastTouchAt: new Date(), utmSource: payload.utmSource },
create: { ...payload, stage: "QUALIFYING", slaDueAt: addHours(2) },
});
}Benchmark Table
| METRIC | MANUAL BASELINE | PROGRAMMATIC ENGINE |
|---|---|---|
| Inbound Lead-to-Action Latency | Hours (Manual Inbox Triage) | <50ms Webhook + Instant Slack SLA |
| Duplicate Lead / Retry Collisions | Frequent Webhook Duplicates | 0% (Prisma Idempotency Keys) |
| Weekly Ops Administration | 15+ Hours Manual Status Sync | Fully Automated Pipeline State |