Varko Sales Hub – AI Proposal Generator
Project Info:
An internal sales platform for the Varko ads agency. Sales reps import lead lists, record discovery-call notes, and get a ready-to-send proposal: a branded PDF deck plus a phone-sized version for WhatsApp.
What it does
• Lead import from CSV or Excel (SheetJS), skipping duplicates and incomplete rows.
• Claude turns free-form call notes into structured proposal content, validated against a Zod schema before anything is rendered.
• Server-side PDF generation with @react-pdf/renderer, including QR codes.
Architecture
• Google sign-in (Auth.js v5) with four roles (rep, manager, admin, super admin) and an email-domain allowlist.
• Drizzle ORM on libSQL: SQLite locally, Turso in production, with versioned migrations.
• Installable Android app (Trusted Web Activity) built and signed in GitHub Actions, published as releases and offered on a download page with a QR code.
• Service worker with an offline page and Digital Asset Links tying the app to the domain.
Project Details:
- Client: Varko (internal sales team)
- Technologies: Next.js 16, React 19, TypeScript, Auth.js v5 (Google SSO), Drizzle ORM, libSQL / Turso, Claude API with Zod structured output, @react-pdf/renderer, SheetJS, Service Worker, Android Trusted Web Activity, GitHub Actions, Vercel
- Date: November 2026
- URL: sales.varko.agency