We recently completed a UK-specific automated email alert system that connects our PostgreSQL + Google Sheets data to Brevo (Sendinblue) for user notifications. The system is fully functional and documented in detail (22-page technical document provided).
We’ve now parted ways with the original developer, and we’re looking for a new expert to:
Audit and verify the completed UK alert system — ensuring it meets best practices, follows clean architecture, and that there are no code or performance issues.
Duplicate and adapt the same system for our European Union product (France, Germany, Spain, and Ireland).
What’s Already Done (UK System):
Node.js + Express + TypeScript backend
PostgreSQL (Neon) + Drizzle ORM
Google Sheets API integration for live savings data
Automated Brevo lists + contact sync
6 email templates for various alert types
Daily + weekly cron jobs
Duplicate prevention, scheduled emails, and smart alert logic
Full system documentation (provided)
Your Tasks: Phase 1 — Audit (Estimated: 1–2 days)
Review all code, configuration, and Brevo integration
Verify cron jobs, email triggers, and database schemas match documentation
Test end-to-end flow (sign-up → Brevo list → email delivery → logs)
Identify and fix any reliability, performance, or data consistency issues
Phase 2 — EU Implementation (Estimated: 2–3 days)
Duplicate UK alert flow for EU region (France, Germany, Spain, Ireland)
Integrate EU-specific Google Sheets data endpoints (already hosted)
Create separate Brevo lists and folder for EU alerts
Ensure rate updates trigger relevant EU emails
Update templates where necessary (e.g., "Weekly Roundup EU")
Deploy and test full flow on Replit
Deliverables:
Verified and clean UK alert system
EU alert system live and fully functional
Separate Brevo folder and lists for EU contacts
Working cron jobs (daily + weekly)
Test documentation and basic setup instructions
Tech Stack:
Node.js + Express + TypeScript
PostgreSQL (Neon) with Drizzle ORM
Brevo API (v3)
Google Sheets API
Hosted on Replit
What We’re Looking For:
Strong backend skills in Node.js/TypeScript
Experience with PostgreSQL + Drizzle ORM
Knowledge of Brevo (Sendinblue) or similar email systems
Familiarity with cron jobs, background tasks, and transactional email logic
Proven ability to work from and extend existing codebases
Healthcare & Nutrition Blog Writing - 20/02/2026 00:48 EST Category: Article Writing, Blog Writing, Content Writing, Diet, Ghostwriting, Health Care Management, Life Coaching, Nutrition, SEO Writing, Video Editing Budget: ₹600 - ₹1500 INR
24-Feb-2026 05:04 GMT
Nature Documentary Video Editor Category: Adobe Premiere Pro, After Effects, Content Creation, Data Visualization, Film Production, Post Production, Video Editing, Video Production, Video Services Budget: ₹1500 - ₹12500 INR
24-Feb-2026 05:04 GMT
Elegant Wedding Animation - 22/02/2026 22:42 EST Category: 2D Animation, 3D Animation, Adobe Animate, Adobe Creative Cloud, After Effects, Animation, Graphic Design, Video Production Budget: min ₹2500 INR
AI Product Showcase Video for Instagram Category: 3D Animation, Adobe Premiere Pro, After Effects, AI Animation, AI Art Creation, Animation, Video Editing, Video Services Budget: ₹12500 - ₹37500 INR
24-Feb-2026 04:56 GMT
Professional Sales Landing Page Design Category: Brochure Design, Content Writing, Facebook Marketing, Graphic Design, Sales, Web Design, Web Development Budget: ₹600 - ₹1500 INR
24-Feb-2026 04:53 GMT
WooCommerce E-commerce Store Design Category: ECommerce, Shopping Cart Integration, UI / User Interface, Web Design, Web Development, WooCommerce, WordPress Budget: ₹750 - ₹1250 INR