Proposal Engine MVP

MVP Promise: Business name + city → 90-second audit → evidence-backed proposal with 3-tier pricing → close deals

Tech Stack

• Framework: Next.js 14 (App Router) + TypeScript
• Database: Cloud SQL for PostgreSQL + Prisma ORM
• AI: Vertex AI (Gemini 1.5 Pro & Flash)
• Orchestration: Cloud Workflows + Cloud Run Jobs
• Hosting: Google Cloud Run
• Storage: Google Cloud Storage

Quick Start

Prerequisites

1. Node.js 18+ installed
2. GCP Project with APIs enabled:
   • Cloud SQL Admin API
   • Cloud Run API
   • Vertex AI API
   • Cloud Workflows API
   • Places API
   • PageSpeed Insights API

Local Development

1. Install dependencies:

   npm install

2. Set up environment variables: Copy .env.local and fill in your values:

   DATABASE_URL=postgresql://...
   GCP_PROJECT_ID=your-project-id
   GOOGLE_PLACES_API_KEY=...
   API_KEY=your-secret-key

3. Start Cloud SQL Auth Proxy (for local dev):

   cloud-sql-proxy your-instance-connection-name

4. Run database migrations:

   npx prisma migrate dev

5. Start development server:

   npm run dev

   Open http://localhost:3000

Caching

ProposalOS supports two caching backends for API responses (PageSpeed, Places, SerpAPI):

File-Based Cache (Default)

• Usage: Automatic if REDIS_URL not set
• Limitations:
  • ⚠️ Not shared across instances - Each Cloud Run instance has its own cache
  • Not suitable for auto-scaling beyond 1 instance
  • Cache cleared on instance restart

Redis Cache (Recommended for Production)

• Usage: Set REDIS_URL environment variable
• Benefits:
  • ✅ Shared across all instances
  • ✅ Persistent across deployments
  • ✅ Supports auto-scaling
  • ✅ Better cache hit rates

Setup Redis on GCP

# Create Redis instance
gcloud redis instances create proposalus-cache \
  --size=1 \
  --region=us-central1 \
  --tier=basic

# Get connection string
REDIS_HOST=$(gcloud redis instances describe proposalus-cache \
  --region=us-central1 \
  --format="value(host)")

# Set in Cloud Run
gcloud run services update proposalus \
  --set-env-vars REDIS_URL=redis://$REDIS_HOST:6379

Recommendation: Always use Redis in production if running more than 1 instance.

Development Roadmap

Health Check

GET /api/health

Create Audit

POST /api/audit
Headers: x-api-key: your-api-key
Body: {
  "name": "Joe's Plumbing",
  "city": "Saskatoon"
}

Get Audit

GET /api/audit/{id}

Project Structure

/Users/danishsethi/ProposalOS/
├── app/
│   ├── api/
│   │   ├── health/route.ts       # Health check
│   │   └── audit/
│   │       ├── route.ts           # Create audit (POST)
│   │       └── [id]/route.ts      # Get audit (GET)
│   ├── page.tsx                   # Homepage
│   └── layout.tsx                 # Root layout
├── lib/
│   └── db.ts                      # Prisma client singleton
├── prisma/
│   └── schema.prisma              # Database schema
└── workflows/                     # Cloud Workflows definitions (TBD)

Development Roadmap

• Week 1: Foundation - Next.js, Prisma, API routes
• Week 2: Data Collection - Website, GBP, Competitor modules
• Week 3: Diagnosis - Vertex AI integration, clustering
• Week 4: Proposal - Tier mapping, PDF generation
• Week 5: Orchestration - Cloud Workflows, end-to-end
• Week 6: Pilot - Real audits, QA, launch

License

Private - Not Open Source