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
YouTube Video Editing Category: Adobe Premiere Pro, After Effects, Final Cut Pro, Sound Design, Video Editing, Video Post Editing, Video Production, Video Services Budget: $30 - $250 AUD
Shopify Beauty Store Revamp Category: Conversion Rate Optimization, ECommerce, Graphic Design, HTML, Shopify, Shopify Templates, Web Design, Web Development Budget: $30 - $250 USD
28-Dec-2025 22:57 GMT
blender 3d cool spaceship fighter Category: 3D Animation, 3D Art, 3D Modelling, 3D Rendering, Animation, Blender, Game Design, Game Development, GameMaker Budget: $10 - $20 USD
28-Dec-2025 22:56 GMT
Modern Neutral Kitchen Design Category: 3D Modelling, 3D Rendering, 3D Visualization, Architecture, Building Architecture, Building Design, Building Engineering, Graphic Design, Home Design, Interior Design Budget: $10 - $30 USD
28-Dec-2025 22:52 GMT
Survival Minecraft Server Development Category: Database Management, Game Art, Game Design, Game Development, Game Testing, Game UI, Minecraft, Modding, Performance Tuning, Scripting Budget: $30 - $250 USD
28-Dec-2025 22:52 GMT
Adult Cartoon 2D Animation Category: 2D Animation, 2D Animation Explainer Video, 3D Animation, Adobe Animate, After Effects, Animation, Illustration, Krita Budget: $30 - $250 USD
Realistic Roblox Game Category: 3D Animation, 3D Modelling, 3D Rendering, Blender, Game Design, Game Development, Lua, Maya, Roblox, Scripting Budget: $30 - $250 AUD
28-Dec-2025 22:48 GMT
Google Listing Setup & Verification Category: Account Management, Brand Management, Business Development, Content Creation, Digital Marketing, SEO, Social Media Management, Website Management Budget: $30 - $250 USD