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-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 🚀