✉️ Automate MailerSend Email (Google Sheets) 🌐 Overview This workflow converts Google Sheets into a full Email CRM — no HubSpot or Customer.io needed! It automates segmentation, sending, validation, and delivery tracking using: ✅ Google Sheets → CDP + Email Performance DB ✅ MailerSend → Email Template Delivery ✅ n8n → Automation + Logic + Scheduling It automatically: • Reads subscribers from a selected segment sheet • Validates email + checks for disposable domains • Sends a MailerSend email template • Updates send status + delivery result in Sheets Perfect for onboarding emails, promo campaigns, retention flows, newsletters & more! ✅ Key Features • 🎯 Unlimited audience segments • 🚫 Deduplication system per execution • 🛡️ Disposable email filtering • 🔄 Automatic recurring runs (every 30 minutes) • 🧩 Template-based personalization (name, codes, journey) • 📊 Real-time delivery tracking + analytics-ready data • 🔐 Zero CRM vendor lock-in 📊 Database Sheets (Google Sheets Required) Use this database template: 🔗 https://docs.google.com/spreadsheets/d/17KqltP-NqchPhZV7gk6QToqCZX6IiA5EBkDCBNsIX_0/edit?usp=sharing Sheet Name Purpose Required Fields template Campaign configuration Id, template_name, journey, type, type_template_id, discount_code segment1 / segment2 Audience lists user_id, email, first_name, number transaction Status + results history user_id, status, sent_result, sent_at, template_name transaction CreatedAt UpdatedAt user_id email number first_name status database_id type template_id type_template_id template_name journey discount_code gift_code 2025-10-25T13:11:41.567-04:00 2025-10-25T13:11:41.567-04:00 uid_0000000001 [email protected] 9362000000 Liam 1-sending segment1 email 1 v28xxl2sq8dg785k SMS-TEST Test disxxx 2025-10-25T13:11:41.567-04:00 2025-10-25T13:11:41.567-04:00 uid_0000000002 [email protected] 9362000001 Noah 1-sending segment1 email 1 v28xxl2sq8dg785k SMS-TEST Test disxxx 2025-10-25T13:11:41.567-04:00 2025-10-25T13:11:41.567-04:00 uid_0000000003 [email protected] 9362000002 Oliver 1-sending segment1 email 1 v28xxl2sq8dg785k SMS-TEST Test disxxx template Id template_name journey database_id type type_template_id discount_code gift_code 3 Order-Confirmation Order segment3 email v28xxl2sq8dg785k discount2 4 Shipping-Notification Notification segment4 email v28xxl2sq8dg785c discount3 5 Add-to-Cart-day1 Add-to-Car segment5 email v28xxl2sq8dg785d discount4 6 Welcome-New-Customer Welcome segment6 email v28xxl2sq8dg785s discount5 7 Churn-Pro-Plan Churn segment7 email v28xxl2sq8dg785g proxc 8 Churn-Pro-Plan-1day-ago Churn segment8 email v28xxl2sq8dg785h shipx segment1 user_id email number first_name database_id uid_0000000001 [email protected] 09362000000 Liam segment1 uid_0000000002 [email protected] 09362000001 Noah segment1 uid_0000000003 [email protected] 09362000002 Oliver segment1 uid_0000000004 [email protected] 09362000003 Elijah segment1 uid_0000000005 [email protected] 09362000004 James segment1 📌 Add more segments simply by creating new sheets (segment3, segment4...) 📌 Change campaign by updating template_id in Setup Flow node 👤 Who’s it for? • Ecommerce email retention teams • SaaS CRM automation operators • Digital marketing & lifecycle pros • Agencies running multi-brand campaigns • No-code builders who want scalable CRM logic ⚙️ Automations Included Flow 1 — Insert Users (Triggered on schedule) • Pull users from selected segment tab • Insert into transaction sheet • Status: 0-processing → 1-sending • Prevent duplicate sending ✅ Flow 2 — Send Emails (Runs every 30 min) • Selects “ready” users ( 1-sending ) • Checks: Missing email → 3-no-email Disposable → 4-disposal-email • Sends via MailerSend template ID in sheet • Updates status → 2-sent + message result 🎯 Your entire CRM sending logic runs automatically every day 🧠 Personalization Support Available merge-fields: • first_name • discount_code • gift_code (Modify jsonBody to add more!) 🔐 MailerSend Setup Required Inside MailerSend node: Replace “ [email protected] ” with your verified sender email ✅ You must: ✔ Verify domain ✔ Approve sender email ✔ Copy correct template ID → Google Sheet 💡 Optional Enhancements • Slack alerts for failed sends • Connect Looker Studio for dashboards • Add SMS / WhatsApp parallel flows • A/B test templates by duplicating rows • Add AI for subject optimization or copy rewrite 📺 Connect With Me More workflows, CRM strategy & AI marketing automation 👇 LinkedIn: https://linkedin.com/in/nima-salimi-a655a6231 Follow & ⭐️ this template if it helped you 🚀