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
Shopify Dropshipping Store Setup Category: Dropshipping, ECommerce, HTML, PHP, Shopify, Shopify Development, Web Design Budget: ₹600 - ₹1500 INR
10 Nov 2025 17:04 GMT
Knowledge Base and Process Documentation Writer Category: Article Writing, Business Writing, Content Development, Content Management System (CMS), Content Writing, Documentation, Research Writing, Technical Writing Budget: $250 - $750 USD
Shopify Store for Soccer Club Category: ECommerce, HTML, Product Management, Shopify, Shopify Development, Shopify Templates, Web Design Budget: $30 - $250 CAD
10 Nov 2025 17:00 GMT
Animação Personalizada de Logotipo 4K Category: 2D Animation, 3D Animation, 3D Modelling, After Effects, Animation, Blender, Motion Graphics, Video Editing Budget: $15 - $25 USD
10 Nov 2025 17:00 GMT
Devotional YouTube Growth Strategist Category: Analytics, Content Creation, Content Strategy, Digital Marketing, Internet Marketing, SEO, Social Media Marketing, Twitter, Video Editing, YouTube Budget: ₹12500 - ₹37500 INR
10 Nov 2025 16:58 GMT
Female Farmers' Grant Initiative Category: Business Development, Financial Consulting, Financial Planning, Fundraising, Grant Writing, Project Management, Research, Social Impact, Sustainability Budget: $250 - $750 USD
10 Nov 2025 16:57 GMT
eBay & Etsy Sales Optimisation Category: Content Writing, Digital Marketing, EBay, ECommerce, Etsy, Internet Marketing, Keyword Research, Product Descriptions, SEO Budget: $250 - $750 CAD
10 Nov 2025 16:56 GMT
English Document Transcription & Translation Category: Content Writing, English (US) Translator, English Spelling, English Translation, Proofreading, Transcription, Translation, Word Processing Budget: $8 - $15 AUD