Case study 01 · Full-stack workflow
InvitePass
A payment-review and automated invitation-email system designed to replace repetitive manual delivery with a controlled approval, queue, and recurring schedule.
Problem
Recurring access delivery created too much manual work.
The workflow required checking GCash receipts, approving memberships, sending a current Canva invitation, repeating delivery every seven days, and preventing one invitation URL from being overused.
The system needed to automate repeatable work without treating receipt screening as final payment verification.
Workflow
A controlled path from payment submission to recurring delivery.
- SubmitAn applicant selects a configured GCash account and uploads a receipt.
- ScreenThe browser screens the receipt while the administrator verifies the transaction.
- ApproveApproval activates or renews the member and queues the first email.
- ScheduleActive members become due again every seven days.
- Control capacityEach invitation URL stops at 95 successful deliveries.
- Queue safelyMembers wait in FIFO order until a new usable link is available.
Technical approach
Automation with clear trust boundaries.
Application and data
Next.js handles the public and administrative interfaces. Supabase stores schedules, invitation links, delivery records, queue state, and private receipt uploads with Row Level Security.
Delivery and scheduling
Resend delivers personalized emails, while a daily Vercel Cron process checks due members, link capacity, and waiting queues.
Operational controls
Manual approval remains required before activation. Link history and delivery records keep automation decisions visible.
Security
Keep sensitive actions on the server.
- Private receipt storage
- Manual payment verification before activation
- Supabase Row Level Security
- Server-only administration, email, and cron secrets
- No member access code required
Next improvements
Make operations easier to audit at a glance.
Next iterations would strengthen delivery observability, clarify receipt-review reasons, and add admin analytics for queue age, delivery failures, and link utilization.
View InvitePass live ↗