Communication
Send personalized Gmail messages from Google Sheets data
14 nodes
274
84
Scheduled trigger
Workflow Description
Automation that reads data from Google Sheets and sends customized email messages via Gmail based on specified conditions, with scheduled execution or manual triggering through a form.
How it works
- 1.Read rows and data from the designated Google Sheets worksheet
- 2.Evaluate conditions on the data to identify recipients and required content
- 3.Configure a personalized email message and send it via Gmail for each matching row
Use cases
- Send automated alert emails to customers based on Google Sheets updates
- Distribute periodic reports to your team from stored Google Sheets data
- Run personalized email campaigns to each subscriber from your contact list
Requirements
- Connected Google Workspace account with Gmail and Sheets permissions
- Worksheet containing data columns such as email address, subject, and message content
- Secure authentication enabled between n8n and Google services
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Google Sheets
Gmail
Form Trigger
Details
Trigger
Scheduled trigger
Nodes
14
Apps
3
Views
274
Downloads
84
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 (14)
/
Add Log in History
Google Sheets
Update Products Infos
Google Sheets
If price below price alert
If
List Products
Google Sheets
Format Product
Set
Schedule Trigger
Schedule Trigger
Scrap Product
HTTP Request
Notify Price Reduction
Gmail
Monitor Zalando Product
Form Trigger
Add Product
Google Sheets
Sticky Note1
Sticky Note
Sticky Note
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note