Build a complete email CRM with Google Sheets & MailerSend

Name: Build a complete email CRM with Google Sheets & MailerSend
Availability: InStock
Author: Nima Salimi

Build a complete email CRM with Google Sheets & MailerSend preview

Open on n8n.io

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER

Early Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

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

Nima Salimi

8 workflows

Nodes

n8n-nodes-base.scheduletrigger n8n-nodes-base.set n8n-nodes-base.filter n8n-nodes-base.if n8n-nodes-base.wait n8n-nodes-base.removeduplicates n8n-nodes-base.stickynote n8n-nodes-base.googlesheets

Complexity

advanced

Published 26 Oct 2025

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/10179/10179.json

Share Your Workflow

Have a useful automation to share? Publish it and help the community.

Submit Your Template How to Submit

Related Workflows

Auto-post Facebook and Instagram content with OpenAI, Google Sheets and review

**Who is this for?** This workflow is designed for social media managers, marketing agencies, and business owners who want to automate their Facebook and Instagram posting without losing quality control. It is perfect if you manage content in Google Sheets and want AI to write your captions, but you still need a human to review the final post before it goes live to your audience. **What this workflow does** This workflow acts as a complete social media auto-poster. It reads your product inventory from Google Sheets, finds items that haven't been promoted recently, and uses OpenAI to write a professional, engaging caption. Before publishing, the workflow pauses and sends you a simple web form. Once you click "Approve," it automatically publishes the post to Facebook and Instagram, then logs the successful post back in your Google Sheet. **Key Features** * **Smart Google Sheets Tracking:** Uses your spreadsheet as an inventory tracker to ensure you never over-promote the same product twice. * **AI Copywriting:** Automatically drafts platform-optimized, emoji-free captions based on your product data. * **Approval Gate:** Pauses the automation to let you manually review and approve the AI-generated content via an n8n web form. * **Multi-Platform Auto-Posting:** Connects directly to the Facebook Graph API to publish to your Facebook Page and Instagram Business Account. **How it works** 1. **Trigger:** Open the n8n form and choose to promote a specific product or a general agency pitch. 2. **Selection:** The workflow scans your Google Sheet and picks the item with the lowest "Times Posted" count. 3. **Generation:** OpenAI writes a tailored caption for the selected item. 4. **Review:** You receive an interactive prompt to review the text and image URL. 5. **Publishing:** Upon approval, it posts instantly to Meta (Facebook/Instagram) and increments the post count in your Google Sheet. **Set up steps** *Estimated time: 10 minutes* 1. **Google Sheets:** Connect your Google credential to the Sheets nodes and add your Spreadsheet ID. 2. **OpenAI Key:** Add your API key to the "AI Copywriter" node. 3. **Meta API:** Connect your Facebook Graph API credentials to the FB/IG nodes and ensure your Page ID is correct. 4. **Run:** Click "Test URL" on the Pixril Dispatcher form to trigger your first post! **About the Creator** Built by Pixril. We specialize in building advanced, production-ready AI workflows and automation templates for n8n. Find more professional workflows in our shop: **https://pixril.etsy.com**

View

Promote calendar events with OpenAI graphics to LinkedIn, X, and Facebook

