Can I vibe code GetResponse?

Build a lightweight, event-driven email automation microservice using Node.js, PostgreSQL, Redis, and Amazon SES.

1. Data Model:
- Create tables for `contacts` (id, email, first_name, last_name, tags array, status [active, unsubscribed, bounced], custom_fields JSONB, created_at).
- Create tables for `lists` (id, name), `contact_lists` (contact_id, list_id), and `campaigns` (id, subject, body_html, sender_email, status, scheduled_at).
- Create tables for `automation_workflows` (id, name, trigger_event, definition_json, active boolean).
- Create tables for `workflow_executions` (id, workflow_id, contact_id, current_step_index, next_run_at, status [pending, completed, failed], context JSONB).
- Create tables for `email_logs` (id, contact_id, campaign_id, provider_message_id, event_type [sent, delivered, opened, clicked, bounced, complained], metadata JSONB, created_at).

2. Core Functionality:
- REST API to manage contacts, create segment queries (e.g., spent > $100 AND tag = 'vip'), and trigger bulk email sends.
- Integration with AWS SES SDK (v3) for message delivery. All outgoing emails must include an RFC 8058 compliant `List-Unsubscribe` header and one-click unsubscribe URL handling.
- Implement a background execution queue using BullMQ. When an e-commerce event (e.g., `cart_abandoned`) arrives via webhook, instantiate a `workflow_execution` record.
- Create a worker process that evaluates active workflow executions, enforces step delays (e.g., wait 2 hours), checks exit conditions (e.g., customer completed purchase), and dispatches the next email step.
- Build a public HTTP endpoint to parse incoming webhooks from AWS SES (SNS notifications) for delivery status, soft/hard bounces, and spam complaints, updating contact records instantly.

3. Failure Modes to Handle:
- Automatically change contact status to `bounced` on hard bounce notifications and suppress future sends.
- Implement lock mechanisms in Redis during step processing to prevent duplicate email sends to the same contact.
- Handle SES rate limits using BullMQ rate-limiting queues with exponential backoff.

4. Out of Scope:
- Drag-and-drop visual workflow canvas (use declarative JSON arrays for sequence steps).
- Landing page generator, web push notifications, or SMS features.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs