Build a complete email CRM with Google Sheets & MailerSend

✉️ 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-NqchPhZV7gk6QToqCZX6IiA5EBkDCBNsIX0/edit?usp=sharing | Sheet Name | Purpose | Required Fields | |-----------|---------|----------------| | template | Campaign configuration | Id, templatename, journey, type, typetemplateid, discountcode | | segment1 / segment2 | Audience lists | userid, email, firstname, number | | transaction | Status + results history | userid, status, sentresult, sentat, templatename | transaction | CreatedAt | UpdatedAt | userid | email | number | firstname | status | databaseid | type | templateid | typetemplateid | templatename | journey | discountcode | giftcode | |----------------------------------|----------------------------------|-----------------|------------------------|-------------|------------|------------|-------------|------|-------------|-------------------|-----------------|---------|---------------|-----------| | 2025-10-25T13:11:41.567-04:00 | 2025-10-25T13:11:41.567-04:00 | uid0000000001 | [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 | uid0000000002 | [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 | uid0000000003 | [email protected] | 9362000002 | Oliver | 1-sending | segment1 | email | 1 | v28xxl2sq8dg785k | SMS-TEST | Test | disxxx | | template | Id | templatename | journey | databaseid | type | typetemplateid | discountcode | giftcode | |----|---------------------------|----------------|-------------|------|-------------------|---------------|-----------| | 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 | userid | email | number | firstname | databaseid | |-----------------|-------------------------|--------------|------------|-------------| | uid0000000001 | [email protected] | 09362000000 | Liam | segment1 | | uid0000000002 | [email protected] | 09362000001 | Noah | segment1 | | uid0000000003 | [email protected] | 09362000002 | Oliver | segment1 | | uid0000000004 | [email protected] | 09362000003 | Elijah | segment1 | | uid0000000005 | [email protected] | 09362000004 | James | segment1 | 📌 Add more segments simply by creating new sheets (segment3, segment4...) 📌 Change campaign by updating templateid in Setup Flow node --- 👤 Who’s it for? • Ecommerce ema