Budget: 150 USD Deadline: 1 day
Hi,
I have hands-on experience building this exact type of scenario in Make.com — CRM-triggered flows, dynamic field substitution into HTML templates, error handling, and duplicate-send prevention. A few recent examples from my own work: automated Telegram/LinkedIn posting pipelines with dynamic content and validation, and a cold-email system (n8n) with the same anti-duplicate logic via a data store.
For your task specifically, here's the plan:
Watch Item / Column Values trigger in Monday.com on the target status
Read Name / Email / Client Portal URL
Missing-data check with a dedicated error-handling branch (no silent failures)
Duplicate protection via a data store or a checkbox field in Monday
Fill your HTML template with the values and send
Update the Monday item status after a successful send
One thing to confirm before starting: for a transactional (single, personalized) email, Mailchimp Transactional API is the cleaner fit — the standard Mailchimp module in Make is geared more toward bulk campaigns. If you already have a Transactional/Mandrill account connected, this is straightforward; if not, we can quickly agree on the best approach at kickoff.
Ready to start right away, and can deliver within the stated 2–4 hour window. Comfortable communicating in English throughout.