AI Email Automation Workflow in n8n
This workflow uses n8n to send personalized emails automatically. It reads customer information from Google Sheets, checks which rows should receive an email, sends the emails one by one, and updates the sheet after sending.
1. Schedule Trigger
The Schedule Trigger starts the workflow automatically at a chosen time.
Step-by-step:
You choose a time or schedule.
n8n starts the workflow.
The next node receives the signal.
Example:
Run the workflow every day at 9:00 AM.
2. Google Sheets
The Google Sheets node reads customer information from your spreadsheet.
Your sheet may contain:
| Name | Email Sent | |
|---|---|---|
| John | john@example.com | No |
| Sarah | sarah@example.com | Yes |
n8n can read these rows and use the information in the next steps.
3. Filter
The Filter node checks which rows meet your condition.
For example:
Email Sent = No
Only customers who have not received an email should continue.
Simple flow:
All Rows → Check Condition → Keep the Correct Rows
This helps prevent sending the same email again.
4. Loop Over Items
The Loop Over Items node processes the selected rows one by one.
For example, if the Filter finds 5 customers:
Customer 1 → Customer 2 → Customer 3 → Customer 4 → Customer 5
This is useful when you want to personalize and send each email separately.
5. Gmail — Send a Message
The Gmail Send a Message node sends the personalized email.
n8n can use information from the current Google Sheets row.
For example:
Hi John,
We have a special offer for you.
The next customer may receive:
Hi Sarah,
We have a special offer for you.
So, one email template can use different customer names and other details automatically.
6. Update Row in Google Sheets
After the email is successfully sent, n8n can update that customer's row.
For example:
Email Sent: No → Email Sent: Yes
You can also save the sent time.
Example:
| Name | Email Sent | Sent Time | |
|---|---|---|---|
| John | john@example.com | Yes | 9:05 AM |
This creates a record of the automation.
7. Wait Node
The Wait node pauses the workflow for a chosen amount of time.
For example:
Send Email → Wait 30 seconds → Continue
This can help control the speed of the workflow instead of sending many emails immediately.
8. Complete Workflow
The basic workflow looks like this:
Schedule Trigger
↓
Google Sheets
↓
Filter
↓
Loop Over Items
↓
Gmail: Send a Message
↓
Update Row in Sheet
↓
Wait
↓
Next Item
The exact placement of Wait can vary depending on what you want the workflow to do.
9. Simple Real-Life Example
Suppose your Google Sheet has 20 customers.
The workflow runs at 9:00 AM.
Schedule Trigger starts the workflow.
Google Sheets reads the 20 rows.
Filter finds 8 customers with Email Sent = No.
Loop Over Items takes the customers one by one.
Gmail sends a personalized email.
Google Sheets changes No to Yes.
Wait pauses the workflow for the chosen time.
Loop Over Items continues with the next customer.
So, you do not have to send and update every email manually.
10. Important Definitions
Schedule Trigger
Starts an n8n workflow automatically at a scheduled time.
Filter
Checks data and allows only matching items to continue.
Loop Over Items
Processes multiple items one at a time.
Personalized Email
An email that uses information about the individual recipient, such as their name.
Update Row
Changes information in a particular Google Sheets row.
Wait
Pauses the workflow for a specific period or until a chosen condition occurs.
11. Five Questions With Answers
1. What starts the email automation?
Answer: The Schedule Trigger starts the workflow at the chosen time.
2. Why is the Filter node used?
Answer: It selects only the rows that meet a specific condition, such as Email Sent = No.
3. Why is Loop Over Items used?
Answer: It processes customers one by one so that each email can be handled separately.
4. What happens after Gmail sends an email?
Answer: The Google Sheets row can be updated, for example, by changing Email Sent from No to Yes.
5. Why can the Wait node be useful?
Answer: It pauses the workflow for a chosen time before continuing.
Quick Summary
Schedule Trigger → Read Google Sheets → Filter → Loop → Send Personalized Gmail → Update Sheet → Wait → Next Customer
Core Idea
The whole automation works like a small digital assistant:
Find the right customer → Send the right email → Record that it was sent → Move to the next customer.
.jpeg)