(Full tutorial + workflow JSON included)
If you’ve ever wished your customer emails could send themselves, this one is for you.
I just published a new video showing how to turn a simple Google Sheet into a fully automated customer messaging system — powered by n8n + Gmail.
This workflow is perfect for:
- 🛒 Small businesses
- 👩💻 Solo creators
- 🧑💼 Agencies
- 📈 Anyone who wants consistent customer messaging without a fancy CRM
🔥 What the workflow can do
With this setup, you can automatically send:
- ✔ Thank-you emails after purchase
- ✔ Discount codes for returning customers
- ✔ Follow-up reminders
- ✔ Announcements
- ✔ Any custom message you type into the sheet
All you do is change Status = “Waiting for sending” and set the Date = today.n8n handles the rest.
🧠 What you’ll learn in the tutorial
Inside the video, I walk through:
- How to structure the Google Sheet
- How to filter rows safely (status, empty fields, date check)
- How to send emails with Gmail in n8n
- How to merge the Gmail response with the original row
- How to update the status back to “Sent successfully”
- How to run this every minute/hour/day automatically
And the whole workflow is 100% no-code.
📥 Download the workflow
You can grab the exact workflow JSON + sample Google Sheet template here (attached inside this post).
Feel free to copy it, remix it, and use it in your business or for your clients.
🎥 Watch the full tutorial
👇
Google Sheets Template
💬 Let me know:
Should I turn this into a “Customer Engagement OS” series with more advanced features?
- Segmentation
- Personalization
- AI-generated email content
- Dynamic scheduling
- Multi-step follow-ups
Comment below what you want next. 🙌