Never let an event go unpromoted. This workflow monitors your Google Calendar, generates branded promotional graphics, and schedules a staggered social media countdown across LinkedIn, Twitter/X, and Facebook. --- ## 🎯 What This Workflow Does This template automates the full lifecycle of event promotion—from creation to multi-platform publishing. --- ### 📅 Step 1 — Calendar Trigger & Intelligence - **Instant Trigger:** Fires when a new event is created in Google Calendar - **Data Enrichment:** Extracts title, location, and formatted date/time - **Safety Gate:** Skips events starting in less than 2 hours --- ### 🖼️ Step 2 — Programmatic Design & CDN Hosting - **Dynamic Graphic Creation:** Uses Edit Image node to overlay event details on a banner - **CDN Hosting:** Uploads the image via UploadToURL to generate a public URL - **Schedule Calculation:** Sets post timings at 48h, 24h, and 1h before the event --- ### 🔁 Step 3 — Staggered Countdown & AI Copy - **Loop Execution:** Iterates through each scheduled post time - **Smart Wait:** Delays execution until the exact posting time - **AI Captions:** Generates time-based captions using OpenAI --- ### 📊 Step 4 — Audit Logging & Admin Alerts - **Google Sheets Log:** Stores platform status and image URLs for each post - **Telegram Alerts:** Sends a final campaign summary to the admin --- ## ✨ Key Features - **Automated Graphic Design:** Creates visuals for every event - **Persistent Wait Logic:** Handles long delays within a single workflow - **Multi-Platform Posting:** Publishes to LinkedIn, Twitter/X, and Facebook - **CDN Media Bridge:** UploadToURL ensures valid public image URLs --- ## 🔧 Setup Requirements ### Required Integrations - **Google Calendar:** OAuth2 credentials - **Social Platforms:** LinkedIn, Twitter/X, Facebook Page credentials - **OpenAI:** API key for captions - **Google Sheets:** Sheet for logging - **UploadToURL:** API key - **Telegram:** Bot token and chat ID --- ### Required Assets - Public URL of your base banner template image --- Automate your event marketing. Import this template and connect your Google Calendar to start promoting events effortlessly!

View

Post blog articles to LinkedIn and Twitter with OpenAI captions and UploadToURL

Turn your blog into a self-driving social media machine. This workflow monitors your RSS feed, extracts new content, and uses AI to craft platform-perfect posts for LinkedIn and Twitter/X, complete with hosted images. --- ## 🎯 What This Workflow Does This workflow automates the transition from "published on blog" to "live on social" in three primary stages: --- ### 🔁 Step 1 — RSS Trigger & Filter - **RSS Feed Trigger:** Polls your blog every 15 minutes to detect new articles - **Validation:** Ensures each item has a title and cover image before proceeding --- ### ☁️ Step 2 — Media Hosting Bridge - **Fetch Binary:** Downloads the blog’s cover image - **UploadToURL:** Uploads the image to a public CDN and returns a stable URL for social platforms --- ### 🤖 Step 3 — AI Multi-Platform Posting - **OpenAI Captions:** Generates: - LinkedIn → professional, long-form post - Twitter/X → short, punchy tweet with hashtags - **Parallel Publishing:** Posts simultaneously to both platforms - **Success Logging:** Tracks hosted image URLs and caption details --- ## ✨ Key Features - **Built-in Deduplication:** RSS ensures no duplicate posts - **Clean Data Processing:** Strips HTML for better AI output - **Fallback Logic:** Uses default caption if AI fails - **Reliable Media Hosting:** UploadToURL ensures public image access --- ## 🔧 Setup Requirements ### Required Credentials - **OpenAI:** API key - **LinkedIn:** OAuth2 credentials - **Twitter/X:** OAuth1 credentials - **UploadToURL:** API key --- ### Configuration - Add your blog’s RSS Feed URL - Adjust polling interval (default: 15 minutes) --- Ready to boost your blog’s reach? Import this template and automate your social presence instantly!

View

Need Custom Automation?

Get help designing a custom n8n workflow that connects your stack and fits your process.

Build a complete email CRM with Google Sheets & MailerSend

Workflow preview

Important notice

Overview

✉️ Automate MailerSend Email (Google Sheets)

🌐 Overview

✅ Key Features

📊 Database Sheets (Google Sheets Required)

transaction

template

segment1

👤 Who’s it for?

⚙️ Automations Included

Flow 1 — Insert Users (Triggered on schedule)

Flow 2 — Send Emails (Runs every 30 min)

🧠 Personalization Support

🔐 MailerSend Setup Required

💡 Optional Enhancements

📺 Connect With Me