(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. ๐