Send customized emails from Google Sheets data automatically
Workflow Description
Automation that extracts data from Google Sheets and sends personalized emails via Gmail based on defined conditions, with support for alert notifications on social media platforms.
How it works
- 1.Extract data from Google Sheets
- 2.Apply conditions and filter relevant records
- 3.Compose and send emails through Gmail
- 4.Log results back to the spreadsheet
Use cases
- Send automated sale confirmations to customers from a sheet list
- Distribute daily reports to team members based on specific criteria
Requirements
- Google account with Sheets and Gmail permissions enabled
- Properly formatted spreadsheet containing email addresses and message content
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (32)
Update last contacted time
Google Sheets
Set message template
Set
Email sequence
Set
Fill message placeholders
Code
Compose message
Set
Get previous message threads
Gmail
Get thread details
Gmail
Classify threads
Code
Next message due?
Filter
Sticky Note2
Sticky Note
Execute Workflow Trigger
Execute Workflow Trigger
Replying?
If
Send new message
Gmail
Call message send sub-workflow
Execute Workflow
Prepare reply params
Set
Prepare first message params
Set
Sticky Note4
Sticky Note
Call message send sub-workflow1
Execute Workflow
To email?
Filter
Decode messages
Code
Decode placeholder values
Code
Package placeholder values
Code
Settings
Set
Reply to message
Gmail
Get emails
Google Sheets
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Every hour
Schedule Trigger
Sticky Note3
Sticky Note
Don't email on weekends
Filter
Sticky Note8
Sticky Note